What function will allow you to make the top 5 frequently / rarely occurring words?

A

A

AbarKhali2020-03-06 22:59:32

excel

AbarKhali, 2020-03-06 22:59:32

What function will allow you to make the top 5 frequently / rarely occurring words?

I have a list of buyers, with =INDEX(C2:C16;MODE(MATCH(C2:C16;C2:C16;0))) I can find the top 1 buyer (the most frequently used word).

Is it possible, based on this function, to make a top of 5-10 as many as I need.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

2 answer(s)

D

Dimonchik, 2020-03-07
@dimonchik2013

self-written

E

Elvis, 2020-03-07
@Dr_Elvis

Macro only

Similar questions

A

ATWAliv2021-10-16 13:13:33

When outputting data to Excel from SQL, column names are not output? 1Reply

M

Mikhail Petrov2016-03-11 07:02:10

How to analyze site positions in Excel using Keycollector? 1Reply

D

dmeroff2013-12-09 19:30:05

How to get the row and column number for the max value of a table? 1Reply

A

Alexey2020-07-22 03:25:53

Excel: Convert dimensions from mm to cm if some values are string? 1Reply

V

Vasya Borisevich2018-08-08 15:05:19

How to save excel to html without formatting? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question