Hi I have a 30000 rows of data with 120 columns. I am comparing the columns and to get the difference and when the difference is there i am flagging them. I want to get the excel cell address when the difference is found for that particular row and column example from the below table (Please find attached a sample data) Difference is found in A. I want to get the cell address like B3 and B4 is there a work way to achieve this.
| Input | | | | | | Output | | | |
| Record ID | A | B | Difference of A and B | Record ID | A | Column Name | Cell Address |
| 1 | 10 | 5 | 5 | | | 1 | 10 | A | B3 |
| 2 | 20 | 10 | 10 | | | 2 | 20 | A | B4 |
