View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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