"bridgerbell" wrote:
i like using max's function but it includes zeroes. is there a way to
adjust max's function to exclude zeroes?

Glad you liked it.

Think we could just tweak the criteria formula in col C

Try instead in C1, copied down:
=IF(OR(A1="",A1=0),"",IF(COUNTIF($A$1:A1,A1)1,"", ROW()))

(No change to formulas in col B)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---