Відео

No idea if you still see these comments. I have a slightly different problem. I want to assign a unique index number for each category, say here Consumer Services would be '1', etc. No counting. Then I want to have a column back in my worksheet where every 'Consumer Services' line would have an index number 1 next to it in a column. So the original worksheet with '1' next to Consumer, '2' next to 'Health' etc. But I have tens of thousands of lines. NOTE: FYI- In fact I actually do not have Categories but company names, and next to each I have many rows (quarters of financial data). I just need a way to 'ID' each company on all its rows of data with a unique index number. Can you tell me what step to modify?

Thumbnail is spot on 😄

Thanks, very useful. I have a database with job information, including keywords for each jobs and images. I tried to set up this keyword search power query which worked like a dream, however the images don't show up in the output table. Do you know if this is possible to achieve?

Thanks

You explained it in just 50 seconds. Awesome! and thanks for the video

It's working, thank you!!!!

This is exactly what I needed. Thank you!

Thank you very much :)

Doesn't work for me

Thank you for this video! Finally through my efforts with Google I found out it was possible in Power Pivot but this made it really easy to see how it works. :)

8 years and still helping! Thank you!

Can you possble talk faster ?

How do make the pop-up only occur if the cell contains a specific text/word?

Great! A very helpful alternative!

Complicated

bless your soul

best tutorial for this purpose. Thank you.

Thanks very much. However, it is a bit confusing when you load your mgr_select query. My Power Query kept on wanting to load it as a table and I eventually managed to get it to load as a single value (is this a parameter?) by closing the query down without loading

I have a similar scenario with Amount 1, Amount 2,...., Amount N columns, can you please advise how do I tackle that scenario

I couldn't agree more with other positive comments below. This is by far the best explanation video. Thank you so much!!

You are amazing. I did NOT know that excel has such useful features. Thank you, thank you, thank you. Blessings.

Exactly what I needed. Thanks!

grazie

my stock data does not allow me to do a scatter plot, it keeps showing me dates 50 years before my cutoff and 30 years after my current value and wont allow me to adjust

Great help, thanks! still works

What if I want to find the max value for Item 3 instead of the last value? What formula I should use?

Can I add United States Dollars in the front

i found mistake in header description .. when i refresh it duplicates my queries any help witth solution ??????? thank u ..

Still not sure what it's supposed to do ( sorry) made a two column table; items, unit, pivot table sum units count items, set both to index everything = 1 ?

Thanks Doug! That number is also great for urban planners to see if they need to double their infrastructure, if a city is seeing 5% growth they need to start planning on doubling their water treatment, police, fire, etc.

I hate this function, I never remember what to use, X% 0.00, or just a number, end up just doing it with the formula, same goes for all the depreciation stuff, still thanks for reminding me😳😳

It was a great help

This was BS: the point is to add a background printable photo UNDER the cells !

You Saved Doug. Struggling from 2 days to get This one Thank You Soo much. Appreciate your work.

thanks great vid.

Hero!❤

34 bananas at 35 cents is $11.90; $13.26 would be 39 cents each

Hello, I had spent so many hours today on Google to find this logic and so so happy to finally find your video, super helpful and thanks a ton (have saved it) 😊

thanks omg!!!!!! i have an exam tomorrow you saved me

Hi Doug. Thanks for this video. It's a great time saviour. I tried this for my application where the keywords are a combination of numbers, alpha-numerals, aplhabets etc. (For example F-13.245, F-25.01 etc.) but unfortunately it is unable to match & keeps throwing an error after comparosn. Can you help me solve this?

This is great but how do you do if multiple tables?

Really appreciate this walk through - Thank you so much

Hi Doug, I have a powerquery file which I have prepared for my colleagues in a TEAMS. All of them can access it but the problem is that this file is connected to my msteer file which is hosted in another TEAMS and when they open it It does not update. How can I do to make sure that my colleagues can update it easily (I don't want to ask them to copy codes or whatever, it must be transparent for them) ? How can I do ? Many for your technical feedback !

finally !! found this tutorial, thank you sir it helps me get more tricks

Finally!!! You're such a lifesaver <3 I kept trying Shift + Enter the whole time but it didn't work. Thank you so much!!!!

this is what I have been looking for ages. Thx man!

Hi have been watching your videos about reconciliation using power query, you have really helped me. Now how can you match the positive(debt) and negative(credit) amounts not references. Let's say if the ledger references(using voucher number to payments) are different from bank references in excel power query suppliers reconciliation

amazing ! it works !!

what is the function of 2,1/ after lookup?

👏VERY CREATIVE SOLUTION! Thank you!