Dear Champs...
Excellent !!! & working superb & thanks so much !!!
Have a great day!!
JP.
On Wed, Jul 4, 2012 at 1:01 PM, NOORAIN ANSARI wrote:
> Dear JP,
>
> Please try
>
> with ctrl+shfit+Enter
> =LARGE(IF(A2:A18=A22,C2:C18,""),1)
>
> Without ctrl+shfit+enter
> =SUMPRODUCT(MAX((A2:A18=A22)
Dear JP,
Please try
with ctrl+shfit+Enter
=LARGE(IF(A2:A18=A22,C2:C18,""),1)
Without ctrl+shfit+enter
=SUMPRODUCT(MAX((A2:A18=A22)*(C2:C18)))
see attached sheet.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Wed, Jul 4, 2012 at 12:53 PM, Mari
Hi,
Please this formula in C22 & Drag it down. (Apply with "Ctrl+Shift+Enter"
=MAX(IF($A$2:$A$18=A22,$C$2:$C$18,""))
On Wed, Jul 4, 2012 at 11:11 AM, Jayaprakash S
wrote:
> Dear Experts,
>
> Please help to get the Grade wise Maxium total through formula for the
> enclosed data.
>
> Many Thanks
Dear Experts,
Please help to get the Grade wise Maxium total through formula for the
enclosed data.
Many Thanks
JP.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Cod
