Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I get the value of a column that repeated more and more often repeated than less?
Could you give an example? Some lines of sample data and your expected outcome?
Yes
Col1
10
10
10
10
3
2
2
4
4
5
5
What this column more than less repeated and repeated, in case 10 was the most repeated and repeated was the third least in my case is a column with N possible values there are also like to make a rank of 10 most repeated and 10 less repeated, else the value is among the most repeated have another show number two ...
You can create a listbox for the field and check 'Show Frequency' in the General tab of the listbox property.
Also you can set the sort order in the sort tab as frequency descending/ascending depending on your requirement.