Posted to microsoft.public.excel.programming

Rick I

external usenet poster

Posts: 1

Capture date for =MAX(a1:a250) formula

My spreadsheet has a date column and an amount column. What I want to do is
get the date for the maximum in the amountcolumn.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I capture a date?	Capture a variable date & use with text	Excel Discussion (Misc queries)	3	November 27th 08 02:40 AM
Excel screen capture to capture cells and row and column headings	jayray	Excel Discussion (Misc queries)	5	November 2nd 07 11:01 PM
want to capture date	elegantpartner	Excel Discussion (Misc queries)	1	January 9th 06 04:20 AM
Formula to capture data on a date and preserve it	Jeff	Excel Worksheet Functions	0	October 11th 05 11:18 PM
How do I capture the Modified date in a cell?	rcg[_2_]	Excel Programming	2	March 9th 05 05:24 PM

All times are GMT +1. The time now is 02:17 AM.

About Us

"It's about Microsoft Excel"