Remove duplicates but keep first instance in Excel (formulas- NO VBA)

How to remove duplicates from an Excel list but keep the first instance using formula only (no VBA) so that it automatically updates as new data is entered. Also useful where you want to identify duplicates in Excel without deleting any of the data.

Related Duplicate finding examples:

------------------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------------

⏲Time Stamps
00:00 Finding duplicates (automatically) in Excel
00:33 Using COUNTIF to find which duplicate instance a number it
01:10 $ signs in COUNTIF to create an expanding range
02:30 Identify the first instance of duplicated numbers
02:53 Differentiate between 1st time the value appears or a duplicate value
04:02 Extract only the 1st instance of duplicates (formula only- no VBA)
04:34 Create a unique lookup number ignoring duplicated values
07:10 Extract duplicates across multiple columns

[yogarajg]

I have enter customer name in cellA here the customer name repeated lot of time.So here
how can i get repeated name and single time entered name list in Cell C.
For Ex:
A
B
C
A
A
C
I WANT THIS TYPE IN CELL C :
A
B
C

[johnnyuncle]

Hey buddy, not sure why you did not do it the easy way.? In my opinion, the easy way would be to just filter under column "G" and only keep all number the "1" and then copy & paste the data to a different sheet. I think this would have solved the problem ?

[afrazali]

how can check check duplicate same values and split 13 digit into
5 digit, 7 digit and 1 digit,
and next like that
Example are given below thanks


B

[elcinsayin]

I don' really understand why range has to be B11:B11? Aren't we suppose to check how many of the certain plate number in the whole column?

[dhuejomteam]

How to get alert duplicate entry in two columns in one sheet by suing data validation. Plz need help

[indersharma]

I need your assistance in implementing the trick on excel scenario.

The below values in the cell on the row has the True and false. I want to figure out the count of repetition vs last change in the row.

As the example below The Ture comes twice at first and then again it comes 4 times after changing from False. I want to compete for the count of repetition from the last change value in the cell on the row.

Please advise.

result count of a repetition
TRUE
TRUE 2
FALSE 1
TRUE
TRUE
TRUE
TRUE 4
FALSE 1
TRUE 1
FALSE 1
TRUE
TRUE 2
FALSE
FALSE
FALSE
FALSE
FALSE 5
TRUE 1

[subashmanipokharel]

Can we highlight duplicate values camparism with two column data only not to be highlighted with same column number ?

[RajKamal-rwct]

barcode1 barcode2 barcode3 check barcode
1 1 1 TRUE
2 2 2 TRUE
2 3 2 FALSE

3 3 3 TRUE
4 1 4 FALSE
hii sir,
any logic this duplicate value find.
ex. only check value 1st row don't duplicate value count 4th row (barcode2) value 1
sir please help

[swastiknautiyal]

While removing duplicate it will delete entire content, kindly share the method how can I delete items without removing entire lines

[labandmolshakat]

Thanks so much Sir, your video has been of tremendous help and made my data analysis much easier. Deeply appreciate once more

[rramya]

thanks a lot it was much helpful, how to get the area look symbol

[BarryFelix]

How do I have the formula give me a 0 if the row is blank? this is the formula I am using.

=COUNTIF($D$16:D45, D45)

[artbeats]

Thanks! Your videos are very helpful!

[satindersingh]

from where i can get the sign that is next to undo sign in top bar

[natarajana]

Thanks, how to calculate number of days for next repeated occurrence from previous one, in your case "transaction number"

[swornimrasaili]

hi i need to know to use duplicate formula from sheet1 to sheet2
if i had used same number or name in sheet1 then it has to auto highlight to sheet2 please advise on it

[sarahx]

how do you usse the vlookup afterwards

[chellohello]

Wow Thanks dude.. i love you
i find it, thanks Vrymuch
#indonesian

[BalvirSingh-qskz]

Sir, Your formoola not zoom, pl. Do you formoola zoom.

[shaukatsamad]

what is the formula to make blue line on