Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Max Date
Works PERFECTLY!
Thanks so much! Stacy "J.E. McGimpsey" wrote in message ... One way: Dim rng1 As Range Set rng1 = Range("J1:K7") Range("A1").Value = Evaluate("MAX((" & rng1.Columns(1).Address _ & "=""FR"")*(" & rng1.Columns(2).Address & "))") Range("A2").Value = Evaluate("MAX((" & rng1.Columns(1).Address _ & "=""MA"")*(" & rng1.Columns(2).Address & "))") Adjust rng1 to suit your table. In article , (Stacy) wrote: I have 2 columns, one is a version one is the date: Based on the version, I want to find the max date. Version Date - - - - - - - MA 10/01/03 IH 10/07/03 FR 09/05/03 MA 10/08/03 FR 10/07/03 So I want to be able to get the Max Date for FR - 10/07/03 and put it in cell A1 and get the max Date for MA - 10/08/03 and put it in cell A2. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Max Date
In your second sheet, select the cell you want to have the first max
date in, and type "=" (without the quotes). While in edit mode, switch to the first sheet and click on the max date. Type Enter. XL will enter the link. Or you can directly type: ='Sheet1'!A1 Note that the single quotes are only really necessary if the sheet name has a space in it. You can do the same thing with the other workbook. You'll end up with something like: ='[Book1.xls]Sheet1'!A1 while your first (source) workbook is open. When it's closed XL will display the file path as well. In article , (Stacy) wrote: I have two more questions: I have multiple worksheets in my workbook, all of which I want the max date of Sheet1. Is there a way to evaluate the date on Sheet2 using the range from Sheet1 without copying and pasting? I also have a second file that I would like to put these dates in based on the first file, is there a way to use the range from one file and put the output in another? Am I just better off copying and pasting once the original calculation is made? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Max Date
Thank you so much for your help.
It works great! "J.E. McGimpsey" wrote in message ... In your second sheet, select the cell you want to have the first max date in, and type "=" (without the quotes). While in edit mode, switch to the first sheet and click on the max date. Type Enter. XL will enter the link. Or you can directly type: ='Sheet1'!A1 Note that the single quotes are only really necessary if the sheet name has a space in it. You can do the same thing with the other workbook. You'll end up with something like: ='[Book1.xls]Sheet1'!A1 while your first (source) workbook is open. When it's closed XL will display the file path as well. In article , (Stacy) wrote: I have two more questions: I have multiple worksheets in my workbook, all of which I want the max date of Sheet1. Is there a way to evaluate the date on Sheet2 using the range from Sheet1 without copying and pasting? I also have a second file that I would like to put these dates in based on the first file, is there a way to use the range from one file and put the output in another? Am I just better off copying and pasting once the original calculation is made? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |