S sa.1985 Member Apr 28, 2012 #1 A B C D A1 1 10 1 =answer here A2 1 20 A3 2 5 A4 2 6 As per above data we required result in D1 Cell. Maximum value according to C1 cell from B column , in sort . C1 = A1 then answer B2 (20) means maximum value
A B C D A1 1 10 1 =answer here A2 1 20 A3 2 5 A4 2 6 As per above data we required result in D1 Cell. Maximum value according to C1 cell from B column , in sort . C1 = A1 then answer B2 (20) means maximum value
Faseeh Excel Ninja Apr 28, 2012 #2 Hi sa.1985, Kindly explain your question what do you want an how? Please pick up an example and elaborate. Faseeh
Hi sa.1985, Kindly explain your question what do you want an how? Please pick up an example and elaborate. Faseeh
SirJB7 Excel Rōnin Apr 29, 2012 #4 @Montrey Hi! I don't think so because of "according to C1 cell from B column", which I don't understand neither. Regards!
@Montrey Hi! I don't think so because of "according to C1 cell from B column", which I don't understand neither. Regards!
Montrey Member Apr 29, 2012 #5 @sirjb7 Yea I can't understand what the poster is asking at all. So I just posted what might be the answer.
@sirjb7 Yea I can't understand what the poster is asking at all. So I just posted what might be the answer.
