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

I

Ivan Medvedev2020-03-04 08:06:16

How to make several page layout options depending on the value of a variable? 2Reply

V

Veritas232019-12-29 11:48:00

How to select cells in Excel that contain one of the specified words? 1Reply

N

not-deanon2017-08-02 09:39:29

How to bind macro to excel in php? 1Reply

L

ligisayan2017-08-11 17:27:21

Is it possible to set up forwarding of the filled data in the form to the table? 1Reply

S

Silverstr2017-08-18 12:15:10

What to use to create a database or a configurator? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question