1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Automatic column numbering excel 365

Good day, I need your help/support.

Automatic column numbering, but if there's a duplicate, it should count as 1.

The items highlighted in pink should only be number 6.

I'm currently using...

=SI(C22<>"",CONTARA($C$2:C22)&".","")

https://preview.redd.it/ca11nvtmg81h1.png?width=207&format=png&auto=webp&s=9c52382e7d97454269659cb5b2b8598afe7b0429

submitted by /u/Human_Limit_5638
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article