or for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

3 lurkers | 101 watchers
Aug 2011
1:55pm, 31 Aug 2011
19,341 posts
  •  
  • 0
JenL
So if I could just work the funny little symbols into a recognisable tune they would weigh the same as a duck?
Aug 2011
2:02pm, 31 Aug 2011
16,017 posts
  •  
  • 0
HappyG(rrr)
Re Winniefrie's holiday packing spreadsheet -
http://www.youtube.com/watch?v=KEzt-tOK-kM
Sheldon barcodes his socks! :-)G
Aug 2011
2:03pm, 31 Aug 2011
51,774 posts
  •  
  • 0
GregP
Well said, Wenny-woo.
Aug 2011
2:04pm, 31 Aug 2011
21,510 posts
  •  
  • 0
Hoaxster
Bingo! Go to the top of the class. Do not pass go. Do not collect two hundred pounds.
Aug 2011
2:06pm, 31 Aug 2011
15,181 posts
  •  
  • 0
BigChiefRunningBore
*lost*
Aug 2011
2:07pm, 31 Aug 2011
4,666 posts
  •  
  • 0
Stander
"Text anaylsis"

Do you mean reading?
Aug 2011
2:09pm, 31 Aug 2011
51,775 posts
  •  
  • 0
GregP
Right Gang.

B36 is =SUM('Tri Times'!B235:B241)
B37 is =SUM('Tri Times'!B242:B248)

How do I 'do' B38, short of cutting and pasting B37 and manipulating the row numbers manually?

Cut and past gives =SUM('Tri Times'!B243:B249), but clearly what i want is =SUM('Tri Times'!B249:B255)
Aug 2011
2:10pm, 31 Aug 2011
51,776 posts
  •  
  • 0
GregP
Stander - compiler theory was my favourite course at university in the very early 80s. Lexical analysis and whathaveyou.
Aug 2011
2:11pm, 31 Aug 2011
4,667 posts
  •  
  • 0
Stander
Bet you were the guy everyone at uni wanted to hang out with then Greg.

;)
Aug 2011
2:13pm, 31 Aug 2011
51,779 posts
  •  
  • 0
GregP
Err, no, actually. Difficult to believe I appreciate.

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...

Related Threads

  • excel
  • support
  • tech
  • work








Back To Top

Tag A User

To tag a user, start typing their name here:
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 113,928 Fetchies!
Already a Fetchie? Sign in here