If Statement and Lookup for a row

[KBecker]

I have a few rows of data with ~100 values in each row. The header (category) row contains names and the row below it has numerical values. I would like to write an if statement that looks at the 2nd row of numbers and then displays any "categories" where the number is less than 2. I know how to do this with a lookup function, but it would spread out my values across the 100 columns...not very presentable.

Is there a way to display any categories that have values less than 2 in a nice chart or table that isn't 100 columns long?

[ajryan88]

Hi,

Something like this what you're after? (The blue cells)

Hope it helps

[KBecker]

That's perfect! I've never used array formulas until now, so thanks for the help!

[ajryan88]

You're welcome

Please don't forget to mark this thread as solved (Thread Tools --> Mark As Solved), and please click on the * next to my post to say thanks