when using:

C3:H204 = named range = rng

Enter this formula in A3:

=MODE(rng)

Enter this array formula** in A4 and copy down a total of 5 cells (or as
needed):

=IF(ROWS($1:2)<=COUNT(1/FREQUENCY(rng,rng)),MODE(IF(COUNTIF(A$3:A3,rng)=0, rng)),"")

Enter this formula in B3 and copy down as needed:

=COUNTIF(rng,A3)

The formula,

=IF(ROWS($1:2)<=COUNT(1/FREQUENCY(rng,rng)),MODE(IF(COUNTIF(A$3:A3,rng)=0, rng)),"")

It does work for the next number, but for the third number the formula shows
up in the cell even though I press (ctrl shft entr) not the numer. What am I
doing wrong???