Tks Max.
Tried it, but, got the result n/a..., will copy past your to see the result
Tks
"Max" wrote:
How about adapting the expression that Ron C. gave you in an earlier posting?
To suit it here for your col C data in C1:C28, try array-entered:
=MAX(FREQUENCY(IF(C1:C27=(C2:C28),ROW(C1:C27)),IF( C1:C27<(C2:C28),ROW(C1:C27))))+(COUNT(1/(C1:C27=(C2:C28)))0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---