Count Cells that Contain Specific Text in Excel - EQ98

Count Cells that Contain Specific Text in Excel - EQ98

TeachExcel

2 года назад

98,289 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@chinchenming254
@chinchenming254 - 22.12.2023 11:43

like this, simple and useful.

Ответить
@rajeshkumarsharma4752
@rajeshkumarsharma4752 - 20.09.2023 16:10

Thanks for this video. I was in need to count specific word and this will work. ❤

Ответить
@peachesh1
@peachesh1 - 13.07.2023 22:14

Tried 3 other videos before i found you and the * was the missing key. You're the bomb, thanks!

Ответить
@Wavychak
@Wavychak - 21.05.2023 05:44

that's why!! I've been searching for hours, thank you !

Ответить
@saspective
@saspective - 07.04.2023 09:29

GOD THANKS! YOUR TUTORIALS HAS SAVED MY LIFE 😭😭😭😭

Ответить
@WoodBlock707
@WoodBlock707 - 22.02.2023 03:12

Thank you sooooo much!!!

Ответить
@shimaxful
@shimaxful - 01.02.2023 04:20

Thank you thank you thank you

Ответить
@maramalbadrani5453
@maramalbadrani5453 - 11.12.2022 19:43

you have no idea how this tutorials help me with my work, Many thanks 👍

Ответить
@RoquitoTalamillo
@RoquitoTalamillo - 05.12.2022 05:19

It really helps me a lot .. thanks for this tutorial.

Ответить
@ninamaemacaballug6293
@ninamaemacaballug6293 - 23.10.2022 16:16

How to this with numbers in specific cell? and the numbers are within the range. My problem is that if i want to count numbers with 31-22 it also count number with 31-2. how can I fix this?

Ответить
@jrake
@jrake - 19.10.2022 18:39

Thank you so much. What would you suggest if I have a column of hundreds of order dates and I want to easily see how many orders we got on each day?

Ответить
@theone-tv8tx
@theone-tv8tx - 22.08.2022 22:26

This was useful, but I was wondering if you would be able to provide a formula to count specific words in a sentence on multiple pages or excel books> Not counting cells that have the word, but counting specific words from multiple sentences on multiple pages? I looked through your videos, and coldnt find anything. thanks.

Ответить
@andrewmountianou2697
@andrewmountianou2697 - 09.08.2022 23:23

how to do the same but instead of using the "Red" a text in a cell

Ответить
@mikeseal3053
@mikeseal3053 - 17.06.2022 00:18

Thanks

Ответить
@leonritzeler242
@leonritzeler242 - 07.04.2022 15:37

Could you also count them based on another cell, for example if 'red' was typed out in another cell?
For example if 'red' was in cell B1 =countif(A1:A5,"*B1*")

Ответить
@telestruct
@telestruct - 16.03.2022 14:09

Informative, thanks !

Ответить
@zarniwhite6249
@zarniwhite6249 - 29.11.2021 08:55

Amazing presentation! Thank you 🙏

Ответить
@sabrinamimouni8306
@sabrinamimouni8306 - 12.10.2021 15:18

You're amazing!

Ответить
@wayneedmondson1065
@wayneedmondson1065 - 01.10.2021 08:35

Great tips! Thanks for sharing :)) Thumbs up!!

Ответить
@nbjamspice
@nbjamspice - 01.10.2021 03:00

These tutorials make me a superstar. I can't believe how much I learn and the time it saves instead of doing it manually. It's amazing how much you discover can be done with formulas. I feel so good when I follow the steps on my own and it works.❤❤❤

Ответить
@magicassassin1947
@magicassassin1947 - 01.10.2021 00:58

Hi do you have algorithm for assigning values numbers that are not yet taken ?💓🙃🙃

For example

You already assigned 2 numbers

4 and 5
And the next number will be assigned on numbers in ascending order from 1 to 2 to 3 and so on as long as it is not yet taken
For example.
4 and 5 is already taken

4
5
So the next number will be
1
2
3
6
7
And so on as long as not yet taken

Ответить
@nadermounir8228
@nadermounir8228 - 30.09.2021 20:29

Grest tip about finding the word separately. Thank you for your hard work

Ответить
@al-jannatengineeringacadem7427
@al-jannatengineeringacadem7427 - 30.09.2021 15:32

Thank you so much Sir

Ответить