Hello,
On the Data_Validation sheet I am getting duplicates for the unique filter formula.
Can someone please see why?
Thank you
Hello,
On the Data_Validation sheet I am getting duplicates for the unique filter formula.
Can someone please see why?
Thank you
Last edited by billy60; 02-28-2024 at 06:38 PM.
The one I looked at was America Ferrera. Two of them have an extra space at the end, the third does not, so it counts as two different unique entries. By the way they all have an extra space at the beginning, too.
Then I looked at Popplewell, same problem.
Needs some data cleanup.
That's also the reason that your conditional formatting rule for duplicates isn't finding any duplicates.
You could also solve it like this but honestly it is always better to have clean data to start with.
Formula:Please Login or Register to view this content.
I tried using the TRIM formula for the data but it didn't work.
I will try again cleaning the data somehow.
I first used TRIM on the genre group then did text to columns.
Now I used TRIM on each individual Actor column and it removed the dead spaces.
So I used your trim formula and compared without the trim and get the same count.
Thanks for your help 6StringJazzer
Glad I was able to help, thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks