วีดีโอ

Thank you so much. But whats the name of the process if I need to do the exact oppsit.

Excellent explanation of calculated fields. I really liked the end of the video that described several reasons why I should choose a calculated field.

Shouldn't the cost calculation per impression be (Cost/Impressions) !!

I've been trying to do this with multiple rows for days, and your video helped me do it! Finally! Thank you!

I have two tee times for eight players. How do I generate a random list of four players on tee time 1 and four players on tee time 2. So four 1's and four 2's. I would also need same if there were enough players for three tee times (12 players) - four 1's, four 2's and four 3's. Etc.

Thankyou!... However, what would I type if I wanted to count cells that didn't have "sun" or "part" ?

Hello! Is there a way for the cell containing the xlookup formula to remain editable if no match is found? For instance, I have set up my spreadsheet so that xlookup fills in a corresponding price if a certain item is selected from the drop-down. However, sometimes a "one-off" item is entered which I've allowed as an "invalid" entry. Is it possible to edit the "price" cell as one would normally instead of being blocked by an error message in these unique cases?

thanks for this! How can I do the exact same things but from another sheet? I know how to reference another sheet cell by =SheetName!Cell-ID but what if I want to reference a table from another sheet?

Great info. Once you have a number of sum if formulas, giving you a list of dollar amounts (in my case). Can you then sort those columns by total spend?

MVP! Thanks for a concise video that explains clearly!

Is there anyway to reference the table column from outside the same sheet? For example if you have data in a table in Sheet1 and want to add a formula in Sheet2 to take the sum of the values in columnA of Table1, would that not be =SUM(Sheet1!Table1[columnA])?

=QUERY({sheetname!A:X2000;sheetname!A:X2000},''

I love you boss, i will watch your all video❤

Not sure why there isnt more comments here... answered all of my questions better than any other video on YT. Thanks for the insight

Hello, could I write to you?

What if you don't have a specific text you are trying to include or uninclude? Just getting a count of any cells that do not have text data?

Exactly what I needed. Thanks!

i tried to instal this and it is not working

Even with many quick access to AI prompt for quick tips, still prefer learning from hands-on guy like you, voice with demo. Thanks.

Please add Flight as a route option

I love your google sheet classes 😀

Hi there, how can I get the number of the week within the month, not a year. Weeknum provides the number of weeks within the year. I just need something within the month, so it would only display values 1 up to 5 Thanks!

Perfect! Thank you

Hi, I have entered your formular exactly as you have but it's counting all the cells including the blank ones. How can I avoid this ?

Why it didn’t work on my google sheet? Is their anything to do so I can use it? I already did the instruction seen in the vid. Thanks for the helps

hello could this allow me to recover the titles of public TH-cam videos and also to recover data from my Amazon seller account new: Do you use no code software like make? In fact I'm asking myself questions to try to understand the differences between custom GPT, chrome and WordPress extensions, automation software like browser automation studio and make I had an idea of ​​creating an SEO and image editing but I don't know how to go about it I thought of several solutions either with make or by creating a Chrome or WordPress plugin or by using a existing plugin but I don't think it exists to do what I want or even with a custom GPT seo: OK and what do you think about rank math? I understand that this extension allows me to scan my pages and find the keywords to replace, from my back end, have I understood correctly? And I also understood that this does not allow me to ask it to scan my entire website? I mean if I understood correctly it scans the pages but one by one and I have to do everything by hand? This is why I wondered if I could not create an extension to which I would give the URL of my website and have it scan all the pages and tell me which keywords to replace And I even wondered if I wouldn't be able to make a robot with custom GPT or even with no code software like make in the case where an extension wouldn't be able to allow me to do it, does this idea seem good to you? do you also create chrome or WordPress extensions? I'm asking you this question because I'm trying to understand what I could do with custom GPT, could I do more with a chrome WordPress extension? Does it exist or not and finally what more can I do with it? make compared to its other methods Amazon, jungle scout I would like to use the jungle scout api but at the moment I am looking into the subject of artificial intelligence and I realized that there are several ways to use APIs and so I would like to try first to understand what is the difference between using the jungle scout api in a dent custom gpt action and I realized that I can also use the JS api in a make scenario Could you tell me what the difference is, what could I get, using either of these two methods? And also with the Amazon API? I understand that Amazon has several APIs? Do you also sell on several marketplaces? could you give me your opinion could I send you an email

Thank you!

Hello, I am working on the small inventory management graph for my company where I move inventory between locations. I used Sumifs formula. I create transaction in one sheet and mark it ordered, it goes to Location 1 column in another sheet, then I mark it shipped it moves to Location 2 column, then I mark it received it moves to 3rd column. Which is perfect. But now I am stuck because I have to move full amount all the time. If I ordered 100 pc, I have to ship and receive 100pc but if I want to ship to different location only 20pc and location 1 will have 80pc left I can not do it. Could you please help me with that? Do you think it is possible to create it in Google sheets or it is too complicated?

Thanks for the great video. A helpful resource while documentation on this is so scarce right now

our lectures are amazing! I'm always learning something new, and you keep it interesting. Thank you

I love how easy it is to learn and catch up on the material on your short videos. Thank you!

can I somehow use two values for the key? For example: I have a table like in your example at 2:36, but I have two different people named Jim, one from South and one from North. I want to lookup for both their specialities by entering the name and region. How can I accomplish this?

We're in a remote, multi-user set up with the sheet on a shared google drive. Does the add on need to be resident on all user computers to function on users computers?

Thank you!!!

Where do you get the Option the extract specific data i only have summary and URL

Perfect explanation. Perfect conciseness of speech and coverage of "edge cases". You have a talent for teaching these.

but sometimes the importrange data is always error/reff. any solution?

Cant see the side panel

What if I want to compare two lists and only return mutually INCLUSIVE results. So only data that appears in both lists/columns

Amazing!

In range a:a I have the words None in some cells, and then emails in other cells. If I want to count just the # of emails I have, how can I do that?

Thank you for this! Super helpful and straightforward!

=TEXT(A1,"ddd") & =TEXT(A1,"dddd") work also for text form i.e. Sun and Sunday.

do you know how to fix the number generated ? so when I update the sheet it doesn't automatically change

Sheets Help, Your videos always make me happy, so I subscribed!

Thank you very much for the video! Your explanation was very helpful and easy to understand!

Thank you sir.

Lovely

I noticed it can only do approx 50 postcodes in a single run. And even after mutliple attempts of 3 times which is approx 150 searches it says limit has reached.

Would be awesome if it was free.. $60/year is steep for an add on