Im trying to create a spreadsheet that will allow me to tabulate hour totals
(which I know how to do), but also let me know the last date a process took
place. My thought was to have a second sheet with all the dates in a given 6
month period. When a process was performed I would go to that date and place
a hour total for that day in a row for that given date. My problem is making
that date show up on the first sheet (summary) of my spreadsheet, with out
manually populating it myself. So say I did 3 hours of work on 3/13/2006, I
would go to that date on my second sheet, put 3 in the 3/13/2006 column and
expect that date to show up on the front page as the last date that process
was performed. Im sure this is clear as mud, but maybe someone can help.
Thanks in advance.

Here's the answer to your question. The b2:b20 range needs to refer to
the column where you would input the hours worked; a2:a20 needs to
refer to your date range. You'll notice the {} brackets - this means
it is an array formula - you don't actually type these, you will hit
Ctrl+Shift+Enter when you are finished entering the formula (instead of
hitting Enter) and these will be automatically added. This means that
excel calculates on the entire range instead of just the first entry.
Let me know if you have questions or problems. Later - Chad

{=MAX((B2:B200)*A2:A20)}


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=514612

Thank you very much. This is perfect.

"cvolkert" wrote:


Here's the answer to your question. The b2:b20 range needs to refer to
the column where you would input the hours worked; a2:a20 needs to
refer to your date range. You'll notice the {} brackets - this means
it is an array formula - you don't actually type these, you will hit
Ctrl+Shift+Enter when you are finished entering the formula (instead of
hitting Enter) and these will be automatically added. This means that
excel calculates on the entire range instead of just the first entry.
Let me know if you have questions or problems. Later - Chad

{=MAX((B2:B200)*A2:A20)}


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=514612