the background music is to quiet, make it louder next time please so i can understand less

Can we make multiple cells combo for dropdown list

thanks! - i was stuggling with what chatgpt was telling me!

Great video, always had issues making doughnut charts like this

How to switch off the time conversion when we change type from datetimezone to datetime?

Hi thanks for this - do you know if there is a way to replace the source data without the query breaking? (Ideally, when the source data is located on a different workbook sheet) I have tried replacing the data (manually) with the source data on the same sheet in the first instance but as soon as I use copy and paste to replace that source data, the query breaks because it is looking for a table name and where I believe this has been replaced when I pasted over the original source data. I have tried pasting new source data under the existing source date headings in the hope that the original table name in the query would be retained but excel sees right through that little ruse. Thank you :-)

Thank you. Ive been looking for this excel formula for quite some time. Saving this for future reference.

thank u so much Doug. u save my day!!!!

Thank you 👍🏽 this is what I was looking for

Awesome, clear, straight to the point, thank you :)

Explanation starts at 4:05

Nice! I wonder if Google Sheets have this feature.... Does anyone know?

You’re the man!!! Saved me from entering a half day down in the web searching rabbit hole.

Question, I really, REALLY NEED HELP. In the main table, if I change a value, it erases my manual input. How can I stop that? Would appreciate your help!

agh my issue is my hours cell is NOT calculating for some reason

Maybe I'm just stupid but for the life of me I can't understand why anyone would want to use this complicated bullshit.

what if i have something like SUAREZ Luis how do I separate that, thnks

How do you maintain scaling across bubble sizes over the years. In year one rev is $1M bubble size is shown, year 2 it increases to $1.5M scaling of the bubble size remains within the year of review how do you link all years so you see the bubble increase as the years move.

very useful, thank you :)

thanks man.. good tutorial

Happy New Year 2025! This is my third time reviewing this video to refresh my memory and make a new check register in my Excel worksheet. I dumped Quicken for this, and I've never looked back. 😄

I’m going to give this a try. I need to build an Excel file that will have about 12k rows. It will be used by about 20 people. They will be entering values in a forecast column. Anyone see any issues with this working while several people are working in the same file at the same time?

This is going to be a game changer for me. I’ve been trying to figure out how to do this. Thank you very much.

Doug, I just found your channel today and I’m loving it! I had a pdf where the table spanned multiple pages. Is there an easy way to append the tables?

This was great! Thanks!! You should update it using new excel functions: For values down the left side, I used this: =VSTACK(0,DROP(TOCOL(IFNA(SCAN(0,BYROW(COUNTIFS(NormalHours[Position],UNIQUE(NormalHours[Position])),LAMBDA(x,ROUND(x/ROWS(NormalHours[Position]),2)*100)),LAMBDA(x,y,(x+y))),SEQUENCE(,3))),-2)); and for the data I used this: =DROP(MAKEARRAY(27,9,LAMBDA(r,c,LET(Rc,r*c,Tre,3*c,IF(AND(Rc<Tre*c,Rc>Tre*(c-1)),1,0)))),-1). All I needed was 0 or 1, so instead if using 1 as value if true you could INDEX the column created by the first formula using r as the row number.

=AND(D$1>=$B2,D$1<$C2) Better formula. It will account for times that are not exactly predefined.

Great video! Very helpful. Worked perfectly.

Very nice excellent 👌

Thank you!!!❤

Thankyu

This is the FIRST video I've found without an accent and speaking WAY too fast, so you get a like just for that! 🙄

i see its not accesable in excel2007, but howabout 2021?

9 years later and you're still helping people. THANK YOU!!! I got the date function down but changing the data format to date from the serial number was what was confusing me.

Using a formula in Excel is even simpler 🙂 consider the following solution: =CONCAT(LEFT(RIGHT(A2,SEQUENCE(LEN(A2)))))

Can you please help me while there are different holiday calendar followed by different country, how to achieve !! end date will be different depends upon the country.

thank u so much! u r the best!

Thanks Doug

Why we can't set a cell as our limit of our spedometer like goals, for example your goal is on cell A2 and what you have reached is on cell B2 so you can set as your limite = A2 and whatever is the number there your spedometer will change. you need to set the limit manually on the settings, when we can be able to poin a cell to bring the number o the data as our limit there?

Thank you , Was so Useful

Oh M G! Thank you!

Thanks

Exactly what I’d been looking for! Thanks so much!

Thank you very much for this video

Very awesome

Je snapt er de tandjes van ga maar putjes scheppen 😠😠

I am still not able to do final steps, could you please help me

In Brazil we call this AWESOME method of "Gambiarra"

This was awesome! I successfully got the filter for the grand total column. But, the Grand Total row disappeared. Could you please explain how to keep the Grand Total on the Row? At the end, you said you could filter the Grand Total Sum column and make the Grand Sum row recalculate, but you didn't show it, could you please show it?

Perfect demonstration! Easy to follow. Thank you !!

Great Video Sir, but what if you have some middle names and some have only first names? I've been trying to do it; I could successfully extract the First and Last Names but failed to extract the Middle Names. Here, I'm giving a Sample Data and Functions: Raw Data: (Cell Address: Range("A1:A11")) -------------------------------------------------------------------- A B C D 1 Names First Names Middle Names Last Names 2 AlexanderWilliamJamesBrown 3 Goku 4AriaNguyen 5 Vegeta 6 AveryAnnPhillips 7 Frieza 8 HenryCharlesMarkGrenSmith 9 ChristopherJoneClibeBentickLordSmith Desired Output: ------------------------ A B C D 1 Names First Names Middle Names Last Names 2 AlexanderWilliamJamesBrown Alexander William James Brown 3 Goku Goku 4 AriaNguyen Aria Nguyen 5 Vegeta Vegeta 6 AveryAnnPhillips Avery Ann Phillips 7 Frieza Frieza 8 HenryCharlesMarkGrenSmith Henry Charles Mark Gren Smith 9 ChristopherJoneClibeBentickLordSmith Christopher Jone Clibe Bentick Lord Smith So far, My formulae: ------------------------------- First Names: =IF($A2="","",IFERROR(LEFT($A2,MIN(IF(ISNUMBER(FIND(CHAR(ROW(INDIRECT("65:90"))),$A2,2)),FIND(CHAR(ROW(INDIRECT("65:90"))),$A2,2),""))-1),$A2)) Last Names (If Available): =IF($A2="","",REPLACE($A2,1,MAX(IF(ISNUMBER(FIND(CHAR(ROW(INDIRECT("65:90"))),$A2)),FIND(CHAR(ROW(INDIRECT("65:90"))),$A2),""))-1,"")) Middle Names (If Available): Step 001) This formula gives me the Middle Names but the problem is that these Names are without Space. Formulae: =SUBSTITUTE(SUBSTITUTE($A2,$B2,""),$D2,"") Step 002) This Formulae gives me the all the positions of Capital Letters except the First Capital Letter so that I can insert spaces into those positions. Formulae: =SMALL(IF(ISNUMBER(FIND(CHAR(ROW(INDIRECT("65:90"))),$C2)),FIND(CHAR(ROW(INDIRECT("65:90"))),$C2),""),ROW(INDIRECT("2:"&COUNT(IF(ISNUMBER(FIND(CHAR(ROW(INDIRECT("65:90"))),$C2)),FIND(CHAR(ROW(INDIRECT("65:90"))),$C2),"")))))