I have a work sheet, it has 10,000 rows.<BR><BR>2,000 of those are for the state of New York.<BR><BR>So I add a filter, then drop down on the state column and select New York.<BR><BR>I then have 2,000 ...
Generate a list of unique entries in an Excel column Your email has been sent When you need to get rid of duplicates in a column, Excel's advanced filtering options will do the trick. This quick ...
Click on the heading of the column you want to evaluate for duplicates. Click and drag from one heading to the next to select more than one column. Hold down the "Ctrl" key and click to select columns ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results