Thanks Thanks:  0
Likes Likes:  0
Needs Pictures Needs Pictures:  0
Picture(s) thanks Picture(s) thanks:  0
Page 1 of 2 12 LastLast
Results 1 to 15 of 27

Thread: Excel question

  1. 16th May 2007, 01:03 PM #1
    Daddles's Avatar
    Daddles
    Daddles is offline Grumpy old Bugga
    Join Date
    May 2003
    Location
    South Oz, the big smokey bit in the middle
    Age
    67
    Posts
    4,377

    Default Excel question

    Doncha luv these

    I've got a humungous spread sheet on which I record all my cycling data - yes, a bit geeky I know but it's fun and humours that wee voice inside that would love a job in a cubicle somewhere.

    I've got four bikes and keep a running tally of the distance done on each bike. This is done by a formula, not an input (it identifies the bike and adds the ride's tally to the total for that bike). So running down my spreadsheet, I've got a long line of numbers. This all works very well and is not the problem.

    The problem is one of tidyness
    The columns of numbers extend way down past the last entry - it was easier to copy the formula down the column for months ahead than to do it each time I make an entry. Trouble is, it's unsightly (so am I on the bike but not even Billy Gates can fix that).

    Is there some way of making the content of those cells invisible UNTIL I make an entry - eg, the bike totals cells appear blank until I put a figure in the 'ride time' column?

    I've attached a screen shot of the spreadsheet for your amusement - quite a few columns have been hidden and the zoom adjusted to fit it on the screen, but it gives you an idea. The columns in question are Z through to AD (E could get the same treatment for the same reason). What I'd like is for those columns to appear blank until I put a figure in column C.

    Any thoughts?

    Richard
    Reply With Quote Reply With Quote
  2. 16th May 2007 01:03 PM # ADS
    Google Adsense Advertisement
    Join Date
    Always
    Location
    Advertising world
    Age
    2010
    Posts
    Many





     
  3. 16th May 2007, 01:15 PM #2
    Gra's Avatar
    Gra
    Gra is offline Member for stupid ideas
    Join Date
    Dec 2004
    Location
    Hell with fluro lighting
    Age
    55
    Posts
    2,156

    Default

    =if(or(c###="",c###=0),"",{insert your formula here})
    I may not have gone where I intended to go, but I think I have ended up where I needed to be.

    My Other Toys
    Reply With Quote Reply With Quote
  4. 16th May 2007, 02:41 PM #3
    Daddles's Avatar
    Daddles
    Daddles is offline Grumpy old Bugga
    Join Date
    May 2003
    Location
    South Oz, the big smokey bit in the middle
    Age
    67
    Posts
    4,377

    Default

    Quote Originally Posted by Gra View Post
    =if(or(c###="",c###=0),"",{insert your formula here})
    Works a treat. Thanks mate

    Richard
    Reply With Quote Reply With Quote
  5. 16th May 2007, 03:00 PM #4
    Gra's Avatar
    Gra
    Gra is offline Member for stupid ideas
    Join Date
    Dec 2004
    Location
    Hell with fluro lighting
    Age
    55
    Posts
    2,156

    Default

    Glad I got one answer right today
    I may not have gone where I intended to go, but I think I have ended up where I needed to be.

    My Other Toys
    Reply With Quote Reply With Quote
  6. 16th May 2007, 03:12 PM #5
    Wongo's Avatar
    Wongo
    Wongo is offline GOLD MEMBER
    Join Date
    Nov 2003
    Location
    Sydney
    Age
    53
    Posts
    8,879

    Default

    Funny bastard. See I like you.
    Visit my website at www.myFineWoodWork.com
    Reply With Quote Reply With Quote
  7. 16th May 2007, 03:15 PM #6
    silentC's Avatar
    silentC
    silentC is offline SENIOR MEMBER
    Join Date
    Aug 2003
    Location
    Pambula
    Age
    58
    Posts
    12,779

    Default

    Bit hilly around where you live is it Daddles?
    Reply With Quote Reply With Quote
  8. 16th May 2007, 03:23 PM #7
    Wongo's Avatar
    Wongo
    Wongo is offline GOLD MEMBER
    Join Date
    Nov 2003
    Location
    Sydney
    Age
    53
    Posts
    8,879

    Default

    Why would anyone own 4 bikes is beyond me. I mean they all have 2 round wheels right? Don’t tell me you have one with rectangular wheels. You know that 25cm length, longer than 20cm width (or longer than anything shorter than 25cm ), kind of wheels?


    Visit my website at www.myFineWoodWork.com
    Reply With Quote Reply With Quote
  9. 16th May 2007, 03:25 PM #8
    silentC's Avatar
    silentC
    silentC is offline SENIOR MEMBER
    Join Date
    Aug 2003
    Location
    Pambula
    Age
    58
    Posts
    12,779

    Default

    I've got two.
    Reply With Quote Reply With Quote
  10. 16th May 2007, 03:30 PM #9
    Wongo's Avatar
    Wongo
    Wongo is offline GOLD MEMBER
    Join Date
    Nov 2003
    Location
    Sydney
    Age
    53
    Posts
    8,879

    Default

    2 wheels or 2 bikes? Its got to be clear mate.
    Visit my website at www.myFineWoodWork.com
    Reply With Quote Reply With Quote
  11. 16th May 2007, 03:31 PM #10
    Gra's Avatar
    Gra
    Gra is offline Member for stupid ideas
    Join Date
    Dec 2004
    Location
    Hell with fluro lighting
    Age
    55
    Posts
    2,156

    Default

    beat me to it wongo, I was going to say two what??? and leave it at that
    I may not have gone where I intended to go, but I think I have ended up where I needed to be.

    My Other Toys
    Reply With Quote Reply With Quote
  12. 16th May 2007, 03:34 PM #11
    Wongo's Avatar
    Wongo
    Wongo is offline GOLD MEMBER
    Join Date
    Nov 2003
    Location
    Sydney
    Age
    53
    Posts
    8,879

    Default

    Quote Originally Posted by silentC View Post
    I've got two.

    Me too.
    Visit my website at www.myFineWoodWork.com
    Reply With Quote Reply With Quote
  13. 16th May 2007, 03:37 PM #12
    silentC's Avatar
    silentC
    silentC is offline SENIOR MEMBER
    Join Date
    Aug 2003
    Location
    Pambula
    Age
    58
    Posts
    12,779

    Default

    Why would anyone own 4 bikes is beyond me.
    I've got two.
    What did you get in your HSC again?
    Reply With Quote Reply With Quote
  14. 16th May 2007, 03:39 PM #13
    Wongo's Avatar
    Wongo
    Wongo is offline GOLD MEMBER
    Join Date
    Nov 2003
    Location
    Sydney
    Age
    53
    Posts
    8,879

    Default

    Quote Originally Posted by Daddles View Post
    I've got four bikes and keep a running tally.......
    Read the question Silent.
    Visit my website at www.myFineWoodWork.com
    Reply With Quote Reply With Quote
  15. 16th May 2007, 03:41 PM #14
    Daddles's Avatar
    Daddles
    Daddles is offline Grumpy old Bugga
    Join Date
    May 2003
    Location
    South Oz, the big smokey bit in the middle
    Age
    67
    Posts
    4,377

    Default

    Quote Originally Posted by Wongo View Post
    Why would anyone own 4 bikes is beyond me. I mean they all have 2 round wheels right? Don’t tell me you have one with rectangular wheels. You know that 25cm length, longer than 20cm width (or longer than anything shorter than 25cm ), kind of wheels?


    It's all explained on me website.

    There's the Black Beast - the main brute of burden.
    The Europa - bought her in the eighties and she now serves as a fixed gear bike
    The Sow's Ear - the horrible hybrid that proves you can't make a silk purse out of a sow's ear but does do stirling work towing my daughter around on her tag-along.
    and the Diamondback moutain bike that is in grave danger of donating her 'bits' to a home made recumbent.

    So yeah, I don't need 4 bikes, but a couple more should see my needs filled

    As for hilly, I can tell when I'm in my driveway, the road's suddenly flat

    Most mornings I ride with my son to his school. The whole ride is a 25 km loop. There's about 5km of steep ups and downs to get to this hill (see attachment), we ride down it (topping 60km/hr), I leave him at school, turn around and have to ride up the sodding thing again. Then the 5kms of ups and downs before the final run along the ridge top to home.

    Richard
    Reply With Quote Reply With Quote
  16. 16th May 2007, 03:41 PM #15
    SPIRIT's Avatar
    SPIRIT
    SPIRIT is offline GOLD MEMBER
    Join Date
    Dec 2006
    Location
    MEL VIC AUS
    Age
    59
    Posts
    1,604

    Default

    Quote Originally Posted by Wongo View Post
    Read the question Silent.
    hay that can be a new saying around here READ THE QUESTION
    smile and the world will smile with you
    Reply With Quote Reply With Quote
Page 1 of 2 12 LastLast
« Previous Thread | Next Thread »

Similar Threads

  1. Question regarding salt tollerance of commercially important timbers...
    By Shinken Kami in forum FORESTRY MANAGEMENT
    Replies: 18
    Last Post: 8th July 2009, 10:56 AM
  2. Newbee saying G'day, and question about upgrading lathe motor with a bigger one...
    By colinshannon in forum METALWORK FORUM
    Replies: 24
    Last Post: 27th February 2007, 05:24 PM
  3. Two-part Question
    By Rodgera in forum WOODIES JOKES
    Replies: 1
    Last Post: 12th May 2006, 07:17 PM
  4. A question for Neil or someone who knows about wax
    By joseph84 in forum FINISHING
    Replies: 5
    Last Post: 16th March 2006, 09:33 PM

Tags for this Thread

Posting Permissions

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

Forum Rules