<div>
You could use conditional formatting on duplicates, format with a colour, and then use autofilter to find the coloured cells.<br />
<br />
Another method is to use countif or countifs in another column.<br />
Again apply autofilter and select counts above 1.<br />
For very large datasets it could be slow, because of the many calculations.
</div>


You could use conditional formatting on duplicates, format with a colour, and then use autofilter to find the coloured cells.

Another method is to use countif or countifs in another column.
Again apply autofilter and select counts above 1.
For very large datasets it could be slow, because of the many calculations.

<div>
Ejgil Hedegaard,<br />
<br />
Can you please provide me with the exact steps to do what you have described? It doesn't matter if this is slow.
</div>


Ejgil Hedegaard,

Can you please provide me with the exact steps to do what you have described? It doesn't matter if this is slow.

<div>
<div class="content wysiwyg-content">
What method or utilities can I use to determine if certain cells, rows, or columns within Excel 2016 have the same value or data?<br />
<br />
I have a rather large inventory database stored within an Excel spreadsheet and sometimes need to determine if certain values such as serial numbers are duplicated in different places when such data should be contained in only one place.
</div>
</div>


What method or utilities can I use to determine if certain cells, rows, or columns within Excel 2016 have the same value or data?

I have a rather large inventory database stored within an Excel spreadsheet and sometimes need to determine if certain values such as serial numbers are duplicated in different places when such data should be contained in only one place.

Method to determine if certain cells, rows, or columns within Excel have the same value or data

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

A miscellany is defined as a "collection of various pieces of writing by different authors", but it has come to mean something "Of items gathered or considered together of various types or from different sources" or "a collection or group composed of members or elements of different kinds". The word "miscellaneous" comes from the Latin word "miscere", meaning "to mix." You might have heard the expression "a mixed bag," which applies when you don't quite know what you're going to get. More commonly, a miscellaneous group is made up of an odd group of things that don't fit anywhere else.

Miscellaneous

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.