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 đŸ™‚
Hello,
I am not able to remove duplicates because my data has other columns that are needed for tables I created.