shivakanou
New Member
- Joined
- May 19, 2015
- Messages
- 8
Hello everybody!
I need help to tune my countif formula, it's something basic, but as it's not something taught by simple excel courses I'm a little bit lost.
I have a column (range C2:C288), where all the cells have the following formula:
So it will look up the column and give me only the distinct values.
Now I need to make a countif to return me how many values are distinct.
Obs 1: I had to use this count if formula
Because it was the only formula that returned the first distinct value, other formulas, like
Would return the last distinct, I don't know why.
Problem: As the "empty" cells still have a hidden formula, the formula
Returns the total amount of cells (287)
<tbody>
</tbody>
I need help to tune my countif formula, it's something basic, but as it's not something taught by simple excel courses I'm a little bit lost.
I have a column (range C2:C288), where all the cells have the following formula:
Code:
=IF(COUNTIF(B:B;B2)=1;B2;"")
Now I need to make a countif to return me how many values are distinct.
Obs 1: I had to use this count if formula
Code:
=IF(COUNTIF(B:B;B2)=1;B2;"")
Code:
=IF(A2="";"";IF(COUNTIF($A3:A288;A2)=1;A2;""))
Problem: As the "empty" cells still have a hidden formula, the formula
Code:
=COUNTIF($C2:$C288;"<>"&"")
Solution: Threat code cells as empty, but I don't know how Could you guys give me a hand? Thank you! |
<tbody>
</tbody>