![]() After selecting, Continue with the current selection, click on remove duplicates, another dialog box appears,.As column A has just one type of data and we need to remove duplicates from column B so we will select Continue with the current selection. A dialog box appears It asks for us if we want to remove duplicates from the current selection or we want to expand our selection. ![]() Select the column B, and in the data tab, under the data tools section click on remove duplicates,. ![]() This is where removing duplicates in excel comes in handy. For a smaller amount of data we can simply count the number of names that are unique but for a larger amount of data it may take a while to figure out the same. Here we have discussed different methods of unhiding columns in Excel like Using a Mouse, using VBA code, Using Key Board Shortcut, etc.We want to check how many people name are mentioned in column B. This has been a guide to Unhide Columns in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |