Forum Discussion
Formula for Flagging Repetitive Values
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
Another view
RAW Data
| Unique or Repeat | List of Error Codes |
| Repeat | Error Code 1 |
| Unique | Error Code 2 |
| Unique | Error Code 3 |
| Unique | Error Code 4 |
| Unique | Error Code 5 |
| Repeat | Error Code 6 |
| Unique | Error Code 7 |
| Unique | Error Code 8 |
| Unique | Error Code 9 |
| Repeat | Error Code 1 |
| Repeat | Error Code 6 |
Appreciate any advice.
Jimmy
1 Reply
You can use conditional formatting to get this or countifs
Attached sheet FYR
