Hello Excel Gurus,
I need your help, please. I am trying to create a time plan in Excel. I got two columns, one says "Start", the other "End". I'd like to have these two cells automatically filled out when a first non-empty cell is detected in an array - i want it to pick up or "echo" the value of the cell I choose. Please check this table:
<tbody>
</tbody>
Thank you very much in advance.
I need your help, please. I am trying to create a time plan in Excel. I got two columns, one says "Start", the other "End". I'd like to have these two cells automatically filled out when a first non-empty cell is detected in an array - i want it to pick up or "echo" the value of the cell I choose. Please check this table:
Start | End | 8.5 | 8.6 | 8.7 | 8.8 | 8.9 | 8.10 | |
Site 1 | 8.5 | 8.8 | x | x | x | x | ||
Site 2 | 8.7 | 8.10 | x | x | x | x | ||
Site 3 | 8.6 | 8.8 | x | x | x | |||
Site 4 | 8.9 | 8.10 | x | x |
<tbody>
</tbody>
Thank you very much in advance.