I have been stuck in this excel checking for so long and your help or any idea input.
Table 1 and table 2 shares the same unique value and can be cross-checed. However, I need to sum amount1 based on value, after that, I need to compared the sum value with table 2 - amount 2. Apart from sum value, value also needs to be matched with each unique ID.
Table 3 and 4 is more challenging to me.
Firstly the value of sum of table 3 need to be compared against the value of sum in table 4 for each unique ID. However, the value for table C is under column name but the value for table D is from the row variables.
Please let me know if additional information required, thank you so much.
DataTable reference.xlsx (11.2 KB)