How can I use Rank if I have more than 10000 group in a list?

Options
mehdijavadi
mehdijavadi Member, ALL USERS, Partner, Certified Model Builder, Community Pioneer Posts: 1 Master Anaplanner of the Year

Hi, I have a long list that has around 30000 line. soem of lines are duplicate and I need to deperate them. I wanted to use Rank function and group lines base on a property but I have 17000 actual group and Rank limit for group is 10000. How can I solve this?