![]() Select the Unique records only check box, and then click OK. In the Advanced Filter dialog box, click Filter the list, in place. On the Data menu, point to Filter, and then click Advanced Filter. I have copied my original list to a second column and then with the function of Excel "remove duplicates" I could find the list of unique values.Ĭopied from Microsoft Office Website: Select all the rows, including the column headers, in the listĬlick the top left cell of the range, and then drag to the bottom right cell. So I did in another way which I show below. In my case the excel was frozen when using the formula ofī2=INDEX($A$2:$A$20, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$20), 0))īecause there was many rows (10000). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |