Відео

The example formula used for 2 conditions was helpful for me. I had no idea what was wrong but the required formula was simple and didn't need IF or true/false components.

OMG! This is HUGE!!!! Thanks!

So helpful, I was asked this question and didn't think of wrapping with the "Value" Function.Thanks Jeff!

Thanks ❤❤❤❤

That's would be amazing... if my version of Excel had any of these menus and tabs. Sigh.

The other issue could be arrays that don't match in size

Text is displayed,pl edit and upload

The use of "FILTER" function is new to me, which is very helpful going forward, whenever I encounter similar situations.

Thanks Jeff! I totally got stuck on this exact problem and didn't know the value function would work. Looking up zip codes with an apostrophe in front of it would hopefully work for next time.

is there any way to xloop up Invoice 1022 with the ammount 852. this is most likely the problem in real life. lookup the the middle number

Excellent video, thanks, including how to use min and max in combination Paul

WOW! THAT WAS GREAT! THANK YOU JEFF!

Terrific. This was very helpful. Thank you.

Switch rules!

thanks

Thank you.

No need to edit a query to change the data source. In Excel go to Data -> Get Data -> Data Source Settings... and change it there. Also to select all columns in Power Query, select one column and then hit [Ctrl]A.

I use to 3 or 4 tricks but this is best way to do, faster and combining multiple tricks, really cool and perfect.

Very good, very smart.

I choose "Switch"

I am going with SWITCH function 😊

OK that last one was just too freaking cute.

That was a great video. Do you know if the excel has some formula using a change the color of the text or number? For example, if you use Xlookup formula, when you bring the text or number and, in this formula, use other formula to change the color. Thank you.

What about if the file location never changes but the file is replaced by a different named file, such as one indicating the date along with a name?

🙏🙏🙏🙏thanks a lot.....that's a great value addition

Thanks Jeff, as always great info...

Thanks, especially for the error description and solution. Paul

Good job Jeff 👍

Thank you so much so helpful! One question how to calculate -log 10 in excel?

Love your teaching style

🎉

Really appreciate this brother. you saved many hours for me.

Thank you for the content

Awesome some the best Excel formulas I have seen.

How do you compare two columns? I have searched and searched. I have two columns of numbers and want to have one cell at the top that simply will tell me if ANY records in column A exist in Column B.

Nice video, thanks for sharing!

Very useful and easy to follow. I have a question: what if instead of “open” in that cell I have a date? How do I tell the conditional formatting that the row needs to be highlighted as long as in the C7 column there is date? I need this as I share a doc and colleagues will go in and complete tasks, once they complete the task they enter the date in which they completed and I want to see immediately when this happens by having the rows filled in. Thanks

I tried this referencing another cell OUTSIDE the selected range and it did not work for me. Is there a way to do that?

This is too fast! 🤦🏼‍♀️

Please go slower in your teaching. You move too fast. Also if you could provide a copy of your worksheet/folder to us that we can download so we can do the steps with you, that would be helpful.

Super! How excel is easy with you! Thumbs up 👍

Perfect, both content and the style of producer!

Ok, now How add this "controls cell" in the ribbon? cause I didn't find it !!!!

Great hints but please, please , please speak slower. Your rapid speech makes the information difficult to follow.

thanks paul

Is there a way to unwrap cell that contains long text. I need to add title in between and the excel is preventing the cell to overlap to the next cell.

from folder isn't an option for power query on mac. Choose data source and excel workbook etc/ no "folder" option.

Awesome video

How about =CHOOSE()?

Holy heck this was so helpful.