I have 3 dates in 3 cells. Ie. 06/12/2001 cell H3, 24/11/01 in cell I3 and 06/01/01 in J3.
Is it possible to select the latest date of the 3 - I wish to show this in G3. Any ideas?
Many thanks
On 2002-03-18 08:24, MattB wrote:
I have 3 dates in 3 cells. Ie. 06/12/2001 cell H3, 24/11/01 in cell I3 and 06/01/01 in J3.
Is it possible to select the latest date of the 3 - I wish to show this in G3. Any ideas?
Many thanks
Many thanks - easy when you know how!
One more thing - is it possible to show which cell gives the return. If for instance I3 was the latest date - could the return in G3 also show this?
3 = Row number
7 = offset of the column the formula is in from A (eg if your formula was in column B, this would equal 1).
4 = return relative cell reference.
Check out the help on the Address function for more info.
Lastly!, I need to copy this thro' approx. 2000 rows, excuse my ignorance again but the ADDRESS (3 - obviously needs to match the row number, when i copy & paste this stays as 3 - how can I change this?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.