Just 4fun![]()
Here is one more alternative. It is short but it Only works in this example:
Frequency is normally an Array but if Ctrl+Shift+Enter is omitted Excel will use the first number.=SMALL(A1:A24,1+FREQUENCY(A1:A24,A1:A24))
And since the list is sorted...it works - but just in this case (meaning it's not a reliable solution)
//Ola
Bookmarks