[Music]

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

did

okay and I'm just going to an ID or

column now to this data let's add a

column called duplicate flag this cell

is going to check is there any duplicate

values present of this particular order

number so let's go - seulji file and

type in the formula which is counter the

range which is from C Phi is 2 C 97

let's freeze it by putting a dollar

symbol which is by using the function f

4 and then the criteria is going to be

the cell c5 let's press Enter I am going

to copy this formula over

they're in column G you see the

occurrence of this order number within

this list so we see that the order o one

one nine two occurs three times and the

order one one three zero occurs only

once which means there's no duplicate

anything which has a flag above one is a

duplicate entry once we've calculated

the duplicate flood let's just color the

rows which I will duplicate flag greater

than one so let me just select the cells

go to conditional formatting a new rule

I'm going to have a class say put a

formula we're going to use the formula

based on the column G is constant but

the row is going to change since I'm

going to remove the dollar from the five

it's greater than one and just say okay

there now you have all the numbers which

i duplicate colored red now to make it

simpler you could again sort the data

based on the order number now you are

the data

based on order number and if it's

duplicate is already in color as you

find incorrect entries and get rid of

them let's say in this case I see the

row six is the incorrect entry and I'm

going to delete it the conditional

formatting then removes the red color

from order number oh one one zero one

this is a very quick and simple way to

find duplicate entries in your data I

hope that this tutorial was of use to

you if you liked it please subscribe to

my channel until next time ciao