Forum Discussion
Check cells for matching data and assigning values based on this
So here's my situation: I am creating a sheet where I have nine groupings of three cells each, where the items chosen are all contained in lists made via data validation. What I need to do is have...
You have to check if a color is already written in a previous cell. To do so, you have to use COUNTIF and check IF that counter is above 0.
IF(OR(COUNTIF(PREVIOUS_COLORS_range;NEW_COLOR_1)>0;COUNTIF(PREVIOUS_COLORS_range;NEW_COLOR_2)>0;COUNTIF(PREVIOUS_COLORS_range;NEW_COLOR_3)>0);0;1)
Check the attachment if I understood right.
Thank you so much! I hadn't even thought of using the COUNT function, my brain was so fizzled trying to work out IF with AND, OR, or NOT functions that I didn't think of it. So Thank You very much! :D
- Sorry for the doublepost but after I sent the first, the system didn't show it. So I thought it was somehow lost or deleted and I did it again.
Whuups I did it again...
