| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help
Does anyone have any suggestions on how to solve the following.
P MCC A 589 1520 B 589 1520 A 542 1711 B 542 1711 I want to automate the addition of letters A & B to the spreadsheet where a pair exists between fields P & MCC, like in the above example. Can this be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help
Can there only be pairs or singles? and is data sorted or unsorted?
"DC" wrote: Does anyone have any suggestions on how to solve the following. P MCC A 589 1520 B 589 1520 A 542 1711 B 542 1711 I want to automate the addition of letters A & B to the spreadsheet where a pair exists between fields P & MCC, like in the above example. Can this be done? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help
Yes, there are singles and data is sorted by field 'P'
"Toppers" wrote: Can there only be pairs or singles? and is data sorted or unsorted? "DC" wrote: Does anyone have any suggestions on how to solve the following. P MCC A 589 1520 B 589 1520 A 542 1711 B 542 1711 I want to automate the addition of letters A & B to the spreadsheet where a pair exists between fields P & MCC, like in the above example. Can this be done? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help
If I understand you correctly then assuming that you do not have more than
26 different combinations of the same P & MCC and with the p's starting in B3 try: =CHAR(64+SUMPRODUCT((B3=$B$3:B3)*(C3=$C$3:C3))) If you could have more than 26 combinations of the same P & MCC then use: =LEFT(ADDRESS(1,SUMPRODUCT((B3=$B$3:B3)*(C3=$C$3:C 3)),4),LEN(ADDRESS(1,SUMPRODUCT((B3=$B$3:B3)*(C3=$ C$3:C3)),4))-1) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "DC" wrote in message ... Yes, there are singles and data is sorted by field 'P' "Toppers" wrote: Can there only be pairs or singles? and is data sorted or unsorted? "DC" wrote: Does anyone have any suggestions on how to solve the following. P MCC A 589 1520 B 589 1520 A 542 1711 B 542 1711 I want to automate the addition of letters A & B to the spreadsheet where a pair exists between fields P & MCC, like in the above example. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
