Create coded list in excel

[Closed]
Report
-
Posts
2811
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 27, 2021
-
Hello my most humble computer users,

I have a hard one here...And I think it will be harder to explane...
I have an excel file that has a several destinations with a unique code (e.g. Dest-aa, Dest-bb, Dest-cc..) and several zones (e.g. A,B,C) and for each of the zones I have to create a serial number for each group to mail merge onto the letter...for example zone A, Destination aa requires 20 passes (A-aa-1, A-aa-2 and so on to 20) then 35 for zone B (B-aa-1...B-aa-35)
The Excel file kinda looks like:
Zone Dest-aa Dest-bb Dest-cc
A----- 20------ 35------ 54
B----- 52------ 45------ 47
C -----75 ------54------ 58
How Can I do this?

Thank you for your valuable time,

Love and respect
Sak01

1 reply

Posts
2811
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 27, 2021
484
Hi Sak01,

How does Excel know that zone A destination aa requires 20 passes?

Consider the possibility to upload (www.speedyshare.com) your workbook (without any personal info) to clarify your query.

Best regards,
Trowa