365 no repeats7/2/2023 On the Edit menu, click Office Clipboard. The filtered list is displayed and the duplicate rows are hidden. 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. |