| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search lowest value in a column and display the entire row | New Users to Excel | |||
| list, search, and display | Excel Worksheet Functions | |||
| SEARCH COLUMN BY NAME THEN DISPLAY CELL ON SAME ROW | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| search and display | Excel Discussion (Misc queries) | |||
![halper@lgblp.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
