View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
juggler juggler is offline
external usenet poster
 
Posts: 4
Default IF/THEN/ELSE for sequential numbers

I have a series of sequential numbers that I want to output as two
parts of a whole component.

Example: 1, 2, 3, 4, 5, 6, etc would become 1A, 1B, 2A, 2B, 3A, 3B,
etc.

I was thinking of assigning odd/even for A/B, but then I come out with
1A, 2B, 3A, 4B, etc. With 20 or more numbers it becomes even more
unwieldy.

Suggestions?