I followed your video, but getting a "result too large" error. How can I use IMPORTRANGE column by column with 2 filters?

What if I want to count several colors without having to change the color each time? Like total amounts of yellow, total amounts of blue etc?

Hi, is it possible to use filter for multiple criterion? Like I want to importrange all the data of like 4-7 people (My Criterion) and put them in one sheet.

THANK YOU

I'd like to see what the formulas looks like when there's a single person with just a first name; my spreadsheet is broken. 🥲

Thank you for this video. I'm trying to use this same method using date range from multiple columns. I feel like I'm close but am getting parenthesis error.. Any ideas what I'm doing wrong? Thanks! =QUERY(IMPORTRANGE("google_sheet_url/","CLUBSMASTER!A:H"),"select Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8 where Col6 <= date '"&TEXT(C1, "yyyy-mm-dd")&"' and Col6 >= date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1) OR Col7 <= date '"&TEXT(C1, "yyyy-mm-dd")&"' and Col7 >= date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1) OR Col8 <= date '"&TEXT(C1, "yyyy-mm-dd")&"' and Col8 >= date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1)

Great video❤

thanks for this

how to make exception filter, ex show data except graduate?

Thanks man!

thankyousomuch

What i have been looking for! The only cells that did not import for me was the very top frozen row with the column categories. Do you know why this happens? Thanks!

I have a table with hundreds of stock trades. I would like exel to auto generate a new unique ID for each trade as I add it to the table. I would like that ID to stick with the row that contains the trade even when I sort the table by various columns (such as date or name of stock etc.). I can get excel to auto generate a number using concate but that makes the numbers long and awkward. Is there a way to get excel to auto generate a Unique ID for each trade so that I can re-sort by ID and get them back in chronological order?

Super helpful

Very helpful but How can I change the currency?

You would think a $400 billion company like Microsoft would have engineers that are capable of developing an uncomplicated, simple, swift, elegant and effective solution. As Einstein allegedly said, "Anyone can take a simple problem and make it complicated. It takes a genius to take something complicated and make it simple."

I needed this. Thanks.

I did everything step by step and got stuck with no option to choose the "CountFormattedCells" in the menu Extentions>Macros. Any ideas about what I can do to make it appear?

Too wordy - just provide the quick and simple answer

Hello, can also know how to use =VLOOKUP(IMPORTRANGE? I have diff data source were in I need to get the details on a specific cell. TYA

Good evening, First of all thank for this awesome video! I learn how to do the importrange and combined it with a query from another video to add a filter on it. I am working in logistics in a production environment and making a tab to check each production status. For instance a tab with "Nesting" when they are collecting the materials. This will come in the "nesting" tab. But during a weekly follow-up meeting I add comments in a column next to the import range. When the "nesting" than is being put on "finished product" the imported line dissapears (which is my intention), but the comment I wrote myself just stays in the same cell and thus is 'transferred' or 'linked' to the "nesting" row below. When a status changes and dissapears how can I also let the comment dissapear with it? Is this possible? Thanks in advance!

👍

This is awesome! Thank you! I love Sheets!

This is so great, thank you so much for sharing.

How sort by date

Man, love u so much for this

if I wanted the program to just give me the highest number that satisfies the first 2 criterias (without the kms_driven), how can I do that?

My Mac has no F keys.. it has a touch bar.

Thank you for the video. How do I allow the guest to modify the event? as the created events do not allow guests to edit the same.

If you are going to go with option 3 and 4, I'd recommend first going to "Customise Keyboard" in "Tools" to ensure that whatever keyboard shortcut you have in mind is unassigned/not being used.

Thank you some much!!!!!!!!!!!!!!

Doesnt work

Very nice... Thank you very much!...

Brilliant!! After failing with so many other tutorial I get this to work following your video. Now... How can I do this within the same file landing in a different tab(sheet). I would like Sheet1 to be SourceData and Sheet2 the Imported/Filtered Data

Result too large error showing during running formulas pls resolve the issue

This is amazing! I like it. What if there is an extension like Jr., III, Sr., etc.?

How do you do a count of names in a column of cells, IF there's other names in those cells?

If you had a date/time column, you might turn the date/time into a number and concatenate that number to the end which should generate a unique number.

Bravo!!!! Thank you so much. Thought I'd never find the solution lolol

Thank you very much.. for the techniques..

AFTER YOU COMPLETE THIS OPERATION YOU THEN NEED TO DO THE FOLLOWING TO CONVERT THE FORMULA VALUES TO TEXT * Select the cells that contain the data or other attributes that you want to copy. * On the Standard toolbar, click Copy . * Click the first cell in the area where you want to paste what you copied. * On the Home tab, under Edit, click Paste, and then click Paste Special.

I just followed your formulae and completed 9201 names in my spreadsheet - I then auto-filled the remaining cells by selecting the auto-fill button in each column, double clicked it to complete each vertical column and, Wallah, the whole operation took less than a a few minutes. Perfect!! Thank you.

thanks! modified this to fit my purpose -- I had no idea about Apps Script and the biggest hurdle was finding something that could integrate with Gmail and GCal that I was comfortable giving access to.

Thank you! This is life changing.

Thanks so much! The Excel app in Mac brought me here :)

I followed the example but my event is going to october 10, 2023. Any reason why that could be happening?

LOVE THIS!! Thank you so much!! Question: How do you TRIM spaces from before and after the name and extra spaces from in between the names?

Incredible - thank you

This is amazing! Thank you SO much for this-really saved hours on a new export we need to upload for a new list. Just one question for you, though-If someone has ONLY provided their first name (so no spaces appear in Column A), which currently causes all other formulas you create here to give a #VALUE error, is there a formula to ADD a space after their first name, which fixes the error?

Thank you. Easy to understand. I learnt a lot from your tutorials. Have incorporated to my work.