ExcelBanter - Search a column and display a value

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Search a column and display a value (https://www.excelbanter.com/excel-programming/356794-search-column-display-value.html)

[email protected][_2_]

Search a column and display a value

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.

Stefi

Search a column and display a value

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.

All times are GMT +1. The time now is 11:54 PM.