Thanks to all
On Fri, Oct 5, 2012 at 1:32 PM, Ms-Exl-Learner .
wrote:
> Hi Manoj,
>
> Go through the below for Non Array Formula Solution.
>
> *Try this for getting the Maximum Date based on Name*
>
> =SUMPRODUCT(MAX($A$2:$A$47*($C$2:$C$47=$E2)))
>
> *Try this for getting the ID based on Max
Hi Manoj,
Go through the below for Non Array Formula Solution.
*Try this for getting the Maximum Date based on Name*
=SUMPRODUCT(MAX($A$2:$A$47*($C$2:$C$47=$E2)))
*Try this for getting the ID based on Maximum Date of a name*
=SUMPRODUCT(($C$2:$C$47=$E2)*($A$2:$A$47=SUMPRODUCT(MAX($A$2:$A$47*($
Hi,
You can try pivot table. see below Snapshot.
Name Date ID Name1 01-10-2012 9558 02-10-2012 9565 03-10-2012 9564
04-10-2012 9563 05-10-2012 9562 06-10-2012 9561 07-10-2012 9559 Name2
01-10-2012 9559 02-10-2012 9558 03-10-2012 9565 04-10-2012 9564
05-10-2012 9563 06-10-2012 9562 0
Dear Viper,
Please can you solve it without erry..please help..
On Fri, Oct 5, 2012 at 11:47 AM, The Viper wrote:
> pfa
>
>
> On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar
> wrote:
>
>> Dear Expert,
>>
>>
>> Request you to kindly help me on this matter...
>> Please find the attachment..
>>
>>
pfa
On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar wrote:
> Dear Expert,
>
>
> Request you to kindly help me on this matter...
> Please find the attachment..
>
> I want id witch has on max dateeg:- if "name1" max date is 3-Oct it show
> 9564
>
>
>
>
> Regard
> Manoj
>
> --
> Join official facebook
Dear Expert,
Request you to kindly help me on this matter...
Please find the attachment..
I want id witch has on max dateeg:- if "name1" max date is 3-Oct it show
9564
Regard
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ me
