anything in Excel...

It's Excel-o-lozy...

Merge Error in Sort / remove duplicates with message "This operation requires the merged cells to be identically sized."

www.Excelolozy.com - While Sorting data or Removing Duplicates from data, an error comes up which reads "This operation requires the merged cells to be identically sized."

This error message comes up in following cases :
  • Sort
  • Remove Duplicates

Reason for the error :
  • The cell range includes merged cells and
  • All cells in the range are not merged to the same size.

Solution to the error :
  • Unmerge all the merged cells in the range or
  • Make each group of merged cells the same size as the largest group.

If you unmerge the cells, make sure the data in two or three merged rows in front of first cell will remain in upper most cell only.
 So if you are opting for Unmerge then fill the data in the adjacent rown downward as well. Simply Tricky... ;) 
Anything in Excel, be an Excelolozian...
 
for best MS Excel Tips visit http://www.Excelolozy.com
 
gotta query??? drop a mail at mail@excelolozy.com