T
Tracey
I'm looking for a formula that will determine if a value
is present in a range (column) and then look in that row
and determine if a cell in that row equals a certain
value. I know I can use {if(a1:a150="yellow",true,
false)} to do the first part.
How can I modify this to then have it look at the row
with "yellow" in the first column to see if say blue is in
column E of the same row. If this yellow/blue scenerio
occurs multiple times in a table, how can I make it count
the number of times it occurs?
Any ideas? Thanks
is present in a range (column) and then look in that row
and determine if a cell in that row equals a certain
value. I know I can use {if(a1:a150="yellow",true,
false)} to do the first part.
How can I modify this to then have it look at the row
with "yellow" in the first column to see if say blue is in
column E of the same row. If this yellow/blue scenerio
occurs multiple times in a table, how can I make it count
the number of times it occurs?
Any ideas? Thanks