Forum Discussion
Solved
Remove Duplicate Values in Column
Hello, I am trying to create a table by Client ID using the data in the top table of the screenshot below. When summing the eligible amount by client id, I receive a value of $10,000,000 fo...
gmasta1129, two ways to achieve what you're after is:
1. Create a unique key that merges Client ID and Post Code, OR
2. Use MAX to return the maximum amount for the respective Client ID.
Firstly, though, I recommend you attempt the earlier options I provided so that assumptions are tested for fact and proven not to work.
All the best with your challenge.
Theo 🙂
I created a new table using the same exact csv file and then created a key as you mentioned above and it worked. Thanks so much for all your help! 🙂
Great to hear it worked gmasta1129 ! Well done!