Outside of the main topic, I had no idea about some of the shortcuts used. F4 and double clicking that bottom right corner. I need a crash course on handy excel shortcuts as I'm clearly missing out.
Hi Chester, I always thumbs up for your hard work and valuable tutorials. I have a large excel sheet with more than 10,000 records which is a mixed data of Family and Singles. Ex: the family x9 people is considered as 1 job and a single individual is count as 1 also. Family x2 (Smith, Jessica & Smith, Bobby) = 1 or Family x6 people are still count as 1 task. Is there any way to create a formula to count and sum these tasks ? Thank you so much for your time and help.
Hi Chester Is there a way where we can convert heading and paragrah in word to Excel where heading should be Row 1 and paragraph goes to Column 1. The same has to be applied for multiple headings and paragraphs
Hello do you know how I can fix this problem How can I link two sheets so that I don't have a duplicate ID number when I create a new record with the user form? Thank you
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
Great video!, You Take a couple of complicated formulas and ideas, and create an easy to follow result. Keep up the good work!
This was the best version I've seen on how to do this! THANK YOU!!!
Took me 2hrs of fruitless research before ending up here, thanks!
been looking all over for something like this! Finally found it. THANK YOU!
The final part that you mention about not having to use ">0" inside COUNT.IF seems very interesting to me. Thank you Chester.
Thank you, nice and simple achieving exactly what was required.
Thank you, your instructions were very clear and helpful. I really appreciate the tutorial.
Thank you so much! I've been looking for hours.
Thank you Sir! Use me a lot and be successful.
Thank you Sir! 😍😍😍❤❤❤😘😘😘
Thanks man, I needed this !
this was very useful
This was super helpful! Thank you!
Thank you so much!
Outside of the main topic, I had no idea about some of the shortcuts used. F4 and double clicking that bottom right corner. I need a crash course on handy excel shortcuts as I'm clearly missing out.
Hi Chester, I always thumbs up for your hard work and valuable tutorials. I have a large excel sheet with more than 10,000 records which is a mixed data of Family and Singles. Ex: the family x9 people is considered as 1 job and a single individual is count as 1 also. Family x2 (Smith, Jessica & Smith, Bobby) = 1 or Family x6 people are still count as 1 task. Is there any way to create a formula to count and sum these tasks ? Thank you so much for your time and help.
Hi Chester
Is there a way where we can convert heading and paragrah in word to Excel where heading should be Row 1 and paragraph goes to Column 1. The same has to be applied for multiple headings and paragraphs
Hello do you know how I can fix this problem How can I link two sheets so that I don't have a duplicate ID number when I create a new record with the user form? Thank you
I cant get anything to work, i hate excel and want to die