I am getting better in this after watching your videos. this particular example of counting text in range I did with countif function which was very simple.
@ExcelDestination
3 жыл бұрын
great
@movieactionclips3349
2 жыл бұрын
Ok. Very good information..now I want to show the result in a textbox in userform ..how to do it..
@navlessushieel2744
Жыл бұрын
Simple and easy code, thank you
@victoriaa4211
3 жыл бұрын
You are amazing!! Thank you for going in depth to explain and teach!!! I love this video!
@ExcelDestination
3 жыл бұрын
Glad you liked it!!
@mjh136
2 жыл бұрын
Thank you for this! Question, if i wanted to count more than value? Can it be done in the same macro?
@rachidbouabid847
3 жыл бұрын
Thanks for providing hints on VBA for excel. I would like to know if you could provide a vba proposition for: - counting specific words in a cell containing a long text (and if possible regardless of case upper or lower). - counting the number of cells where there is the occurrence of 2 or 3 words at the same time.
@shubhamkadam3595
Жыл бұрын
Hello sir have you got any video for the same? I am also stuck at same position..
@sheik5506
Жыл бұрын
Hello, What if, I have multiple worksheets? What is the syntax to enter more than one sheet name?
@travelplanetdubai3294
3 жыл бұрын
I have one problem , I'm looking for vba :- for A column under from particular cell(A3) to the end of row( Ex;- A3 to A36{Automatically select >Shift+downArroW}, count the cells for that( i'm now using manually Counta function) , The counta function display the value in another cell(G1).. for all I give Worksheets name basis , its need count for all worksheets in same CELL(G1) Please help me.
@anotidahmupemhi8209
3 жыл бұрын
How about if you want it to show both Pune and mumbai but its numbers seperately not the total
@SMH2007
3 жыл бұрын
is it possible that I can download this file and modify it for my own use? I don't understand the range mycell, is it referring to cell F2? Thanks.
@ExcelDestination
3 жыл бұрын
you can pause this tutorial, this code is short, you can make note and use this.
@phiwahalala9436
3 жыл бұрын
Thanks , my code is now running
@wayneseymour1
4 жыл бұрын
I have a input data form that I use to input data into a work sheet, I would like to see the number of unique text for that person when I recall their data to the form. I want to count how many "yes" answers in a column for a particular person and pass it to my upnput form once the record for that person is called. is selected.
@wayneseymour1
4 жыл бұрын
I have a input data form that I use to input data into a work sheet, I would like to see the number of unique text for that person when I recall their data to the form. I want to count how many "yes" answers in a column for a particular person and pass it to my upnput form once the record for that person is called. is selected.I dont know the coding but....something like if txtowner.value =xx then Txtyes.value = cell.range F:F where xx and yes is true...something to that effect.
@ExcelDestination
4 жыл бұрын
pls share your task at exceldestination@gmail.com
@ekoeisen7657
4 жыл бұрын
Many Thanks.. Very Helpfull
@ExcelDestination
4 жыл бұрын
Glad it helped
@vaishaliyadav5009
4 жыл бұрын
Sir please guide how write in VBA (when a change is done in one of the table cell, the new value to be automatically stored in another table that will keep all the values(old and new)
@ExcelDestination
4 жыл бұрын
For that, you need to use event programming. So, when you will press enter then code should be executed........try at your level. if it doesn't work then send me your task at EXCELDESTINATION@GMAIL.COM
@sandworduniversity8312
4 жыл бұрын
How to connect this all to a textbox in userform
@ExcelDestination
4 жыл бұрын
you can check some userform tutorials on my channel to learn that.
@OG_GAMERS7
2 жыл бұрын
In a similar manner for numbers and final list in descending order and repeat values
@vijaysahal4556
4 жыл бұрын
good sir 👍👍👍👍plz make a video with emp name qty sales nd calculate auto total amount
@ExcelDestination
4 жыл бұрын
You can check tutorial for calculating auto total at bottom automatically at following link : kzitem.info/news/bejne/2ICQ05drnIaaln4
@cuisinnasratdecor6431
9 ай бұрын
merci beaucoup
@alializadeh8195
2 жыл бұрын
Thanxx
@IbrahimAli-pt8it
4 жыл бұрын
How can I use sumifs via to sum data between tow date
Пікірлер: 31