Results 1 to 6 of 6

Thread: Any Google Spreadsheet experts?

  1. #1
    Squeeler Vini's Avatar
    Join Date
    Jul 2003
    Location
    Sheffield
    Posts
    1,769
    Thanks
    44
    Thanked
    8 times in 8 posts

    Any Google Spreadsheet experts?

    I'm playing with Google Spreadsheets at the minute, and it appears to be really clever (maybe it's not, maybe Excel is as clever- I just don't use Spreadsheets!)

    This is my spreadsheet (it's public, you can edit/play/etc...)

    Basically, I want to remove the *'s from the GBHI Data cell's and pull out all of the Sheffield Kings results.

    You can see what I mean in the Kings Web Data sheet, but I've bodged that and just pasted the Values.

    Surely this must be possible? Any Excel/Google Spreadsheet guru's around?

  2. #2
    Registered+
    Join Date
    Aug 2013
    Posts
    21
    Thanks
    1
    Thanked
    0 times in 0 posts

    Re: Any Google Spreadsheet experts?

    I don't get your question. Can you please explain?

  3. #3
    HEXUS.social member finlay666's Avatar
    Join Date
    Aug 2006
    Location
    Newcastle
    Posts
    8,546
    Thanks
    297
    Thanked
    894 times in 535 posts
    • finlay666's system
      • CPU:
      • 3570k
      • Memory:
      • 16gb
      • Graphics card(s):
      • 6950 2gb
      • Case:
      • Fractal R3
      • Operating System:
      • Windows 8
      • Monitor(s):
      • U2713HM and V222H
      • Internet:
      • cable

    Re: Any Google Spreadsheet experts?

    You will likely need to write some JS

    https://developers.google.com/apps-s...articles?csw=1
    H3XU5 Social FAQ
    Quote Originally Posted by tiggerai View Post
    I do like a bit of hot crumpet

  4. #4
    Senior Member
    Join Date
    Jan 2013
    Location
    West Sussex
    Posts
    530
    Thanks
    50
    Thanked
    44 times in 33 posts
    • Chadders87's system
      • Motherboard:
      • Asus P8Z77-I Deluxe
      • CPU:
      • Intel i5 3570k
      • Memory:
      • Corsair Vengeance 8GB (2x4GB) 1600mhz
      • Storage:
      • Western Digital Caviar Black 1TB (Sata3)
      • Graphics card(s):
      • Sapphire AMD Radeon 7870 2GB
      • PSU:
      • BeQuiet 450w (140mm)
      • Case:
      • BitFenix Prodigy
      • Operating System:
      • Windows 7 Home Premium
      • Monitor(s):
      • Samsung 21.5'
      • Internet:
      • Sky Unlimited

    Re: Any Google Spreadsheet experts?

    EDIT: I can't see any 's in the spreadsheet so not sure what the question means.
    Last edited by Chadders87; 02-09-2013 at 01:06 PM.

  5. #5
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,168
    Thanks
    803
    Thanked
    2,152 times in 1,408 posts

    Re: Any Google Spreadsheet experts?

    The best tip I've found with google spreadsheets is not to use em....
    throw new ArgumentException (String, String, Exception)

  6. #6
    Not a good person scaryjim's Avatar
    Join Date
    Jan 2009
    Location
    Gateshead
    Posts
    15,196
    Thanks
    1,231
    Thanked
    2,291 times in 1,874 posts
    • scaryjim's system
      • Motherboard:
      • Dell Inspiron
      • CPU:
      • Core i5 8250U
      • Memory:
      • 2x 4GB DDR4 2666
      • Storage:
      • 128GB M.2 SSD + 1TB HDD
      • Graphics card(s):
      • Radeon R5 230
      • PSU:
      • Battery/Dell brick
      • Case:
      • Dell Inspiron 5570
      • Operating System:
      • Windows 10
      • Monitor(s):
      • 15" 1080p laptop panel

    Re: Any Google Spreadsheet experts?

    Quote Originally Posted by Alanna View Post
    Well i've opened up the sheet but there's no ('s). Don't know that there might be some problem in sheet sharing.
    Or it might be that the question is 2 and a half years old and the data's changed in the mean time...

    Given this thread's been necro'd twice with no useful assistance being offered either time, I'm going to close it to prevent a repeat...

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Are there any google sketch up experts...
    By Russ in forum General Discussion
    Replies: 5
    Last Post: 19-07-2011, 11:26 AM
  2. google calender experts?
    By circuitmonkey in forum Software
    Replies: 1
    Last Post: 09-05-2010, 09:38 AM
  3. News - Google Chrome races out of beta
    By HEXUS in forum HEXUS News
    Replies: 34
    Last Post: 15-12-2008, 01:53 PM
  4. Replies: 3
    Last Post: 24-02-2006, 05:28 PM
  5. Google Earth
    By Steve in forum HEXUS News
    Replies: 54
    Last Post: 12-08-2005, 11:58 PM

Posting Permissions

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