Previous Topic Next Topic

Multiple text in a cell

Closed
AfsanaEssop - 19 Jun 2018 à 06:07
 Blocked Profile - 19 Jun 2018 à 16:48
Hi

Please can someone help

I have text in columns that uses multiple words example, annual leave, sick leave, maternity leave and i want to add the number of times leave appears in a worksheet irrespective of what type of leave it is. I don't want to type each leave type in the formula. I am hoping there would be a way to ignore the first word and just use the leave word.

please can you help with a formula.

Greatly appreciate

1 response

Réponse 1 / 1
Blocked Profile
19 Jun 2018 à 16:48
Typically an "*" can be used as a wildcard. Sometimes "%". Excel uses the "*". SO, with that being said, the formula would be something like: 
=COUNTIF(C2:C4,"*leave*")


Have FUN!

Similar discussions

Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Cannot download multiple files at once in WhatsApp Web
nemonavicusrino -
dannygzus -

4 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to create two WhatsApp accounts on a Windows PC?
Lason -
talha007 -

3 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses