Forum Discussion
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...
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!