It finds the maximum value in the range but it works with text
So b a; z9 z7; zzzz zz, etc
It finds what would be at the bottom of the range it you were to sort the
range in ascending order
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Dave F" wrote in message
...
Can someone please explain to me what this formula is doing?

=LOOKUP(2,1/((COUNTIF(D6:D41,""&D6:D41)=0)*(D6:D41<"")),D6:D 41)

Thanks.

Dave