Hello again Guys!
I am here again to ask for a formula: I have two columns. The first column is a set of letters with duplicates. I need to lookup or vlookup the second column but need to look for the last duplicate of the criteria being lookup.
Example: if i lookup for letter a using vlookup i should be getting the last cell in the column with letter a. So, ther answer should be 9.
a 3
b 2
a 1
c 6
c 8
d 5
a 9
I hope my example is clear.
Please help...
Thanks!
Bookmarks