Hi,
I have a filtered column A, and I want to add a new column B by inserting auto-number(e.g. A01,A02...).
Is it possible?
Thanks
George
Hi,
I have a filtered column A, and I want to add a new column B by inserting auto-number(e.g. A01,A02...).
Is it possible?
Thanks
George
What happens beyond say A99 ?
In basic terms say A01 to Axx(x) etc then given filter requirement you could use SUBTOTAL along the lines of:
B2: =TEXT(SUBTOTAL(3,$A$2:$A2),"A000")
copied down
(assumes headers in row 1)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks