Currently top 10 is limited to numbers which can be a limitation compared to other software out there.
The request is to enhance top 10 auto filter to allow filtering out the "top 10" most popular strings in a column.
1. Put in "a" in A1-A10
2. Data -> filter -> auto filter
3. Select the down arrow on the auto filter in A1 and select "top 10"
Observed: Everything is filtered out
Expected: A stays because it is in the top 10 string cases in the column (it's the only string case ;) )
I confirm, this would be an interesting improvement.
I set status to New.
In the meantime a workaround requires an additional column with eg
Can you explain that workaround a bit more - I want to add that info to the wiki :)
(In reply to comment #2)
> Can you explain that workaround a bit more - I want to add that info to the
> wiki :)
The "top 10" filter works only on values. You can insert a column in which the CODE function is used to get a numeric code for the first character in a text string.
First, to ignore the difference between uppercase and lowercase, the cell is converted (LOWER function)
Codes corresponding to the aphabet are growing. They are multiplied by -1 so that A is before B.
This workaround is limited because it only takes into account the first letter of the cell. I made this proposal without testing but it seems that however it may give a good result (see attached example)
Go further: in the example calculations in column B are masked by the use of a custom cell style.
That said, the numbers are always displayed when selecting the filter so it may not be necessary
Created attachment 99881 [details]
I think Joel want to filter the most frequently used strings:
"The request is to enhance top 10 auto filter to allow filtering out the "top 10" *most popular strings* in a column."
not alphabetic order.
You can replace Pierre-Yves formula with this one:
(In reply to comment #5)
> I think Joel want to filter the most frequently used strings
This is not my bad english...
these are my glasses that need to be improved lol
Thank you Gérard