-
-
-
I'm not 100% sure I understand your question Neu, but if you want to quickly amend the amount of rows or columns you offset by you could set those fields using the offset function referencing a certain cell.
For example, if I set the reference figure as C1, then set the rows and columns figures as some unused cell references. e.g. A100 & B100:
[code] =offset(C1,A100,B100)[/code]
By changing the number in cells A100 or B100 (rows and columns respectively) I can change how far across/down from the reference Excel looks, minus numbers will offset to the left/up, positive numbers to the right/down.
So to create the sum that it looks like you want you could do the following:
[code]=sum(C1-offset(C1,A100,B100))[/code]
So if A100 = 4 and B100 = -2 you would get sum(C1-A5)
As to setting different offsets, by which I presume you mean potentially different offsets per row? It would depend on what you'd use to differentiate them, some sort of =IF thrown into the mix to decide what offset to use, or even to use a locked reference.
Hope this helps.
-
-
Hi All.
I'm re-assessing what I want to do with myself over the next few years, including whether I do want to use my current savings as a deposit on a flat.
One option is to use part of these savings and go volunteer abroad. I already do some volunteering in the Uk for a couple of different institutions and love it, so the idea of travelling+helping people really appeals to me.
Unfortunately I've never really travelled, and will happily admit to probably being fairly naive about the whole thing. I've been doing a load of googling and trying to do my research but it seems like there is so much information out there and I don't really know where to turn. It's possible I'm just being some sort of giant, magical eejit.
So I thought I'd ask here! Can anyone advise reputable places to look for information on this sort of thing. Or what sort of things to look out for when viewing projects.
Thanks in advance!
-
-
-
-
Apologies if this has been brought up in the thread before (I did try reading through it honest, but the 178 pages beat me.)
Sports Pursuit are currently doing Icebreaker Merino wear on offer. I'm not 100% on how well they are priced (in my experience the sales can be a little hit and miss) but some of it looks to have some nice discounts.
They also currently have sales on women's Gore wear and Pearl Izumi stuff. I've brought stuff from them previously and it seemed fine, but I'll happily admit to not being the canniest shopper.
Just thought it might be useful for people!
P.S. If you do join up, doing it through this link will count as a invitation by me, potentially netting me goodies. As I don't really know anyone here I certainly don't expect anyone to do this and the above link will get you in without any shenanigans but nothing ventured nothing gained!
-
-
-
-
-
-
-
-
-
-
-
Hey there!
This is my first year doing the DD. Unfortunately not on my SS either due to breakages and cash shortages, (I only live in London vicariously through these forums). Is anyone travelling up from St. Pancras to the start park?
Also if anyone on here is called Leo Wood (s?) your Mum said I should look out for you! :D
Ta!
Welp, this has just made my day.
Eeeeeeeeeeeeeeee!!!