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?

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?

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?

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?