Assuming, we have an excel sheet with two columns, Client ID and Client expenditure. What I am trying to do is have robot access the spreadsheet and perform the following:
*Search for duplicate client id
*If a duplicate is found, then sum the overall client expenses
Any feedback on how this may be achieved?
Thank you very much,