help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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:C3)),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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top