Thread: Add incremental character to cell value at change in value 449becomes 449-A 510 becomes 510-B
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Add incremental character to cell value at change in value 449 becomes 449-A 510 becomes 510-B
Hi Jen,

Am Thu, 3 May 2012 09:28:58 -0700 (PDT) schrieb JenIT:

order invoice I would like it to become........
449 12000 12000 - A
510 12000 12000 - B
510 12000 12000 - B these stay the
same because order number did not change
510 12000 12000 - B these stay the
same because order number did not change
535 12001 12001 - A
535 12001 12001 - A these stay the
same because order number did not change
540 12001 12001 - B
544 12001 12001 - C

order in column A and invoice in column B then in C2:
=B2&" - A"
in C3:
=IF(A3&B3=A2&B2,C2,IF(AND(A3<A2,B3=B2),B3&" - "&CHAR(CODE(RIGHT(C2,1))+1),B3&" - A"))
and fill down


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote