| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Autonumber with Prefix and Category Grouping
Hi again,
Am Fri, 26 Apr 2013 22:19:07 +0200 schrieb Claus Busch: Then you can try in A4: ="25."&VLOOKUP(C4,$H$1:$I$10,2,0)&"."&COUNTIF($C$4 :C4,C4)&"." you don't need the dot at the end. Try: ="25."&VLOOKUP(C4,$H$1:$I$10,2,0)&"."&COUNTIF($C$4 :C4,C4) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#2
|
|||
|
|||
|
Wow, that worked perfectly! Thank you so much!
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I switch to my custom Function category ? | Excel Programming | |||
| How do I set up a custom cell format category? | Excel Worksheet Functions | |||
| How to assign a Category to a custom function? | Excel Programming | |||
| How do I make a custom category axis? | Charts and Charting in Excel | |||
Hybrid Mode
