How to find the number of cells in Excel that contain a certain value?

Y

Y

YeaNot2021-07-18 16:51:08

excel

YeaNot, 2021-07-18 16:51:08

How to find the number of cells in Excel that contain a certain value?

There is a column where in each cell there are several words separated by commas. How can I get the number of cells that contain a certain word?

For example:
A1: Melon, watermelon, pineapple
A2: Cucumber, tomato, watermelon
A3: Cherry, cucumber, pineapple

2 of them contain the word "watermelon". But you need to get it through the formula.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

Similar questions

M

Michael2017-10-11 22:22:13

Does Excel VBA Application.ScreenUpdating affect applications? 1Reply

B

bobs322020-02-28 16:53:51

How to convert excel strings to datetime? 3Reply

D

Dmitry2017-10-16 17:03:09

Autocapturing the cost of a product when it is selected from a dropdown list? 1Reply

E

Evgeny Ivanov2017-10-17 07:02:49

What component should I use to work with Excel in RAD Studio 10.1 Berlin (Delphi)? 1Reply

J

Jurch2017-10-17 10:36:46

How to send a completed form on a site in xls format or another for editing by mail? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question