Видео

Very Confusing , Cant follow. Audio not very clear

Hello. Thanks for the video. Now is there a way to retrieve the data using the table name with App Script?

Very usefull information, thank you for this video!

Hey, thank you much.

what about syncing a single cell sheet to another file?

Structured tables are awesome, thanks for sharing!

Hi! Very good video! However, not exactly matching my need. I have 1000s of rows already matched on a customer number level. I now want a similarity score for address in system A vs. address in system B. Do you know if there are similar functions to do something like this? I could transform the rows to columns but that would try to match every single value to all, also to those not from the same customer.

Brilliant. I love this as this was the easiest way of using cell value as parameter

Interesting options. Thank you for share

Excellent explanation and solution that make the pivota error puzzle clear and easy to understand 👍👍

0:24- using "Percent of Total", Power BI's UI way 1:05- Calculate the denominator first (the hard part) (measure). CALCULATE([Years on Throne]),ALL('English Monarchs')) 2:20- Numerator divided by Denominator. DIVIDE([Years on Throne],CALCULATE([Years on Throne]),ALL('English Monarchs')))*100 3:40- another way that will work with filters better. DIVIDE([Years on Throne],CALCULATE([Years on Throne],ALLSELECTED('English Monarchs'))

Great video. Just enough demonstration to make your points without getting bogged down.

hi! i couldn't see where you copied and pasted the unique values in the calendar. it's cut off

This is the best practical use explanation about joining text in Excel. Thanks.

Great video! Thanks for it. I have tried doing the heatmap but every time I put annot=True the result is only seen on the first row of the correlation matrix. Any ideas what I'm doing wrong.

what do I do if there are multiple shows on one date? How do I ensure all the output shows?

This video is about excel but it's in the google sheets playlist.. Just letting you know :)

She always said Im getting married ....and in a few days Im getting divorce.....

really ? such a nice job and explanation, my 6 line fomula/ fuctions combination, just shrinks, Thanks alot

With this video i was ale to do things that not even my teacher does not know and I use it as a macro so I have a shortcut to another project. Thanks.

Literally the most helpful video!! Thank you!

I am current with all updates. I have BOTH Windows 10 and11. But on either computer, I don't have the options in collection like you do. Is there something that needs to be turned on? I would like to combine individual collections into a group. IE TRAVEL Sub collection, Germany, Poland, Iceland etc. Is there a way to do this? Also, When I am in the MAIN COLLECTION LIST I cannot "click and drag" a collection up or down. At one time I could do this before a GREAT MS UPDATE. Is there a way to alphabetize the collection tabs? Thank you

I do this stuff all the time and I STILL learned something from this!

If is possible that you guide from the crash. How did you get to the first page ?

Great video -

First cell and linking works but after I try to connect another sheet right below the cell that is working, the sheet that is working fails and it says. "Array result was not expanded because it would overwrite data"

About time. One of my top requests, after better named range management.

What are the apps on your taskbar?

is this already rolled out or is it still under BETA environment?

About time!!! Does this have structured references like Excel tables have?

I want to use Copilot but it’s only on the horrible new Outlook. Absolute garbage!

Great video, Can I use the same formulas if I changed out the date (day) filter to a month-year filter?

Why we are using Take function for selecting the 1st row? If I just use Vstack with 1st row only , that should work! Please, explain

Thanks for the help !

Have a question.... how do you set a table that if the cell header (Month Name) is past and the cell value in the columns below is 0 than Highlight using Conditional formatting?

How do you get it to also copy the formatting from the master spreadsheet to the other spreadsheet?

If I add an appointment to my outlook calendar with it automatically update in excel?

I have seen some other solutions, but your was great. I subscribed your channel now. ❤

excellent- a superbly done explanation - thanks very much aand all the best

You say that with the FILTER function you're limited to the order of the columns in the tablw, but that is wrong. Other than that, good video

Finally a great explanation about what a pivot table does in Google Sheets! I'm subscribing because I want to know more about how to use Google Sheets as I'm trying to move away from Excel.

I have a ques In Current Value option which link is Copied ?? can anyone help me please !

Hi, wanna ask if from 2 different GS and want to link it to each other, e.g GS file A link to GS B. If there is additional data add from time to time, how to ensure GS B will auto added as well? pls help

The one thing missing from every single youtuber is that Pivotby causes workbooks to CRASH. It works on the small demo files on these channels but not much more. The only honest assessment was on ExcelIsFun where MGI admitted that it does and it was a known problem. Thank you Mike Girvin for honesty.

this is exactly what im looking for. thanks

For years, VLOOKUP was considered the best solution, but now we're being told it's not adequate. I'm sorry, but I don't agree with this assessment.

Holy crap!!!!! Thank you so much!!!! Love this!!!!!

Hi David, this is basically exactly what I am looking for. Its great! However I have a question. Say for example you have improv on a Tuesday & a Wed right next to each other. Is there any way to get it to say improv only once across the two cells automatically , rather than improv, improv ?

I'm pretty new with sheets but was tasked to make a dashboard, and man, I was banging my head against the wall because I could NOT figure out why my slicers weren't affecting the chart, THANK YOU!!

Thanks! I really appreciate you showing PowerPivot usage. I am finding that tool very useful.