Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return non-blank cells
I got the following formula from a book which was accompanied by a CD. I
downloaded the example which did exactly what I wanted. When I dluplicated the example on a new workbook, however, it did not work. {IFERROR(INDEX(Data,SMALL(IF(Data<"",ROW("1:"&ROW S(Data)))),ROW("1:"&ROWS(Data))))),"")} Data Result My Result 33 33 33 -10 -10 33 20 33 20 15 33 etc. I think I have the latest updates for 2007 and the book was of course written some time ago. I evaluated the formulas and the process was the same on both the download and my worksheet. Only the result was different. Can someone advise.? -- GeneS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
AVG or Return 1 value from either of 2 cells if one is blank | Excel Worksheet Functions | |||
Nested IF - return a blank when compared cells are blank | New Users to Excel | |||
Return All Non-Blank Cells | Excel Worksheet Functions | |||
Need Vlookup to return a value of $0.00 in blank cells | Excel Worksheet Functions |