Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
100
Views
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
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
