Hi,
I have a large data table with a column including text in each row. Some cell values occure multiple times in the column, others don't.
Is it possible to have a formula next to this column which returns a value (let's say "ORIGINAL") next to the first occurrence, and a separate value (let's say "DUPLICATE") next to a cell if a matching value already occurred before it (i.e. it's a duplicate).
If a value only has one occurance, it can say "ORIGNAL"
Thank you!
Hi,
Assuming Data is in column A then in B1 copied down
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Try one of these formulas...
Data Range
This formula entered in B1 and copied down:
=IF(COUNTIF(A$1:A1,A1)=1,"Original","Duplicate")
This formula entered in C1 and copied down:
=IF(MATCH(A1,A:A,0)=ROW(),"Original","Duplicate")
The formula in column C is more efficient especially if you have many rows of data.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi
If your data is ordered then try
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks