Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup !
Hello All,
I am looking some following solution : Sheet1 Table : Col_A (Date) Col_B (Name) Col_C (Amt) 01-Jan-2009 Japan 1500 02-Jan-2009 Singapore 2000 05-Jan-2009 Singapore 1700 06-Jan-2009 Japan 1000 10-Jan-2009 Korea 1500 Now I want get in Sheet2 just last date & Pmt Amt like as under : Japan 06-Jan-2009 1000 Singapore 05-Jan-2009 1700 Is it possible ? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |