Відео

Hello help me plesa

Thank you so much, I tried and it worked!

Bro thank god, idk why it was so hard to find an answer to this question. I thought it was Shift, because I thought that was what I used to use in every other program, but apparently it is Alt in Excel. Thank you!

I don't have the Form object available to insert. I can only insert a Module or Class Module

thanks..

Thanks very so much

I really need to sort out something. I need to highlight a complete row, based on the LATEST or most recent date that appears in a Column. In order to highlight the latest date cell corresponding the column it is ok, and I use the formula MAX that works flawlessly; but when I try to highlight the complete Row the problems appear and I can't find a solution. Can you give me any help ?

is there a way for this to work on multiple different sheets? because it only worked on sheet 1, and i need it to work on multiple different sheets on the same file at different times

Thanks for this video, do we have an option to select multiple countries?

Thank you !

Thank you Dear For Your Vedeo

Which is the extension working in the background?

Awesome

Hi, this is extremely helpful. I need a dynamic sum and criteria range, so that when I copy the formula over, the sum range and criteria range will change. Is there a way to do that in this example? It would reference a cell for the A:A and B:B.

Cool tutorial! Thank you. Bombastic ! I have learned how to make a function out of a procedure!

Nice British accent)

hello I made a product catalog on Google sheet then I brought this catalog into WordPress I was wondering if it would be possible thanks to the combination of Google Sheet APIs, WordPress and the use of n8n software during the sequence that we are going to see and how many times would it be possible for all the keywords present in the description column of each of the products to be automatically replaced by good keywords? and the same with the images

❤👍

This was so helpful.

SAVED MY LIFE THANKS

If you wanna count the start of the week from Sunday, you can use: (date - starting date -3)/7+1

Excellent! Thanks!

🫡

Another solution instead of List.Generate that can simply be used as a Custom Column: = Table.AddColumn(#"Replaced Value", "Custom", each List.Distinct(List.Transform({Number.From([Start date])..Number.From([End date])}, each Date.StartOfMonth(Date.From(_)))))

what if you want the music to continue playing after that slide?

Power query is the best tool ever for cleaning data , easy to learn it and very powerful and with knowledge of m code , you can do anything

That’s nice , will check this out , it’s somehow similar to column by example in power query

The second scenario was a great eyeopener. thanks for sharing.

I've gotta give this a try.

What if I want to find the max value for a customer id and not the last value

Thanks, very interesting, is this a bit like Flash Fill? Paul

Could you please reshare the file? Unfortunately the link does not work

51:25 Well, I;m not sure whether it would work. The column names are hardcoded so for example when there's '2021 AC' it wouldn't be included edit: I think instead of 'Exppand' we can use something like this: = Table.Combine(#"Invoked Custom Function"[fnFiltersColumns])

This tutorial is so clear and easy to understand. I have some problem, the table result only show 10 data per row (because the website default is show 10 row, but we can change to show all) how can we fetch all data?

Awesome Sir

Excellent and it looks so simple! If I might suggest, could you preface the announcement of the videos in your email to advise the version/s of Excel to which the tutorial relates and functions (eg, 2021 v 365). Someone else mentioned "data scraping" ~ what if the website requires login and password (eg, for a bank statement or share/stock portfolio)?

I seem to have failed to subscribe somewhere along the line. I would have loved to attend this. For me any formula is a potential Lambda that has failed to dress properly, ready to be presented to the world. Without a named Lambda to wrap it, there is no 'statement of intent' to tell the user what it attempts to achieve. Any Lambda function is 'just' programming and complexity versus over-simplicity is basically a balance to be struck with every formula and function. The Microsoft Excel development team must face this dilemma every time they release a new function. And then I bitch about the shortcomings

That’s really cool, didn’t know you could do that

Need an introduction to LAMBDA first. Check out this video - ua-cam.com/video/bq82SKt5fC4/v-deo.html

Wow! That's great and didn't know about it at all. The transform by example is super. Thanks a lot!

Great presentation, Marco. Thanks for the shoutout. 😎

Thank Marco! Very entertaining and thought provoking presentation.

I shall finish watching this tomorrow, I think I've guessed the method, as I've done similar in in PQ with List.accumulate.

Hurray! Alan is the new king of the United Kingdom. Thanks to LAMBDA!😊

This is exactly what I needed. Thank you for this!

Sometime I get a '0' when i use this in the option. Can you please explain why this happens?

Hocam emeğinize sağlık Excelde uzman değilim Excel 2016 kullanıyorum 2016 versiyona göre formül ile yapabilimisiniz

Ruined by the music. How do I turn it off or do I need to unsubscribe?

Didn't quite get the step where you insert che checkboxes. I added both ActiveX and Form checkbox control to the ribbon, but I don't get either to paste any checkboxes into the cells I've selected. How does that work?

Thanks Alan very clear explanation, I just subscribed to your channel. One more question please, how about if want to count the duplicate in the whole sheet? lets assume, we have 3 companies and I want to know the employees registered in more than one company using their Identity Number?