Good afternoon. so I use the following to select the 1st empty cell in Column G via VBA.
Cells(Rows.Count, "G").End(xlUp).Offset(1, 0).Select - In this example G10 is selected
I now need to count with the following:
=sumproduct(1/countif(G2:G9,G2:G9) - however I never know what the 1st empty cell is so in other words I want count down from G2 to the last cell prior to my formula.
G
Cells(Rows.Count, "G").End(xlUp).Offset(1, 0).Select - In this example G10 is selected
I now need to count with the following:
=sumproduct(1/countif(G2:G9,G2:G9) - however I never know what the 1st empty cell is so in other words I want count down from G2 to the last cell prior to my formula.
G
1 Order Number |
2 WALM-15181 |
3 WALM-14830 |
4 WALM-14797 |
5 WALM-14788 |
6 WALM-14738 |
7 WALM-14578 |
8 WALM-14290 |
9 WALM-14290 |
=sumproduct(1/countif( ??????? ) |