Forum Discussion
Solved
Sum Removing Duplicates
In this data set, I need the cancelled out values (the 1st and 3rd lines) to show as 0 in a column so I can only sum the total amount ($833) once. There are other columns in the table, I just n...
Hello Soc3,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
Hi,
A simple drag and drop (as shown in your screenshot) should have worked. My guess is that in the entries of the Unique ID column, the ID's have extra invisible characters. Clean the data in that column. Refresh All.