In C1: 24
In C2: 31
In C3 and copied down
=if(rows(c$3:c3)<=$c$2,$c$1&" of "&rows(c$3:c3),"")
is it what you are looking for ?
In C1: 24
In C2: 31
In C3 and copied down
=if(rows(c$3:c3)<=$c$2,$c$1&" of "&rows(c$3:c3),"")
is it what you are looking for ?
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Posting Permissions
Reply With Quote
Bookmarks