•1 min read•from 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)&".","")
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#rows.com
#Excel alternatives for data analysis
#Excel alternatives
#Automatic column numbering
#Excel 365
#formula
#duplicate
#count as 1
#items highlighted in pink
#number 6
#SI function
#CONTARA function
#C22
#C2:C22
#help/support
#submitted by
#link
#comments
#discussion