Hello
If I have a set of data that will have an unknown number of rows, how can I calculate the number of rows with data in them if the sheet will change each time
Example below, I only wish to count the rows with actual data not the blanks and because the range will change I can use a specific range
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
If I have a set of data that will have an unknown number of rows, how can I calculate the number of rows with data in them if the sheet will change each time
Example below, I only wish to count the rows with actual data not the blanks and because the range will change I can use a specific range
NMI/MIRN Quote* | Current Retailer | DMA provider | Annual Peak KWh* | Annual Shoulder KWh* | Annual Off Peak KWh* |
6203724417 | Origin Energy | Plus ES | 756,063 | 228278.09 | |
6203724417 | Origin Energy | Plus ES | 756,063 | 228278.09 | |
6203724417 | Origin Energy | Plus ES | 756,063 | 228278.09 | |
6203724417 | Origin Energy | Plus ES | 756,063 | 228278.09 | |
6203724417 | Origin Energy | Plus ES | 756,063 | 228278.09 | |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>