Forum Discussion

ExcelGeek90's avatar
ExcelGeek90
Brass Contributor
Jul 18, 2025

Excel Query

Hi everyone, 

 

Yellow highlighted column enteries are added manually. I want to insert a formula which will automatically write 1 in column "Q" for unique enteries against column "C" and then write 2 in Column "Q"  for next unique entry in column "C". 

 

Can somebody please help?

excel

5 Replies

    • ExcelGeek90's avatar
      ExcelGeek90
      Brass Contributor
      Jul 18, 2025

      Thank you for your comment. I have realised a mistake in my post please replace Column "Q" with "P".

       

      Column highlighted in yellow which is column "P" is manually enetered 1 and 2 and I want to get that written through a formula. 

      If this helps you?

      p.s

       

      I will see if I can edit post after this comment.

Resources