I have been trying to get a fix for this issue for the past 2 days.
I have an excel file that runs to around 54,645 rows showing individual expenses for FY 2015 month-wise. I need to replace duplicate expenses with zero only in one month (June). The list is filtered and it is best that it stays that way (sorted to different columns).
How can I remove the duplicates that appear in this month alone?
Any help is much appreciated.
I have an excel file that runs to around 54,645 rows showing individual expenses for FY 2015 month-wise. I need to replace duplicate expenses with zero only in one month (June). The list is filtered and it is best that it stays that way (sorted to different columns).
How can I remove the duplicates that appear in this month alone?
Any help is much appreciated.