Тёмный

VBA: UDF to get the frequency of specific word in a Paragraph 

PK: An Excel Expert
Подписаться 270 тыс.
Просмотров 2,3 тыс.
50% 1

Hello Friends,
In this video, you will learn how to create a User Defined Function in VBA to get the frequency of specific word in a paragraph. Using this UDF you will be able to get the Total Words, Specific word count (Case Sensitive Check) and Specific word count (Non-Case Sensitive Check).
Click here to download the practice file:
www.pk-anexcelexpert.com/udf-...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...

Опубликовано:

 

21 авг 2019

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 13   
@yulinliu850
@yulinliu850 4 года назад
Great Job! Thanks for sharing!
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@Saatt79
@Saatt79 4 года назад
Innovative solution...awesome one sir 👏👏👏👏👏👏
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@albanoteles4924
@albanoteles4924 4 года назад
I am an assiduous reader of your works. I would suggest macro to add between dates. Start date and end date for Dashboard effect / expense report by headings. Thanks for sharing.
@amrutchitragar3014
@amrutchitragar3014 4 года назад
Excellent video sir. Sir make some video on class module in vba
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback. I will definitely try to make such video very soon.
@rickkeev4919
@rickkeev4919 4 года назад
Outstanding video and extremely creative. You're an absolute master of real-life problem solving solutions.
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback
@prashanttripathi3588
@prashanttripathi3588 4 года назад
Sir pls tell about vehicle loading planing
@vijayantduhan720
@vijayantduhan720 4 года назад
Hello pk another very good video very appreciated could you please tell me how did you upload this UDF in formula bar fx: where all parameter and intelligence was visible
@PKAnExcelExpert
@PKAnExcelExpert 4 года назад
Thanks for your valuable feedback. Just press Ctrl+A when formula is in edit mode.
@vijaysuman4137
@vijaysuman4137 4 года назад
Can you create video on vba and api connection
Далее
How to get the Last Row in VBA(The Right Way!)
15:41
Просмотров 152 тыс.
Send this to an artist… 😉 #shortsart
00:19
Просмотров 1,5 млн
HOW DID SHE WIN??
00:49
Просмотров 16 млн
Can We Save Goku In 5 SECONDS⁉️😰 #dbz #goku
00:15
100+ Linux Things you Need to Know
12:23
Просмотров 106 тыс.
Excel VBA Expert Tutorial
1:15:04
Просмотров 308 тыс.
Complaint Management System V1.0 in Excel
9:52
Просмотров 13 тыс.
Send this to an artist… 😉 #shortsart
00:19
Просмотров 1,5 млн