| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
MAX formula with Associated DATE
Hi there
I have organised data into 2 Columns named DATE (A1:A10) and DATA (B1:B10) What I am looking at doing is creating a formula where it sources the highest and Lowest number in the DATA col. with the corresponding DATE as well. The first part I have worked out = MAX(B1:B10) and LOW(B1:B10) however I am unsure of how to get it to lookup the corresponding date. Thanks for any help. Patrick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| addition to my date formula...required | Excel Worksheet Functions | |||
| Excel formula with date constraints | Excel Discussion (Misc queries) | |||
| Formula with date constraints | Excel Worksheet Functions | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Threaded Mode
