Forum Discussion
ExcelGeek90
Jul 18, 2025Brass Contributor
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 ...
- Jul 18, 2025
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.
SarabjeetKumar
Jul 18, 2025Copper Contributor
=IF(COUNTIF($C$2:C2, C2)=1, SUM(1/COUNTIF($C$2:C2, $C$2:C2)), ""), use this formula after that use fill down.