Thread: membercode check
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Master Blaster Master Blaster is offline
external usenet poster
  
Posts: 17
Default membercode check
Sort then Ascending in column A

typ in colum B1 the correct short version.

type in B2
"=IF(LEFT(A2,4)=LEFT(B1,4),LEFT(A2,4)&MID(B1,5,2)+ 1,LEFT(A2,4)& 1)"

copy down.

regards

Reply With QuoteReply With Quote