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 unique enteries against column "C" and then write 2 in Column "P" for next unique entry in column "C".
Can somebody please help?
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.
2 Replies
=IF(COUNTIF($C$2:C2, C2)=1, SUM(1/COUNTIF($C$2:C2, $C$2:C2)), ""), use this formula after that use fill down.
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.
