WPS Office Export List function
WPS has this very handy function called "Export List" (it's only available in their premium package); when you autofilter a specific column and click the "Export button", it will produce a new worksheet that contains a table indicating the item names (i.e. Label) and the corresponding times it showed up in the column (i.e. Count)
Does Microsoft Excel have this same function or none? if yes, how will I do it? :(
I tried searching for Microsoft Excel add-ins and formulas that can do the same function but I can't find anything online :(
any help will be greatly appreciated
