View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Formula to Increment by Letter not Number

I was wondering if there is a way to make a formula increment to the next
letter character instead of the next number. For instance...

=IF(B3="","",A2+1) will give me 1, 2, 3, 4 etc...

but what if I want to go by letters or even add letters to the end?

=IF(B3="","",IF(B3<B2,A2+1,A2&"a")) where A2 is either 0 or 1
=IF(B3="","",IF(B3<B2,A2+1)) where A2 is either A or AA or 1A or A1


Well, Thanks In Advance,
Rob