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

P

P_Zeger2014-03-26 22:15:00

How to upload Excel file in MS Server Management Studio 2012? 1Reply

I

Innokenty Ivanov2018-10-24 09:49:59

How to generate columns from a list of unknown length? 1Reply

A

Alexey Smirnov2014-04-04 14:19:27

How in Google Docs Excel to count how many times a certain word occurs in a certain column? 1Reply

E

Emil Revencu2018-10-30 20:43:13

How to get first sheet name in Excel using VBScript OpenSchema? 1Reply

W

WebDiez2016-06-03 11:55:56

How to make a table based password generator in VBA? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question