'Is there a way to reference a cell in a range reference?
I am trying to write an if statement to return yes or no when a value is equal to a list of values whose number of rows is variable. example 1 ha 1 ha 1 ha 1 ha 2 ha 2 ha 2 he
so this statement would return no for the 1's and yes for the 2's
so far i created a countif(a:a,a1)(lets say this value is in c1) to count the number of 1s and 2s but for the next column I want to use if(c1=countif(b1:b(1+c1-1),b1, "no", "yes")(the b(1 will change but the -1 stays the same). I don't think that works but is there any way for me to do what I want to do.
Solution 1:[1]
In the end the answer was simple
=IF(COUNTIF(O:O, O5)=(COUNTIFS(O:O,O5,Q:Q,Q5)),"NO","YES")
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Andrew MacGregor |