how to find the results below using vlookup and max and if or any other fx?
sorry for the bad english hope that you can under stand the idea
best regards.
Capture1.GIF
names day how to find the result using vlookup ?
a 1
a 2
a 3
a 5 first min number for "a" first max number for "a"
a 6
a 7 first min number for "b" first max number for "b"
b 2
b 3
b 4
b 6
b 7
b 8
Bookmarks