Prev: excel 2003
Next: 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 2003
Next: naming worksheet tabs