Help with returning next available line item in Excel please!|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello All!

I am trying to do a template upload into our financial system and one of the requirements of the template is that we have to provide the line item to post the row to in the financial system. For example, if the system already has row 1 occupied, we have to load our data starting at row 2. Then, if rows 3-5 are occupied, we have to load to row 6.

See attached for to see the problem I am having. I can't figure out how to calculate the line item numbers in cells D13-D15. Does anyone have any suggestions on how to accomplish this? Let me know if the problem is unclear!! Thank you!!