No announcements
Found 2940272 threads
-
0 VotesHow to separate or group up the cells values which is having same formula among several formulas in a excel sheet???
, right now I am trying to find out the formula in a excel sheet and I don't know how to explain my problem, as ...Unanswered | 2 Replies | 437 Views | Created by parthi21991 - Monday, July 25, 2016 3:58 AM | Last reply by parthi21991 - Tuesday, July 26, 2016 6:16 AM
-
0 Votes
MIGRATING DATA AMONG CELLS OF SAME SHEET
/paste/print via macros/vba What is the bestUnanswered | 2 Replies | 257 Views | Created by rjagathe - Friday, November 16, 2018 6:07 PM | Last reply by Lina-MSFT - Wednesday, November 21, 2018 7:16 AM -
0 Votes
Formula in Excel Sheet
footer. We are aware that this severely limits the utility of formulas in Excel, and are considering ways to improve it. We do ...Answered | 1 Replies | 6940 Views | Created by Sandip Shinde - Thursday, October 26, 2006 2:30 PM | Last reply by Geoff Krapf - MSFT - Thursday, October 26, 2006 5:35 PM -
0 Votes
How to lock the cells in Excel sheet using asp.net
hi, i am using gridview control to export data from database to excel sheet but i am not protect(lock) the cells . pls give ...Unanswered | 0 Replies | 3806 Views | Created by Satyanarayna.Vatturi - Friday, September 24, 2010 4:46 AM -
0 Votes
Excel Formula or VBA Code to find out which cells add up to a specified number?
Assume an Excel worksheet range from A1:C10 is filled with numbers. Has anyone attempted to write a formula or some VBA code ...Answered | 5 Replies | 9162 Views | Created by Marak60 - Wednesday, June 16, 2010 9:03 PM | Last reply by pasync - Tuesday, November 4, 2014 4:44 PM -
0 Votes
Excel sheet name in a formula
reference to correct corresponding sheet. How can I set these formulas so that they have a variable for the sheet name that ...Answered | 1 Replies | 4027 Views | Created by DJS19 - Tuesday, September 1, 2009 3:10 PM | Last reply by priyankh11 - Wednesday, September 2, 2009 2:53 PM -
1 Votes
formula to write a select statement in excel sheet
I am trying to write a select statment in the excel sheet. I have list of database,table names,columnname given ...Answered | 2 Replies | 14080 Views | Created by anki2010 - Monday, June 6, 2011 5:32 PM | Last reply by anki2010 - Monday, June 6, 2011 6:11 PM -
0 Votes
Read value cells with formulas
Hi I have an excel that have cells with some formulas. I trie to read those cells with open xml sdk code snippets, but i just get ...Unanswered | 1 Replies | 5722 Views | Created by Levimatt - Tuesday, September 29, 2009 11:23 AM | Last reply by lambird - Thursday, June 9, 2011 1:12 AM -
0 Votes
Entering formulas in cells from VBA code in Excel
Hi, This applies a very simple formula to column B for the row(s) that change. Note if cells B:M are protected you will need ...Unanswered | 2 Replies | 4660 Views | Created by conjurer - Sunday, March 11, 2007 6:03 AM | Last reply by conjurer - Monday, March 12, 2007 5:21 AM -
0 Votes
Refresh all cells containing formulas in Excel
Hi, I have the same issue, but I am new to Excel and VSTO, how do you register all the cells containing the ...Answered | 3 Replies | 6547 Views | Created by ToM201 - Thursday, October 23, 2008 7:14 AM | Last reply by kalamantina - Tuesday, August 9, 2011 8:53 PM -
0 Votes
Excel sheet Pre Populated Formulas values not refreshed
InsertAfter and this helped me to a point, the difficulty here is now i have the formula ...Answered | 5 Replies | 731 Views | Created by MANOJ MATHE - Friday, January 5, 2018 9:32 PM | Last reply by Terry Xu - MSFT - Monday, January 15, 2018 9:00 AM -
0 Votes
How to carry several rows of formulas
against the Item ID to a table in a separate worksheet. Due to the images, I'm unable to click and ...Unanswered | 1 Replies | 411 Views | Created by andyrocks_a - Monday, September 23, 2019 8:24 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Tuesday, September 24, 2019 1:09 PM -
0 Votes
Efficient programmatic way to determine which cells have associated formulas?
I have a plugin for Excel. I need to make a determination of which cells have formulas in a given Workbook. ...Answered | 2 Replies | 323 Views | Created by Peter J Thompson - Friday, May 22, 2015 1:49 PM | Last reply by Peter J Thompson - Tuesday, May 26, 2015 11:23 AM -
0 Votes
Protecting formulas in cells
Hello, Other than coding formulas, is there a way to protect a cell in an excel spreadsheet, no mater, if the ...Answered | 6 Replies | 3734 Views | Created by chrstdvd - Saturday, January 6, 2007 10:09 PM | Last reply by chrstdvd - Sunday, January 7, 2007 8:16 PM -
2 Votes
how to find minimum among several values in map
8 How to calculate a minimum value and its corresponding value, such that, mymm and mymap are compared for the same values ...Answered | 3 Replies | 1484 Views | Created by Shel88 - Thursday, August 7, 2014 8:45 AM | Last reply by Barry-Schwarz - Friday, August 8, 2014 7:52 AM -
0 Votes
How to insert automatically =if('formula already in cell'="","",'formula already in cell') in several cells?
Hi all, I have initially populated a master sheet with a lot of =INDIRECT() formulas that picks up data from other tabs. What I ...Proposed | 1 Replies | 193 Views | Created by UnNa7uRal - Thursday, June 29, 2017 8:15 PM | Last reply by Hans Vogelaar MVP - Thursday, June 29, 2017 9:24 PM -
0 Votes
Formulas in Excel. How to keep the formula when inserting a new column.
formulated everything right after reviewing the answers online on how to prevent formulas from not working when inserting a new ...Unanswered | 2 Replies | 567 Views | Created by Sputnik2016 - Thursday, October 20, 2016 7:05 PM | Last reply by Chenchen Li - Monday, October 24, 2016 5:00 PM -
0 Votes
Formulas in Sharepoint List (Data Sheet View)
and have just started looking for the possibility managing some data in Sharepoint list (data sheet view), which were earlier managed in excel. ...Unanswered | 0 Replies | 9736 Views | Created by Jeevan Earappa - Friday, May 11, 2007 11:49 AM | Last reply by Jeevan Earappa - Friday, May 11, 2007 11:49 AM -
0 Votes
C#: How to get all formulas used in a formula
Hi, Base on the description, you want to get all formulas used in a formula. As far as I know, there is no such ...Answered | 1 Replies | 437 Views | Created by Bhaumik26 - Wednesday, April 23, 2014 4:40 PM | Last reply by Fei Xue - Thursday, April 24, 2014 8:42 AM -
0 Votes
Adding rows to Excel sheet, formulas not copying down automatically
Mike: I don't think SSIS is the tool to be copying Excel formulas because even if you could determine the Row Number ...Answered | 1 Replies | 4636 Views | Created by MikeChicago - Thursday, July 15, 2010 4:27 PM | Last reply by Todd C - Thursday, July 15, 2010 5:10 PM - Items 1 to 20 of 2940272 Next ›
No announcements
