Forum Discussion

Igor Corail's avatar
Igor Corail
Copper Contributor
Jul 18, 2018

Display a cell regarding another

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.

Formulas & Functions
Need Help
  • John Jairo Vergara Domínguez's avatar
    John Jairo Vergara Domínguez
    Brass Contributor
    Jul 18, 2018

    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!

Resources