Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup function??
i have a range which contains a series of values some are numbers some are
text and some are spaces. I want to create a copy of this list further up the sheet but without the spaces. I have tried using the lookup function and the lookup function with match but always have trouble returning both numbers and text. So I want cell C3 to return the first non empty cells value in range C50:C150 and C4 to return the second non empty cell in the same range and so on to a total of 15 values (c18). any ideas ?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
Lookup Function | Excel Worksheet Functions | |||
need help with lookup function | Excel Worksheet Functions | |||
Lookup function | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |