Thats not microsoft 365 you time wasting old nag

I don't see the reference a file button in my version of CoPilot. Can I turn that on.

This was super helpful. Thank you!

Hello, thank you for this video! My question is: what about the used photos? Can we somehow find out their origin when AI finds/create them for us? I would use it at school but I´m not sure about how to do it legally. Thanx a lot!

This what im looking for..Great Fun

Very excellent tutorial. Very hwlpful. Thank you so much Ma

not sure if you will see this or not but... why include all three fields in the 2nd part of the sheet and only return one column of data? I thought by including first and last name in the table array (and for some reason you have workshop ID) that it would return both first and last name in the first half of the sheet. how would I bring over last name?

I'm going out of my mind. I do not see a References table ANYWHERE. Office 365 subscription, Win10 desktop.

Does X work faster than INDEX+MATCH?

Was really helpful maam

That was so Cool!!! I got some new Ideas on Excel

I saw this tip in another video. After you "append as new" in Power Query, go to Advance Editor and enter: let Source = Table.Combine({Table.AddColumn(Java, "Source query", each "Jazzy Java") , Table.AddColumn(#"Rio", "Source query", each "Rio Roast") , Table.AddColumn(#"Cozy", "Source query", each "Cozy Coffee")}) in Source This will add a third column with the Supplier Name. Then close and load table, formula =SORT(All_Products,1).

Yes! It's all about building relationships. We'll done!!

Thank you for this challenge and other Challenges, and for the great learning contents, and solutions clearly explained

In Power Query you can sort by Country, then by City (one at a time) and it works just fine. I like that this stays dynamic for adding new data.

It would be helpful.. instead of music... you can explain... what we are trying to achieve here.... Just a suggestion....

Very helpful. Thanks dan!

Excellent tutorial! Thanks Dan!

Nice explanation, Thank you.

I know this was three years ago, but... this REALLY helped. I have watched (too) many vids on VLookups with much, much frustration. I was recently told about XLookups and wanted to know the difference between them... this was super helpful and was presented in a manner I could actually understand. I am not an Excel fan, but I have to use it. My brain is not wired to grasp this stuff easily. I will definitely go back to this vid and check out the others. Thank you!

Same Solutions, We need some more PowerQuery test

i hate excel

Curious as to why there is no transcript with this video.

Aaahh i see my issue now i put the second $ in the wrong place

Excellent Quick Overview, Deb. I have seen a couple of your other presentations and you are always thorough, informative and quickly get to the point.

Thankyou

Great video! Clearly explained and to the point. Thanks

The checks should look for the correct answer and not the exact same formula. If the data is converted to a table and the formula uses field headers instead of ranges the correct formula shows as false.

An alternative I came across for the drop-down list was to use a Named Range from the table instead of the OFFSET / COUNTA formula.

Great conversation!

Thank you for taking the time to explain this so well. I viewed a number of other channels and I just didn't understand A. why I would use the indirect function and B. How to correctly write it. Your explanation is hands down the best. The key being, you provided an excellent simple example, your pace is good. This is by far the clearest explanation.

:))) solve all by PowerPivot in 1 seconds

This was great! Will definitely be using this technique on my own projects 📊

Thank you very much. Although I don’t know English well, I have benefited greatly from what you provide. Many thanks to you, madam.” 🌟

Thanks for an opportunity like this, appreciate

Thanks for this, Deborah. I think using INDEX MATCH with the -1 'match type' operator to look up the status of the stock from the table provided is marginally simpler than using the IFS function (only requires you to reference two arrays, rather than 6 individual cells). Otherwise I used the same approach -- FILTER is such a powerful formula, thanks for highlighting that so clearly in this exercise!

1:15 / 7:16

Great explainer in just one video. Short and crisp. Loved it!!

Explained so elegantly. Thanks teacher

Index match match still the best lol

Your explanation is superb. Good pace. Very clear voice. No annoying background music. Thank you.

I added two "&" to include the "job Title" column.

Promo sm

Absolutely beautiful, your commentary was very very helpful and joyful; i've also learned so many new shortcuts from this 🙂Thank Youuuuu!!

can u make steps how to combine with power query?

Fun exercise. I'm sure there are many ways to do this.

Hello, I am using Current Version (Preview) of Microsoft Insiders and for at least the last year my version of 365 removes duplicates from lists in Data Validation. But, some folks that have the same version do not. Do you know why this may be the case? And what version do you use for your problems and solutions here?

amazing way to solve exercise 1. i use nested if to solved that. i dont even know that can be solved with vlookup with true range lookup. new insight again. and what if analysis is really powerful feature, to calculate exact amount. thanks

Thank you. How would be the last formula if we dont use filter function?

wow amazing, didn't know what if analysis so useful