| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup and return first...
Hi everybody
I have a problem which i can't solve. I have a matrix as follows A B 1 JJ 20/4 2 FD 17/4 3 JJ 18/4 4 FD 19/4 How can i write a code in column B below that return the first date that is in column B in the matrix above so at it looks as the matrix below. A B 1 JJ 20/7 2 FD 17/4 thanks in advande |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ensure LOOkUP does not return #N/A | Excel Worksheet Functions | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| I need a Lookup to return more than 1 result | Excel Worksheet Functions | |||
| Lookup and return | Excel Worksheet Functions | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
Threaded Mode
