Find Duplicate Entries in Excel

Toggle fullscreen Fullscreen button

Sharing buttons:


hey there everyone welcome to tech Nisha

in this tutorial I will show you how to

find duplicate entries in a table here

you see a table of order numbers which

runs approximately 95 rows let's say you

wanted to find if there are any

duplicate order numbers in this table

how would you do it one way to do this

is to sort this data based on order

number and then see the duplicate

entries so let's see how to do that I'm

going to select the data and then go to

Home sort custom sort based on the order

number and let's do a to Z and there

then you can see manually which order

numbers are repeating this is not a

practical solution as the data set is

pretty long and this is going to be very

time-consuming let me show you a quicker

way so let me undo the sort which I just