Jul 17 2018
09:29 PM
- last edited on
Jul 31 2018
08:45 AM
by
TechCommunityAP
Jul 17 2018
09:29 PM
- last edited on
Jul 31 2018
08:45 AM
by
TechCommunityAP
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.
Jul 18 2018 06:56 AM
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!