The % you see in the final column is calculated as sum "column 6"/ sum "column 1". So in this case it should have been 14/17 but I get an incorrect answer. This is because the 17 you see is after the duplicates were removed( which is what I need to see) but to calculate the value in the last column it still considers the duplicates present in the first column.
Please let me know how to proceed. Thank you.