Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Formula for Flagging Repetitive Values

Copper Contributor

Hi Everyone

 

I was hoping for some advice.

 

Ive simlified my request below with a simple table.

 

I want to flag in column A with the use of a formula if a value repeats somewhere in Column B

 

So for example below Error Code 1, Error Code 6 appear more than once in Column B  So i want to flag it.

 

Ive used the term repeat :)

 

Goal

 

Jimmy_G_706_0-1698933231231.png

 

Another view

 

Jimmy_G_706_1-1698933337928.png

 

RAW Data

 

Unique or RepeatList of Error Codes
RepeatError Code 1
UniqueError Code 2
UniqueError Code 3
UniqueError Code 4
UniqueError Code 5
RepeatError Code 6
UniqueError Code 7
UniqueError Code 8
UniqueError Code 9
RepeatError Code 1
RepeatError Code 6

 

 

Appreciate any advice.

 

Jimmy

 

 

1 Reply

You can use conditional formatting to get this or countifs

 

Attached sheet FYR