Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find first cell in row with an "x" in
Hi,
I've created a rudimentary Gantt chart. Days are listed along row 2 in the form DD-MMM-YY and Task are listed down column A. I've marked with an "x" the cells which represent the days activity is happening as part of each task. I want to create a Start date column and an end date column. The start date column should read along the row left to right, when it encounters the first "x", return the date listed in row 2. The End date column should read along right to left, when it encounters the first "x", return the date listed in row 2. The first dates start in column F and finish in column BN Collumn B will be for the start date, C for end Date (D has the resource initials) Thanks for your help, I'm a newb! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find first cell in row with an "x" in
I've created a rudimentary Gantt chart.
Days are listed along row 2 in the form DD-MMM-YY and Task are listed down column A. I've marked with an "x" the cells which represent the days activity is happening as part of each task. I want to create a Start date column and an end date column. Here's one way, with Gantt data in row 3. Start date: =INDEX($F$2:$BN$2,1,MATCH("x",F3:BN3,0)) End date: =INDEX($F$2:$BN$2,1,MATCH("x",F3:BN3,0)+COUNTIF(F3 :BN3,"x")-1) Copy down for subsequent rows. Hope this helps getting started. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0, | Excel Programming | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
keyboard shortcut to return to previous cell after "find" or "got. | New Users to Excel | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) |