CODEWITHSUNDEEP
arraysgoogle-sheetsfilteruniquegoogle-sheets-formula
BrettG
BrettG

Reputation: 41

Find unique and first instance of duplicate - copy to another row

I am trying to figure out the formula / coding for to list out all the uniques and first appearance / instance similar to how the "Remove Duplicates" add on is able to do it but I want it to be automated.

The Countifs formula on 'Data4' page is able to find the word "test" 4 times with different capitalization (which is what I want it to do) and then the page '4 Warnings' takes that data and I want that page to be able to filter out the the 3 other variations of the word "test" and spit it out into another column. If I am able to achieve this then I can eliminate duplicates of the same name but with different capitalization on the page 'Issued Warnings' under the D column.

Here is a link to a test google sheet: https://docs.google.com/spreadsheets/d/1-85gZgs_bwIEdd0fZh0jdPdCaBGJAM145oR-qZw3dx4/edit?usp=sharing

Upvotes: 1

Views: 366

Answers (1)

player0
player0

Reputation: 1

try:

=UNIQUE(FILTER(UPPER(Data4!B:B), Data4!E:E=TRUE))

0

Upvotes: 1

Related Questions