In cell A1, and fill down as necessary:
=LARGE(B$1:B$5,ROW())
Adjust B$5 to the end of your range!

Regards,
Stefi


€� ezt Ã*rta:

What I'm trying to do is have a formula search column B and then
display the values in column in the order they appear in column B. Is
there anyway to do this without using VBA?
(See Below)

Column A Column B
20 0
10 0
20
0
10


Thanks for your help.