Hi friends, @aanandsanraj ,I have another excel file where I need to get client-wise DIFF values. The problem is there are two DIFF columns and I want to get two DIFF values for the respective clients.
But the challenging part is DIFF columns position will change for some clients. PLease find the attached file below. the attached excel file has different structure.
Test_Dec02.xlsx (53.3 KB)
Please find the attached excel file for your reference suggest me how to get those two DIFF values for the respective clients like the one you have done for the yesterday file.Test_Dec02.xlsx (53.3 KB)