CODEWITHSUNDEEP
excelexcel-formulaexcel-2010
Sauced Apples
Sauced Apples

Reputation: 1173

Find unique values in Excel

I have a 3 column 200+ row section in my sheet. These contain printer cartridge types.

What I need to do is get a single entry into a separate workbook of each entry in each row.

I have not used Excel in many years and have tried this:

=INDEX($D$3:$D$218, MATCH(0, COUNTIF($E$3:B218, $D$3:$E$218), 0))

I would appreciate any help!

Upvotes: 1

Views: 114

Answers (1)

Tomasz Kuryło
Tomasz Kuryło

Reputation: 122

You don't need a formula here. Use remove duplicates function (Data -> Data tools -> Remove duplicates).

Upvotes: 2

Related Questions