Index and Match - Repeating Digits Formula Help

[ststern45]

Hi everyone,

I need help in figuring out a formula.

Cell A1 = 2
Cell A2 = 3
Cell A3 = 3

Cell B1 = A
Cell B2 = B
Cell B3 = D

=======================================================================

Example #1 :

Now in cell:
A6 = 2
A7 = 3
A8 = 3

I'm trying create a formula that will place the following letters in cells A10, A11, and A12
Since there are duplicate values of the number 3 in cells A7 and A8.

A10 = A
A11 = B
A12 = D

=====================================================

Example #2 :

A6 = 3
A7 = 2
A8 = 3

Duplicate values of the number 3

I would like to have the following:

A10 = B
A11 = A
A12 = D

======================================================

Example #3 :

A6 = 3
A7 = 3
A8 = 2

I would like to have the following:

A10 = B
A11 = D
A12 = A

Thanks in advance!!

 

[Marcelo Branco]

Try this array formula in A10 copied down
=INDEX(B$1:B$3,SMALL(IF(A$1:A$3=A6,ROW(A$1:A$3)-ROW(A$1)+1),COUNTIF(A$6:A6,A6)))
Ctrl+Shift+Enter, not just Enter

M.

 

[ststern45]

Super!!

Thank you so much Marcelo

 

[Marcelo Branco]

You are welcome. Glad to help.

M.