Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: How to Delete Duplicate Cells per RowGo to Data >>> Data Tools>>>>>Remove Duplicates>>>Check "My data has headers'>>>Tick the header to run duplicate on COMPILATION OF EXCEL SHEETS FROM A FOLDER I have a lot of Excel files with the same header in one folder. I want to put all the sheets on one sheet. I want to ignore rows 1 to 5 and use row 6 as the header for all the sheets.
