last entry of a particular date
 

I have a database in which I will enter 10 to 15 records daily, column a to
d. in column e i would like to return the cell value of last recrod of each
date from column d.
Pls help.

thanks

last entry of a particular date
 

where p1 has your date
checksa is the date range and checksd is the value range

=MAX(IF(ChecksA=P1,ChecksD))
this is an array formula that must be entered using ctrl+shift+enter vs just
enter.
--
Don Guillett
SalesAid Software

"shaji" wrote in message
...
I have a database in which I will enter 10 to 15 records daily, column a to
d. in column e i would like to return the cell value of last recrod of
each
date from column d.
Pls help.

thanks