suhas.sharma
New Member
- Joined
- Jan 10, 2012
- Messages
- 8
Hello,
I am trying to get automated text (highlighted in color red) based on the selected range and need solution in cells which says Total (Apr-Dec) and Total (Feb-Nov). This label should be based on corresponding month where 1st value in counter row is 1 and corresponding month where last found value of 1 in counter row.
Something like "Total" & Formula & "-" & Formula for Total (Apr-Dec) based on range in counter row.
Thanks in advance genius's out there.
<tbody>
</tbody>
I am trying to get automated text (highlighted in color red) based on the selected range and need solution in cells which says Total (Apr-Dec) and Total (Feb-Nov). This label should be based on corresponding month where 1st value in counter row is 1 and corresponding month where last found value of 1 in counter row.
Something like "Total" & Formula & "-" & Formula for Total (Apr-Dec) based on range in counter row.
Thanks in advance genius's out there.
<tbody> </tbody> |
<tbody>
</tbody>