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)
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
„halper@lgblp.com” 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 [quoted text clipped - 9 lines] > > Thanks for your help.