sorting text to reveal occurrence of adjective

%3CLINGO-SUB%20id%3D%22lingo-sub-2137291%22%20slang%3D%22en-US%22%3Esorting%20text%20to%20reveal%20occurrence%20of%20adjective%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2137291%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20has%20probably%20been%20addressed%20but%20I%20need%20a%20quick%20and%20simple%20answer.%20I%20want%20to%20sort%20or%20filter%20the%20adjectives%20to%20show%20how%20many%20times%20each%20is%20listed%20and%20if%20there%20are%20duplicates%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22screenshot%20of%20looking%20glass.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F255071iF42205E81269F9C9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22screenshot%20of%20looking%20glass.png%22%20alt%3D%22screenshot%20of%20looking%20glass.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2137291%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

This has probably been addressed but I need a quick and simple answer. I want to sort or filter the adjectives to show how many times each is listed and if there are duplicatesscreenshot of looking glass.png

1 Reply

@MTognoli 

If you call the array of adjectives 'attribute' then

= COUNTIFS(attribute, attribute)

gives a similar dimensioned array with the count of occurrences for each adjective.

= SUM( 1 / COUNTIFS(attribute, attribute) )

is the number of distinct adjectives used in the table.  To go further, a list of distinct options from which the adjectives are drawn would help.

= COUNTIFS(attribute, list)

provides a count of each adjective.  The two column result can be sorted and filtered using

= SORT(FILTER(result, count>0), 2,-1)

The final formula may mean it is time to take a license 365!