Forum Discussion
Transpose the value
Ledger Partner Debit Credit Credit (VAT) Turbine Services & Solutions Aerospace 3,570.00 3,400.00 170.00 Sales A/C VAT SR Output TRICON Trading & ...
I don't see/understand the rounding issue you refer to. Instead of sharing video or Word doc. could you please:
- Use your actual data
- Refresh the query I shared
- Highlight any rounding issue in the resulting table
and then share the Excel file
Something less painful than formulas with Excel 2016, Get & Transform aka Power Query
In attached file:
#1 Put your data in 'Table1'
#2 Switch to tab 'Power Query'
#3 Right-click in the green table > Refresh
I am first time use the power query. Just a few links:
What exactly is your question?