Prev: excel 2003Next: naming worksheet tabs From: Ben Kelly on 27 May 2010 16:15 So simple but I would never have got there. Thanks very much "Jacob Skaria" wrote: > Hi Ben > > In F2 use the formula and copy down > =LOOKUP(2,1/(A2:E2<>""),\$A\$1:\$E\$1) > > To handle the error for blank rows use the below version > =IF(COUNTA(A4:E4),LOOKUP(2,1/(A4:E4<>""),\$A\$1:\$E\$1),"") > > -- > Jacob (MVP - Excel) > > > "Ben Kelly" wrote: > > > Hi, I have a gantt chart which has columns headed by dates > > > > A B C D E F > > 1 10/12 17/24 24/12 31/12 1/7 > > 2 Do A > > 3 Finish B > > 4 Start C > > 5 > > 6 > > 7 > > > > I would like to put a formula in colum F to show the date that the action in > > the row will be completed by. The real worksheet has 52 columns in it so > > using an IF statement isn't an option. Each row will only have one entry in > > it. > > > > Thanks for any help > > > > Ben > > 9 > > 10 > > > > > > From: Jacob Skaria on 27 May 2010 17:13 If you have excel dates in the 1st row; dont forget to format the formula cells to date format -- Jacob (MVP - Excel) "Jacob Skaria" wrote: > Hi Ben > > In F2 use the formula and copy down > =LOOKUP(2,1/(A2:E2<>""),\$A\$1:\$E\$1) > > To handle the error for blank rows use the below version > =IF(COUNTA(A4:E4),LOOKUP(2,1/(A4:E4<>""),\$A\$1:\$E\$1),"") > > -- > Jacob (MVP - Excel) > > > "Ben Kelly" wrote: > > > Hi, I have a gantt chart which has columns headed by dates > > > > A B C D E F > > 1 10/12 17/24 24/12 31/12 1/7 > > 2 Do A > > 3 Finish B > > 4 Start C > > 5 > > 6 > > 7 > > > > I would like to put a formula in colum F to show the date that the action in > > the row will be completed by. The real worksheet has 52 columns in it so > > using an IF statement isn't an option. Each row will only have one entry in > > it. > > > > Thanks for any help > > > > Ben > > 9 > > 10 > > > > > > From: Jacob Skaria on 27 May 2010 17:37 Hi Ben In F2 use the formula and copy down =LOOKUP(2,1/(A2:E2<>""),\$A\$1:\$E\$1) To handle the error for blank rows use the below version =IF(COUNTA(A4:E4),LOOKUP(2,1/(A4:E4<>""),\$A\$1:\$E\$1),"") -- Jacob (MVP - Excel) "Ben Kelly" wrote: > Hi, I have a gantt chart which has columns headed by dates > > A B C D E F > 1 10/12 17/24 24/12 31/12 1/7 > 2 Do A > 3 Finish B > 4 Start C > 5 > 6 > 7 > > I would like to put a formula in colum F to show the date that the action in > the row will be completed by. The real worksheet has 52 columns in it so > using an IF statement isn't an option. Each row will only have one entry in > it. > > Thanks for any help > > Ben > 9 > 10 > > >  |  Pages: 1 Prev: excel 2003Next: naming worksheet tabs