I have a .csv file with 150,000 cells like this one:
25,50,10,490,490,490,465,440,625
I want to find how many times each one can be found in the document. Normally I could just rank them from A to Z but the thing is the order of the last 6 numbers doesn't matter so 25,50,10,490,490,490,465,440,625 is considered the same as 25,50,10,625,490,490,465,440,490 for my purposes. What I want is something like "This one can be found in the document 100 times, this one can be found in the document 25 times" for each one. Any way to do this?
Thanks.
Bookmarks