Great!

Yes. If you check the playlist it's in there someplace.

I was just about to request a lesson on regex! I've tried to learn from so many sources but it's still an enigma to my brain!

I have videos on REGEX functions in Google Sheets on the channel. To be completely honest with you, it takes a long time to be good at writing regular expressions. After years of using it I'm still finding it confusing sometimes.

@@ExcelGoogleSheets But they are very effective and in web analytics, you only need a subset. I benefit A LOT from regex.

Use subquery

OR, watch Part 1 in QUERY series.

What does "batch paste data function" mean?

kzfaq.info/get/bejne/pLKHa7aW193SeqM.html

=QUERY(Game_Data, "Select B where F= '"&'Game Data'!F4&"'",0)

@@ExcelGoogleSheets Perfect tyvm

I'm not sure what you mean. These are not ranges.

I understand: "Named Ranges" in Google Sheets is where one defines a name to refer to a cell or range of cells as in this example B3 could be named "amount" and B4 could be named "region" ...if those named cells are moved or split apart by adding new rows or columns they would always be referenced, even if moved to another tab in the workbook the variable (named range) has a global scope and can be used quickly in any cell or formula without needing to refer to the Worksheet tab name and cell (I.e. Data!B3) The Tutor is one the best in regard to Learning Google Spreadsheets, and taking the general route (I.e. for beginners) is usually the best route to teach the concept of referring to a cell that has a "value" versus a "header/label" and understanding the value types (I.e. string/text, int/number, array/bracketed csv) Not understanding the concept FIRST, could cause a person to use named ranges with mistakes like naming the label instead of the value. Ie. SUM(total_items * item_price) returns errors because it is trying to sum the label ('item' * 'price') as text instead of the value (3 * 2.99) ...all due to the user not clearly understanding the concept of referencing cells and moving to the advanced parts to quickly. But again, I understand what you mean; for I only use Googe Sheets because it does allow referencing cells (defining variables) by name otherwise I would just stick with Excel because there is no other way to fly as a programmer--especially when referring to a cell or cells that dynamically affect/update other cells. #namedranges #googlesheets

@@ExcelGoogleSheets heres an example: =QUERY(F:F,"select F where F < "&named_rangle_variable) named_rangle_variable is a named range of a single cell, eg A2

@@navigatormoore Named ranges in Excel work the same way as they do in Google Sheets in my experience.

@@cdamaingoogleaccountcortex2919 You could certainly do that, but that's not directly in the string. The point of substitution is to leave the query string intact. Having pretty variable names or reference names is a whole different issue.

INDIRECT function

@@ExcelGoogleSheets Thank you very much

One thing that is obviously inaccurate is the use of group by without any aggregate function.

* means all columns. Watch QUERY series for more info.

docs.google.com/spreadsheets/d/10QXfX2OqIbHJNnylAuTL6-MJ0EfNADG7e75ZKq-j_F4/edit?usp=sharing

@@ExcelGoogleSheets Sr, grant me to edit this file for practice

@@usmaniqbal1836 click on file - make a copy