If your numbers are in A1:A100 then in C2

=MODE(A1:A100)

in C3 copied down

=MODE(IF(ISNA(MATCH(A$1:A$100,C$2:C2,0)),A$1:A$100 ))

confirmed with CTRL+SHIFT+ENTER


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=532465