Ashish,
Please ignore last message... printed page cut off balance of row. I will
try again.
"Ashish Mathur" wrote:
Hi,
I am sure there are better solutions to this problem but the one i am
proposoing is a non Array formula:
Link the list in column D to a worksheet starting from A1 i.e. go to a blank
worksheet and say =D1 and copy this down.
Now somewhere don below in Column C, type the foll formula -
=IF(A1="","",ROW(A1)).
In Cell D1, type the foll. formula
IF(ISERROR(INDEX($A$1:$A$9,IF(ISERROR(SMALL($C$13: $C$21,ROW(A1))),"",SMALL($C$13:$C$21,ROW(A1))),1)) ,"",INDEX($A$1:$A$9,IF(ISERROR(SMALL($C$13:$C$21,R OW(A1))),"",SMALL($C$13:$C$21,ROW(A1))),1))
Hope this helps,
Ashish Mathur
"Brian" wrote:
My worksheet (worksheet1)has data in cells a1:H50. Column D has some blank
cells and data in other cells. In worksheet 2, I would like to list in column
A, all of the values in worksheet1- (D1:D50) but with no blank cells in the
list. Thanks for help with this formula.
|