Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Morning from a Sunny RSA,
I have a list: Column A Column B Unit # Unit Type 98R01 Rigid 97D02 Drawbar 00R03 Rigid 02S02 Semi Now in a cell A10 I have got the word Rigid, and in cell A11 down I want to list all the unit ids that match the word Rigid as in column B. The in column B10 the word Drawbar with the formula in B11 to pull that unit #. The same for the unit type Semi. Answer should be: Rigid Drawbar Semi 98R01 97D02 02S02 00R03 Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract list of units based on error criteria to new list | Excel Worksheet Functions | |||
Extract list of units based on error criteria to new list | Excel Worksheet Functions | |||
Can you create a LIST and DATA VALIDATION CRITERIA in same cell? | Excel Discussion (Misc queries) | |||
Create list of text matching criteria | Excel Worksheet Functions | |||
Create a list based on single shared criteria | Excel Worksheet Functions |