Filter for unique values or remove duplicate values

October 23, 2024

To filter for unique values, click Data > Sort & Filter > Advanced. To remove duplicate values, click Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab.

https://support.microsoft.com/en-us/office/filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2

Filter for unique values or remove duplicate values <body> <h1> Array ( [0] => dilter for unique values or remove duplicate values [1] => cilter for unique values or remove duplicate values [2] => vilter for unique values or remove duplicate values [3] => gilter for unique values or remove duplicate values [4] => tilter for unique values or remove duplicate values [5] => rilter for unique values or remove duplicate values [6] => fulter for unique values or remove duplicate values [7] => fjlter for unique values or remove duplicate values [8] => fklter for unique values or remove duplicate values [9] => folter for unique values or remove duplicate values [10] => f9lter for unique values or remove duplicate values [11] => f8lter for unique values or remove duplicate values [12] => fikter for unique values or remove duplicate values [13] => fipter for unique values or remove duplicate values [14] => fioter for unique values or remove duplicate values [15] => filrer for unique values or remove duplicate values [16] => filfer for unique values or remove duplicate values [17] => filger for unique values or remove duplicate values [18] => filyer for unique values or remove duplicate values [19] => fil6er for unique values or remove duplicate values [20] => fil5er for unique values or remove duplicate values [21] => filtwr for unique values or remove duplicate values [22] => filtsr for unique values or remove duplicate values [23] => filtdr for unique values or remove duplicate values [24] => filtrr for unique values or remove duplicate values [25] => filt4r for unique values or remove duplicate values [26] => filt3r for unique values or remove duplicate values [27] => filtee for unique values or remove duplicate values [28] => filted for unique values or remove duplicate values [29] => filtef for unique values or remove duplicate values [30] => filtet for unique values or remove duplicate values [31] => filte5 for unique values or remove duplicate values [32] => filte4 for unique values or remove duplicate values [33] => filter dor unique values or remove duplicate values [34] => filter cor unique values or remove duplicate values [35] => filter vor unique values or remove duplicate values [36] => filter gor unique values or remove duplicate values [37] => filter tor unique values or remove duplicate values [38] => filter ror unique values or remove duplicate values [39] => filter fir unique values or remove duplicate values [40] => filter fkr unique values or remove duplicate values [41] => filter flr unique values or remove duplicate values [42] => filter fpr unique values or remove duplicate values [43] => filter f0r unique values or remove duplicate values [44] => filter f9r unique values or remove duplicate values [45] => filter foe unique values or remove duplicate values [46] => filter fod unique values or remove duplicate values [47] => filter fof unique values or remove duplicate values [48] => filter fot unique values or remove duplicate values [49] => filter fo5 unique values or remove duplicate values [50] => filter fo4 unique values or remove duplicate values [51] => filter for ynique values or remove duplicate values [52] => filter for hnique values or remove duplicate values [53] => filter for jnique values or remove duplicate values [54] => filter for inique values or remove duplicate values [55] => filter for 8nique values or remove duplicate values [56] => filter for 7nique values or remove duplicate values [57] => filter for ubique values or remove duplicate values [58] => filter for umique values or remove duplicate values [59] => filter for ujique values or remove duplicate values [60] => filter for uhique values or remove duplicate values [61] => filter for unuque values or remove duplicate values [62] => filter for unjque values or remove duplicate values [63] => filter for unkque values or remove duplicate values [64] => filter for unoque values or remove duplicate values [65] => filter for un9que values or remove duplicate values [66] => filter for un8que values or remove duplicate values [67] => filter for uni1ue values or remove duplicate values [68] => filter for uni2ue values or remove duplicate values [69] => filter for uniwue values or remove duplicate values [70] => filter for uniaue values or remove duplicate values [71] => filter for uniqye values or remove duplicate values [72] => filter for uniqhe values or remove duplicate values [73] => filter for uniqje values or remove duplicate values [74] => filter for uniqie values or remove duplicate values [75] => filter for uniq8e values or remove duplicate values [76] => filter for uniq7e values or remove duplicate values [77] => filter for uniquw values or remove duplicate values [78] => filter for uniqus values or remove duplicate values [79] => filter for uniqud values or remove duplicate values [80] => filter for uniqur values or remove duplicate values [81] => filter for uniqu4 values or remove duplicate values [82] => filter for uniqu3 values or remove duplicate values [83] => filter for unique calues or remove duplicate values [84] => filter for unique balues or remove duplicate values [85] => filter for unique galues or remove duplicate values [86] => filter for unique falues or remove duplicate values [87] => filter for unique vzlues or remove duplicate values [88] => filter for unique vslues or remove duplicate values [89] => filter for unique vwlues or remove duplicate values [90] => filter for unique vqlues or remove duplicate values [91] => filter for unique vakues or remove duplicate values [92] => filter for unique vapues or remove duplicate values [93] => filter for unique vaoues or remove duplicate values [94] => filter for unique valyes or remove duplicate values [95] => filter for unique valhes or remove duplicate values [96] => filter for unique valjes or remove duplicate values [97] => filter for unique valies or remove duplicate values [98] => filter for unique val8es or remove duplicate values [99] => filter for unique val7es or remove duplicate values [100] => filter for unique valuws or remove duplicate values [101] => filter for unique valuss or remove duplicate values [102] => filter for unique valuds or remove duplicate values [103] => filter for unique valurs or remove duplicate values [104] => filter for unique valu4s or remove duplicate values [105] => filter for unique valu3s or remove duplicate values [106] => filter for unique valuea or remove duplicate values [107] => filter for unique valuez or remove duplicate values [108] => filter for unique valuex or remove duplicate values [109] => filter for unique valued or remove duplicate values [110] => filter for unique valuee or remove duplicate values [111] => filter for unique valuew or remove duplicate values [112] => filter for unique values ir remove duplicate values [113] => filter for unique values kr remove duplicate values [114] => filter for unique values lr remove duplicate values [115] => filter for unique values pr remove duplicate values [116] => filter for unique values 0r remove duplicate values [117] => filter for unique values 9r remove duplicate values [118] => filter for unique values oe remove duplicate values [119] => filter for unique values od remove duplicate values [120] => filter for unique values of remove duplicate values [121] => filter for unique values ot remove duplicate values [122] => filter for unique values o5 remove duplicate values [123] => filter for unique values o4 remove duplicate values [124] => filter for unique values or eemove duplicate values [125] => filter for unique values or demove duplicate values [126] => filter for unique values or femove duplicate values [127] => filter for unique values or temove duplicate values [128] => filter for unique values or 5emove duplicate values [129] => filter for unique values or 4emove duplicate values [130] => filter for unique values or rwmove duplicate values [131] => filter for unique values or rsmove duplicate values [132] => filter for unique values or rdmove duplicate values [133] => filter for unique values or rrmove duplicate values [134] => filter for unique values or r4move duplicate values [135] => filter for unique values or r3move duplicate values [136] => filter for unique values or renove duplicate values [137] => filter for unique values or rekove duplicate values [138] => filter for unique values or rejove duplicate values [139] => filter for unique values or remive duplicate values [140] => filter for unique values or remkve duplicate values [141] => filter for unique values or remlve duplicate values [142] => filter for unique values or rempve duplicate values [143] => filter for unique values or rem0ve duplicate values [144] => filter for unique values or rem9ve duplicate values [145] => filter for unique values or remoce duplicate values [146] => filter for unique values or remobe duplicate values [147] => filter for unique values or remoge duplicate values [148] => filter for unique values or remofe duplicate values [149] => filter for unique values or removw duplicate values [150] => filter for unique values or removs duplicate values [151] => filter for unique values or removd duplicate values [152] => filter for unique values or removr duplicate values [153] => filter for unique values or remov4 duplicate values [154] => filter for unique values or remov3 duplicate values [155] => filter for unique values or remove suplicate values [156] => filter for unique values or remove xuplicate values [157] => filter for unique values or remove cuplicate values [158] => filter for unique values or remove fuplicate values [159] => filter for unique values or remove ruplicate values [160] => filter for unique values or remove euplicate values [161] => filter for unique values or remove dyplicate values [162] => filter for unique values or remove dhplicate values [163] => filter for unique values or remove djplicate values [164] => filter for unique values or remove diplicate values [165] => filter for unique values or remove d8plicate values [166] => filter for unique values or remove d7plicate values [167] => filter for unique values or remove duolicate values [168] => filter for unique values or remove dullicate values [169] => filter for unique values or remove du-licate values [170] => filter for unique values or remove du0licate values [171] => filter for unique values or remove dupkicate values [172] => filter for unique values or remove duppicate values [173] => filter for unique values or remove dupoicate values [174] => filter for unique values or remove duplucate values [175] => filter for unique values or remove dupljcate values [176] => filter for unique values or remove duplkcate values [177] => filter for unique values or remove duplocate values [178] => filter for unique values or remove dupl9cate values [179] => filter for unique values or remove dupl8cate values [180] => filter for unique values or remove duplixate values [181] => filter for unique values or remove duplivate values [182] => filter for unique values or remove duplifate values [183] => filter for unique values or remove duplidate values [184] => filter for unique values or remove dupliczte values [185] => filter for unique values or remove duplicste values [186] => filter for unique values or remove duplicwte values [187] => filter for unique values or remove duplicqte values [188] => filter for unique values or remove duplicare values [189] => filter for unique values or remove duplicafe values [190] => filter for unique values or remove duplicage values [191] => filter for unique values or remove duplicaye values [192] => filter for unique values or remove duplica6e values [193] => filter for unique values or remove duplica5e values [194] => filter for unique values or remove duplicatw values [195] => filter for unique values or remove duplicats values [196] => filter for unique values or remove duplicatd values [197] => filter for unique values or remove duplicatr values [198] => filter for unique values or remove duplicat4 values [199] => filter for unique values or remove duplicat3 values [200] => filter for unique values or remove duplicate calues [201] => filter for unique values or remove duplicate balues [202] => filter for unique values or remove duplicate galues [203] => filter for unique values or remove duplicate falues [204] => filter for unique values or remove duplicate vzlues [205] => filter for unique values or remove duplicate vslues [206] => filter for unique values or remove duplicate vwlues [207] => filter for unique values or remove duplicate vqlues [208] => filter for unique values or remove duplicate vakues [209] => filter for unique values or remove duplicate vapues [210] => filter for unique values or remove duplicate vaoues [211] => filter for unique values or remove duplicate valyes [212] => filter for unique values or remove duplicate valhes [213] => filter for unique values or remove duplicate valjes [214] => filter for unique values or remove duplicate valies [215] => filter for unique values or remove duplicate val8es [216] => filter for unique values or remove duplicate val7es [217] => filter for unique values or remove duplicate valuws [218] => filter for unique values or remove duplicate valuss [219] => filter for unique values or remove duplicate valuds [220] => filter for unique values or remove duplicate valurs [221] => filter for unique values or remove duplicate valu4s [222] => filter for unique values or remove duplicate valu3s [223] => filter for unique values or remove duplicate valuea [224] => filter for unique values or remove duplicate valuez [225] => filter for unique values or remove duplicate valuex [226] => filter for unique values or remove duplicate valued [227] => filter for unique values or remove duplicate valuee [228] => filter for unique values or remove duplicate valuew ) </h1> </body>