I want to sort according to frequency, largest to smallest.

I would use Power Query with the following Mcode

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {}, "Attribute", "Value"),
    #"Sorted Rows" = Table.Sort(#"Unpivoted Columns",{{"Value", Order.Ascending}}),
    #"Removed Columns" = Table.RemoveColumns(#"Sorted Rows",{"Attribute"}),
    #"Grouped Rows" = Table.Group(#"Removed Columns", {"Value"}, {{"Count", each Table.RowCount(_), Int64.Type}}),
    #"Sorted Rows1" = Table.Sort(#"Grouped Rows",{{"Count", Order.Descending}, {"Value", Order.Ascending}})
in
    #"Sorted Rows1"

Your formula produces a comma after each unique item and therefore cannot be matched to the info in Columns A:E as they don't have the trailing comma

Excel 2016 (Windows) 64 bit

	I	J
1	Value	Count
2	Advancement	2
3	Progress	2
4	Accounting	1
5	Accounting-manipulation	1
6	Address	1
7	Administration	1
8	Betterment	1
9	Blockchain	1
10	Cryptography	1
11	Development	1
12	Digital	1
13	Distributed	1
14	Encryption	1
15	Enhancement	1
16	Expansion	1
17	Financial-manipulation	1
18	Fraud	1
19	Growth	1
20	Improvement	1
21	Insider-trading	1
22	Leadership	1
23	Ledger	1
24	Management	1
25	Organization	1
26	Public-Key	1
27	Securities-fraud	1
28	Security	1
29	Team	1
30	accountability	1
31	clarity	1
32	disclosure	1
33	openness	1
34	transparency	1

Sheet: Sheet1

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.

I am not familiar with Mac or if the TOCOL function is available in Office 365 for Mac. If it is you may find this a simpler way to get the sorted unique values. See this in column H of the attached.

Formula:

=SORT(UNIQUE(TOCOL($A$2:$E$8,TRUE,)),,1,FALSE)

I have not found a simple formula way of getting the sorted list by frequency. Someone else may be able to help with that. The best I could come up with was this beast. Entered into F2 and copy down.

Formula:

=INDEX(SORT(UNIQUE(TOCOL($A$2:$E$8,TRUE,)),,1,FALSE),MATCH(LARGE(COUNTIF($A$2:$E$8,SORT(UNIQUE(TOCOL($A$2:$E$8,TRUE,)),,1,FALSE))-(SEQUENCE(SUMPRODUCT(1/COUNTIF($A$2:$E$8,$A$2:$E$8)),,2)/10^7),ROWS(F$2:F2)),COUNTIF($A$2:$E$8,SORT(UNIQUE(TOCOL($A$2:$E$8,TRUE,)),,1,FALSE))-(SEQUENCE(SUMPRODUCT(1/COUNTIF($A$2:$E$8,$A$2:$E$8)),,2)/10^7),0))

About all I can say for that is that it works although it could be made simpler with 1 or more helper columns.