Menu
![]() ![]() Once you click OK, the rows with duplicate values across both columns will automatically be removed:Įxcel tells us that 6 duplicate rows were found and removed and that 9 unique rows remain. In the new window that appears, make sure the box is checked next to My data has headers and make sure the boxes next to Team and Position are both checked: To remove these rows that have duplicates across two columns, we need to highlight the cell range A1:B16 and then click the Data tab along the top ribbon and then click Remove Duplicates: There are multiple players who have a team of A and a position of Forward. ![]()
0 Comments
Leave a Reply. |