Display a cell regarding another

[Igor Corail]

Hello

I was looking about matrice, but too much complicate for me

I've  4 words possible in A column     

I'm looking for:

For each  column A   value is   PDR ,    the name at his right

is display in   C10   and  for another  PDR  display in  C11 and so on.

And if C10 to C20 may be sorted, it will be so good.

Thanks for your help.

[#2]

Hi, Igor! You could try the solution in file.

[A2] : =IF(B2=D$9,1+SUMPRODUCT(--(B$2:B$7=D$9),--(C$2:C$7<C2)),""), And drag it down

[D10] : =IF(ROWS(D$10:D10)>MAX(A$2:A$7),"",VLOOKUP(ROWS(D$10:D10),A$2:C$7,3,)) And drag it down.

P.D:  I use SUMPRODUCT because you upload an .xls file.  If you have Excel 2007 and newer, you can use COUNTIFS instead.  Check file with this option. Blessings!