CODEWITHSUNDEEP
excelexcel-formulaarray-formulas
Arkadeusz91
Arkadeusz91

Reputation: 89

Returning all values with certain criteria

I need help with creating excel formula. I have a list of names in row 1 and list of values in row 2. I need a formula that would return all of the names from row 1 that has a certain value (lets call it "value1") in row 2. I know how to do that with VBA but I would rather avoid using macros if possible. I'm pretty sure it would be possible with array formulas but I'm not really good with it so I would appreciate a help.

Upvotes: 0

Views: 37

Answers (1)

Scott Craner
Scott Craner

Reputation: 152450

Something like this:

=IFERROR(INDEX($1:$1,AGGREGATE(15,6,COLUMN($A$2:$D$2)/($A$2:$D$2="X"),ROW(1:1))),"")

enter image description here

As it is copied down the selection will change.

Upvotes: 1

Related Questions