If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Return date of an action
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 |
Thread Tools | |
Display Modes | |
|
|