+ Reply to Thread
Results 1 to 3 of 3

Google sheets / excel =query does not contain formula

  1. #1
    Registered User
    Join Date
    11-11-2022
    Location
    United states
    MS-Off Ver
    10
    Posts
    1

    Google sheets / excel =query does not contain formula

    I have a Google sheets that pulls data in from a Json. I am trying to execute a query to pull data from specific column to put into a separate tab on the same google sheet.

    TAB DRAFTKINGS has all the DATA

    I need to focus on COL: G, I, J K


    sheets help.JPG


    The Rows im trying to pull into a new tab should NOT contain " + / - " <---- any of those characters

    I have a formula made to pull the rows that have "Points" in the row

    points contain.JPG



    For the life of me i can't get it to pull does not contain + - /

    any help would be appreciated
    Last edited by 6StringJazzer; 11-11-2022 at 06:56 PM. Reason: Moved from Excel Formulas & Functions

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,092

    Re: Google sheets / excel =query does not contain formula

    to help us to help you, it would be much easier for us to try to provide a solution if you can share a sample file.

    See this link to a Google form, which will allow you to create a sample file specially for this enquiry.

    Blank Sheet Maker
    https://docs.google.com/forms/d/e/1F...VbWiA/viewform


    EDIT:

    On second thoughts, due to your post count, to make it easier for you i have already created the sample file into which you can recreate your sample data:
    https://docs.google.com/spreadsheets...gid=2100307022
    Last edited by janmorris; 11-12-2022 at 02:55 AM.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  3. #3
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,155

    Re: Google sheets / excel =query does not contain formula

    Try this;

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google Sheets: Can I Query and Importrange two sheets which have different structures?
    By jayped in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 09-16-2022, 05:01 AM
  2. Query Formula To Find Oldest Duplicates That Contain Certain Keywords - Google Sheets
    By Dave Shopping in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 07-07-2022, 02:06 AM
  3. Google Sheets. Can I connect offline data from excel to google sheets?
    By drlemur39 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-15-2021, 10:40 AM
  4. [SOLVED] Converting Google Sheets QUERY to Correct Excel Formula
    By davis909 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-17-2017, 09:14 AM
  5. Google Sheets QUERY How can I do the same in Excel?
    By Ziggy21 in forum Excel General
    Replies: 12
    Last Post: 10-04-2015, 07:54 PM
  6. [SOLVED] Converting Google Sheets document with query to Excel
    By playmate in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 08-04-2015, 10:18 PM
  7. Google Sheets Query IF column problem Converted to Excel Function?
    By Garthilk in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-24-2015, 10:37 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1