•1 min read•from 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? :)
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Relation
#Team-Name
#Gesamtpunkte
#Total Score
#duplicates
#unique values
#Excel
#conditional formatting
#highlight
#warning
#sort
#table
#values
#duplicates in red