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.
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.
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
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
This was the best version I've seen on how to do this! THANK YOU!!!
Thank you, your instructions were very clear and helpful. I really appreciate the tutorial.
Thank you so much! I've been looking for hours.
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.
This was super helpful! Thank you!
Thank you Sir! Use me a lot and be successful.
Thank you Sir! 😍😍😍❤❤❤😘😘😘
Thank you so much!
Thanks man, I needed this !
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.
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.
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
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
I cant get anything to work, i hate excel and want to die