Forum

Notifications
Clear all

Help with returning next available line item in Excel please!

2 Posts
2 Users
0 Reactions
86 Views
(@nickyz99)
Posts: 1
New Member
Topic starter
 

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!!

 
Posted : 08/07/2022 9:37 pm
(@catalinb)
Posts: 1937
Member Admin
 

Hi Nick,

Can you please clarify why the item below should be 1? That seems to be occupied in your example?

1044220 7560000 Should be 1 Expense 1

 
Posted : 10/07/2022 12:09 am
Share: