Forum Discussion
Solved
Excel Query
Reposting since I did a typo in last post. Hi everyone, Yellow highlighted column enteries are added manually. I want to insert a formula which will automatically write 1 in column "P" for ...
What is the point of asking the same question again? You already mentioned in your other discussion that you meant column P instead of column Q.
=IF(COUNTIF($C$2:C2, C2)=1, SUM(1/COUNTIF($C$2:C2, $C$2:C2)), ""), use this formula after that use fill down.