I have a list of items in column a and dates in b. some in a are duplicates. how can i vlookup an item an get its corresponding earliest date.
experiment ber.xlsx
in this example i want to get the earliest date for cat.
I have a list of items in column a and dates in b. some in a are duplicates. how can i vlookup an item an get its corresponding earliest date.
experiment ber.xlsx
in this example i want to get the earliest date for cat.
For this you would need an array formula
***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Formula:Please Login or Register to view this content.
Or you can also use aggregate function (regular formula)
Formula:Please Login or Register to view this content.
Format as Date
v A B C 1 Ball 1/3/2018 2 Kite 3 cat 1/5/2018 4 sat 5 dog 6 cat 1/3/2018
Last edited by AlKey; 05-01-2018 at 02:12 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
thanks it works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks