Hello every one,
my data contains in excel as in 3 columns and mutliple rows in down.
if i use consolidate sum function, it will sum up 2nd and 3rd cloumn cell and 1st column cell be as label
But, I want combine rows removes duplicates with based on data in 1st and 2nd column, and sum the value in 3rd column cell
Thanking you advance
my data contains in excel as in 3 columns and mutliple rows in down.
if i use consolidate sum function, it will sum up 2nd and 3rd cloumn cell and 1st column cell be as label
But, I want combine rows removes duplicates with based on data in 1st and 2nd column, and sum the value in 3rd column cell
Thanking you advance