Assuming you want:

50
100
150
200

Enter this formula in C1:

=MODE(A1:A6)

Enter this array formula** in C2 and copy down as needed:

=MODE(IF(COUNTIF(C$1:C1,A$1:A$6)=0,A$1:A$6+{0,0}))

No error checking and does not account for empty cells!

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)



--
Biff
Microsoft Excel MVP


"ONG" wrote in message
...
How to how to set up formula with more than 1 result

For example

A

1 50
2 100
3 50
4 150
5 100
6 200


if i use =mode(A1:A6) the result is 50, what should i do to make it
display
all result? I faced the same problem while using Vlook & Hlookup also

Ths