| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF or vlookup formula
Working fine now. thank you all.
"Max" wrote: Just replace ROW() with ROWS($1:1), viz use in D2, copied down: =IF(ROWS($1:1)COUNT(C:C),"",INDEX(A:A,SMALL(C:C,R OWS($1:1)))) -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Rob" wrote: Thank you all for your answers they have all worked fine. One more questiuon though using the formula that Max wrote, how can I change it to read row 2. I have inserted a header in row 1 and therefore miss the first line of data when i use the formula in D2 instead of D1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternative formula to the vlookup formula? | Excel Worksheet Functions | |||
| convert vlookup formula to link formula | Excel Worksheet Functions | |||
| VLOOKUP Formula | Excel Discussion (Misc queries) | |||
| Using VLOOKUP formula | Excel Discussion (Misc queries) | |||
| Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
