1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Relation not possible due to duplicates

I wanted to create a Relation for Team-Name and Gesamtpunkte (Total Score), so that I then can sort them in the table at the far right.
Team-Name itself is already a table, aswell als Gesamtpunkte.

When creating a relation out of them, I do get the warning that there are some duplicates and Excel needs unique values that relate to each other. I understand that.

So I used conditional formatting to highlight the duplicates in red.
None are red...

Anyone able to help me out please? :)

https://preview.redd.it/x4b00osbl2og1.png?width=1214&format=png&auto=webp&s=abb80f6246b7f3a814e0ed6f81b381bc1ec4a15b

submitted by /u/Pretty_Acadia_9652
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article