Видео

Thanks very much. It help me save a lot of time

THANK YOU! I have been struggling without this for MONTHS. I finally couldn't take it anymore and went to RUclips. God Bless you!

thank you!

Nice Sir❤

THANK YOU SIR

Yhoo i trying to do this but other data sources is not active

God bless you brother, it rlly did the work

Helped me in 2024

Hi Chester thank you so much for this awesome content, I am trying to follow along and create my own automated invoice system...but of course, having issues lol, I am using Excel 2019and I am on the first video and I can seem to make the reference customer list to work...also, when you create the customer table, under the email, can I add multiple emails? if so, how do I do that? I mean, if I use a comma between all the necessary emails, will Excel understand it? Thanks in advance

shit ahahahh wtf is that day formula man, how were you even able think that logic .....! damn....! you are absolutely amazing....!

shift + f3 for people in hurry dear uploader plz dont mind .

I use Excel in my spare time and for work, I do not know why I just love working on excel and this video put a huge smile on my face. It is like a new toy to play with. Thank you so much for this video, I cannot wait to start using this information

what is this cumulative frequency ? pls explain.

How can I make it always visible?

This was an AMAZING & informative video! Thank you!!! A+++

thank you

Thanks. U saved my life

Excellent video. Thanks

AMAZING, thank you

I want to apply this same concept to a list of values on a letter along with the decription of the value. I have benefit 1, 2, 3 all listed with the values next to each one with a grand total. Can you help?

You are a wonderful person. I hate excel but this make it easier. Best regards!!!!!

How to add additional field on a subform

Wow even ChatGtp kept messing this up... Spent 30 mins trying to figure this out and you solved it less than two minutes. Thank you!

Thank you so much. Few months ago I wasted 2 hours while merging two presentations and setting their format. I had to do it again in office so I searched it on RUclips and found this video. Really saved me from hectic efforts. God bless you. 💐💐💐💐💐💐💐

cant make programmable sumif range with indirect function: two cells representing start sheet and end sheet but it counts only that two sheets but not all inbetweens

that worked thank you

youd think after so many years microsoft would be a bit more with the times..

It worked Thanks ❤

Mantap bang terima kasih

Hi, i have exactly this message "Microsoft has blocked macros from running because the source of this file is not trusted". Macros are activated. I right click on file and there's no Security option with Unblock box that can be check. Same file work without problems on other computers

i am trying this formula but the messages "The pivot table isn't available because it exceeds the total number of characters that a cell can contain" can someone help ?

Excellent job done dear .

thanks, its very helpful

Hello just wondering maybe someone could help. What if I need to include only data until March. Let's say I have a cell with "As of" criteria? Thanks.

The text that I have with a background color is based on a conditional formatting so this formula doesn't pick the background color, could you please help me?

Damn this was the best excel video I ever seen. Right to the point without any filler.

Can u use the same reasoning if u want to apply this to DAX?

Any way of keeping the name of the sheet in the resulting table? (Say from your example, each row would retain the region name from the original sheet).

Hi, love your vidoes! My filename has special characters in it ( - and : ). What macros would you use to eliminate the special characters so that I can save the file?

My cursor doesn’t have mice and other pointing devices as an option

God bless you. Finally someone with straight forward tips.

Very helpful been struggling with data sanitization for years, though after learning this method i noticed the formula also removes the spacing which i found a bit undesirable so i added that last spacing( " " ) to the formula and the data comes out nice thanks for this wonderful tutorial = Table.AddColumn(#"Added Custom", "Final", each Text.Select([Item Description],{"A".."z","0".."9"," "}))

In the device manager there are No mouse drivers and Also my Mouse is not working and i just install my new Windows 10 pro

Thank you Mr❤❤❤

thank u very much

What if you need to have a drop down for every item on a list? How do you repeat these in 25 spaces below?

This is exactly what I needed. When I last searched for this information, the demonstration used the wizard and that did not work for me. I needed the full process. Thanks again!

THIS WORKED THANKYOU SO MUCH

And what if you wanted to extend the formatting to other cells? For example if you wanted the names in A:A to turn the same color as the numbers?

Thank youuuuu...great video❤️❤️❤️