Functions

how do I unmerge an entire spread sheet in excel?
... 2 Feb 2010 17:30

Excel 7.0 - removing duplicates
"wonderbug" wrote: I am using xl7.0. I have located ribbon & remove duplicates, but cannot seem to get correct result. I am using it against 6 cols of data. Is that my problem? I am sure there is something I am obviously doing wrong, but new 2 xl7.0. Data Col1 Col2 Col3 ... 2 Feb 2010 17:30

Can I use an "=" in Excel 2007 cell without making it a function?
I need the use the equal sign -- "=" -- in a worksheet without Excel assuming I'm begining a function or formula. I changed the cell to "Text" format, but it didn't help. Surely there is a way to do it, but I can't find the answer anywhere. ... 2 Feb 2010 17:30

Why this formulo not working
Hello all, I made a simle formula =A1+C1+E1+G1 and no answer in I1, But the answer you can find in the fx button next to the formula bar. May be has to do with merging B1 D1 F1 H1 with the next line? -- Naftoli ... 2 Feb 2010 17:30

Copy and Paste from One SS to Another
I am trying to copy and paste some data from one spread sheet to another (both Excel 2007). The cells ,where info supposed to land, show as selected, but no data displayed. Any suggestions aprriciated. ... 2 Feb 2010 17:30

Switch lookup function to another sheet
I have a sheet which is looking up data from another sheet, and I want change that "lookup sheet." How do I do this quickly? Example: =LOOKUP($A1,'Sheet 1 Original'!B1:B3,'Sheet 1 Original'!C1:C3) I want to change that "Sheet 1 Original" reference to "Sheet 1 New," in 100 cells at once. Thanks! ... 2 Feb 2010 17:30

How to get SUMPRODUCT on filtered cells
I'm currently using the formula =SUMPRODUCT((F2:I1475>=1)*(F2:I1475<=9999)) This gives me the number of the full range of cells but I need this to update whenever I use a variety of filters. Any help is greatly appreciated Sam.D ... 2 Feb 2010 17:30

Find value in a Range of Cells and perform Conditional Formatt
Hi Mike, I am not able achieve this. I tried this both on Excel 2003 and Excel 2010 beta. Regards, Kamlesh ... 2 Feb 2010 17:30

pivot table calculated field or item
Hi, my question is..I want to use an If formula based on the Grp colomn value BU (see formula below), but it doesnt recognise the value as "BU", it just returns the false value (value if false). Pivot table rows are as follows SO # Grp Cust Whse SO 311450 BQ BAKERS S 10-Nov-Tue 312385 0 MODERN S 12-Nov-... 2 Feb 2010 17:31

Deleting worksheets in a macro
I have a macro that at the end there are 2 work sheets that I delete. When the macro runs, it stops and asks if I really want to delete the worksheets. Is there something I can add so that it will not ask me if I want to delete? Here is what I have. Sheets("Sheet3").Select ActiveWindow.SelectedSheet... 2 Feb 2010 17:30