ExcelBanter - Using the MATCH formula and list the duplicates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Using the MATCH formula and list the duplicates (https://www.excelbanter.com/excel-worksheet-functions/117696-using-match-formula-list-duplicates.html)

Cathey

Using the MATCH formula and list the duplicates

I'm using the MATCH formula and getting the number results I need. But, I
want to display/list which of my 7 records are duplicate.

Duke Carey

Using the MATCH formula and list the duplicates

Data-Filter-Autofilter will allow you to isolate rows meeting specific
filtering conditions; all other rows would be hidden.

"Cathey" wrote:

I'm using the MATCH formula and getting the number results I need. But, I
want to display/list which of my 7 records are duplicate.

All times are GMT +1. The time now is 01:19 AM.