Display a cell regarding another

%3CLINGO-SUB%20id%3D%22lingo-sub-216609%22%20slang%3D%22en-US%22%3EDisplay%20a%20cell%20regarding%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216609%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20was%20looking%20about%20matrice%2C%20but%20too%20much%20complicate%20for%20me%3C%2FP%3E%3CP%3EI've%26nbsp%3B%204%20words%20possible%20in%20A%20column%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20for%3A%3C%2FP%3E%3CP%3EFor%20each%26nbsp%3B%20column%20A%26nbsp%3B%20%26nbsp%3Bvalue%20is%26nbsp%3B%20%26nbsp%3BPDR%20%2C%26nbsp%3B%20%26nbsp%3B%20the%20name%20at%20his%20right%3C%2FP%3E%3CP%3Eis%20display%20in%26nbsp%3B%20%26nbsp%3BC10%26nbsp%3B%20%26nbsp%3Band%26nbsp%3B%20for%20another%26nbsp%3B%20PDR%26nbsp%3B%20display%20in%26nbsp%3B%20C11%20and%20so%20on.%3C%2FP%3E%3CP%3EAnd%20if%20C10%20to%20C20%20may%20be%20sorted%2C%20it%20will%20be%20so%20good.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-216609%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-216709%22%20slang%3D%22en-US%22%3ERe%3A%20Display%20a%20cell%20regarding%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-216709%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20Igor!%20You%20could%20try%20the%20solution%20in%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%5BA2%5D%20%3A%20%3CEM%3E%3DIF(B2%3DD%249%2C1%2BSUMPRODUCT(--(B%242%3AB%247%3DD%249)%2C--(C%242%3AC%247%3CC2%3E%2C%20And%20drag%20it%20down%3C%2FC2%3E%3C%2FEM%3E%3C%2FSTRONG%3E%3CEM%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%5BD10%5D%20%3A%20%3CEM%3E%3DIF(ROWS(D%2410%3AD10)%26gt%3BMAX(A%242%3AA%247)%2C%22%22%2CVLOOKUP(ROWS(D%2410%3AD10)%2CA%242%3AC%247%2C3%2C))%3C%2FEM%3EAnd%20drag%20it%20down.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EP.D%3A%3C%2FSTRONG%3E%26nbsp%3B%20I%20use%20SUMPRODUCT%20because%20you%20upload%20an%20.xls%20file.%26nbsp%3B%20If%20you%20have%20Excel%202007%20and%20newer%2C%20you%20can%20use%20COUNTIFS%20instead.%26nbsp%3B%20Check%20file%20with%20this%20option.%20Blessings!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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.

1 Reply
Highlighted

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!