I need to highlight every entry in my spreadsheet where they share a value in one column but also all exceed a separate set value in another
Sequel to my 2 year old post I need to highlight every entry in my spreadsheet that either exceeds a set value in 1 column (A in this example) or shares the same value in another column (B) as those
I gotta filter some big spreadsheets in a couple of ways:
Where if (column B) exceeds a set value, highlight it and any in (column A) that share the same value in (column A)
As in 1, but only where all entries in column B that share a value in column A also exceed the set value
In this hypothetical I quickly mocked up in Numbers on my personal computer, the set value is 5. So for the first filter, I want it to look like this:
Which I can do with =IF(MAXIFS($B:$B,$A:$A,$A1)>=5,TRUE,FALSE)
For the second part I would want to only highlight these:
So that I can then take those values out of column A (in this example b and d) and list them somewhere else.
[link] [comments]
Want to read more?
Check out the full article on the original site