Forum Discussion
Merge of rows with identical names in some columns
I have a sheet with many dublicates in Column A. I if remove duplicates in that column the entire row is deleted. Is it possible to make a formula that "merges" the duplicates so there is only on Deb...
Hi Monica2305
If you have a lots of rows, insert new sheet, place the curse on the first cell.
From Data tab --> in the Data Group choose consolidation
On the consolidation windows, choose sum in the function box, in the reference select your data, tick the Top row and Left column --> OK
* If my post helped you, please click on like.