Is it possible to get remove duplicates & get the unique items from a column in an excel? Then, for each unique item, calculate the sum of corresponding cells in the second column. I am including a sample file for reference. In this file, I need unique items from column1 (11000, 12000 etc.) and then calculate the sum of cells in column2 with 11000 in column1, then 12000 and so on.
SampleFile.xlsx (10.7 KB)