HI,
If you have
A____________B________________F
1.11.2009_____2.12.2010_________28.1.2008
Which formula would auto copy the lowest date of these three (A1,B1,F1) to another cell?
THANK YOU
HI,
If you have
A____________B________________F
1.11.2009_____2.12.2010_________28.1.2008
Which formula would auto copy the lowest date of these three (A1,B1,F1) to another cell?
THANK YOU
Please attach a sample data for better understanding...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
may be
=MIN(A1:F1)
may be
=MIN(A1:F1)
Hi,
Sixthsense, in other words:
I have for example the date 1.11.2009 entered in A1, 2.12.2010 in B1 and 28.1.2008 in cell F1. In need a formula inserted in G1 which scans the lowest date in these three cells and then copies that lowest date to the cell G1.
Hi Ghozi,
MIN(...;....;....) works brilliantly. Thanks!
Last edited by RogerRangeRover; 12-11-2012 at 03:44 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks