Use lookup formula
=vlookup(G2,A$2$:E$8$,5,0)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: 14 September 2012 15:20
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ find the latest date
Dear Friends,
Please h
Hi Sundarvelan,
Use this CSE formula =MAX(IF(G2=A:A,E:E))
--
*Regards,*
*
*
*Excel Beginner*
On Fri, Sep 14, 2012 at 4:49 PM, Sundarvelan N wrote:
> Dear Friends,
>
> Please help me to find the latest date of a student.
> Thanks
> N.Sundarvelan
> 9600160150
>
>
--
Join
=SUMPRODUCT(MAX((A2:A10=g2)*(E2:E10)))
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Sundarvelan N
Sent: Friday, September 14, 2012 6:19 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ find the latest date
Dear Friends,
Please help me to f
Hi Sundarvelan,
Try this.
=MAX(E2:E8)
Regards,
Kuldeep Singh
On Fri, Sep 14, 2012 at 5:00 PM, Paul Schreiner wrote:
> If you sort the data by Date, in Descending order,
> a VLookup will return the first match, which will be the "latest" date.
>
>
> *Paul*
>
> -
If you sort the data by Date, in Descending order,
a VLookup will return the first match, which will be the "latest" date.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you ca
