Hello! Would just like to ask if there is a way remove all the rows after the row that has a subtotal. Kindly see screenshot. On this example I want to remove all rows after 492 (Row 493 and all succeeding rows after). I want to know if there is a dynamic solution as the row number with subtotal might change (e.g. subtotal might be on Row 392 when I next run the workflow, hence, I need to remove all rows from 393 and after). Thank-you very much!
User | Count |
---|---|
106 | |
82 | |
70 | |
54 | |
40 |