Create list from criteria

  • Thread starter Thread starter Sunnyskies
  • Start date Start date
S

Sunnyskies

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.
 
=IF(ISERROR(SMALL(IF($B$1:$B$9=A$10,ROW($A$1:$A$9),""),ROW($A1))),"",
INDEX($A$1:$A$9,SMALL(IF($B$1:$B$9=A$10,ROW($A$1:$A$9),""),ROW($A1))))

this is an array formula, so commit with Ctrl-Shift-Enter, not just Enter
 
Morning Bob,

Thanks for the quick response, but do not want to use array's

Sunnyskies
 
Then do it your way.

What is wrong with arrays?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
The end users are not computer literate.

Bob Phillips said:
Then do it your way.

What is wrong with arrays?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...
 
Back
Top