Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto date entry? | Excel Discussion (Misc queries) | |||
date entry without typing dashes | Excel Discussion (Misc queries) | |||
A DROP DOWN CALENDAR FOR DATE ENTRY | Excel Discussion (Misc queries) | |||
How do I set up Auotomatic date and time entry in an adjacent cell | Excel Discussion (Misc queries) | |||
Need help with automatic date entry | Excel Discussion (Misc queries) |