How to put x and numbering every other 2 Coloumns. Please see attachement for details.
How to put x and numbering every other 2 Coloumns. Please see attachement for details.
In C6 and filled right
=IF(MOD(COLUMNS($A:A)-1,3)=0,"x","")
In C9 and filled right
=IF(C6="x",COUNTIF($C6:C6,"x"),"")
If you aren't going to have both the x row and the numbered row, this will work in numbered row, In C9 copied right
=IF(MOD(COLUMNS($C$1:C$1),3)=1, MAX($B$9:B$9)+1,"")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks for Support. It really helped
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks