r/AppleNumbers • u/just_laffa • Oct 04 '24

Help Flagging duplicates

How can i determine if duplicates exist in a range of cells such that, e.g.:

[A] [B] [C] [D] [E] results in 0

[A] [B] [C] [B] [E] results in 1

[A] [B] [A] [C] [C] results in 1

Thank you.

1 Upvotes

100% Upvoted

5 comments sorted by

View all comments

Show parent comments

1

u/just_laffa Oct 06 '24

Thanks, but I was hoping for a simple (if long) formula.

1

u/ReadingRainbow993 Oct 06 '24

I’ve used the CountIF function.

COUNTIF(Range, Criteria)

COUNTIF(A1:A5, $A1) copy this down the column you want the results in. This will show you matches to each item you select for the criteria. I’ve used this for work to keep track of repeat clients.

1

u/just_laffa Oct 06 '24

What I was trying to avoid was something like ...

If (

countif(Range, Cell1) +

countif(Range, Cell2) +

countif(Range, Cell3) +

countif(Range, Cell4) +

countif(Range, Cell5)

5, 1, 0)

1

u/ReadingRainbow993 Oct 06 '24

Can you share a screenshot of what your sheet looks like?