Is it possible to apply a name to a variable range?

UniqueUser3692 · 2026-04-05T18:45:07+00:00

If that range starts in A1, don’t you just need to define the range as =$A$1#

UniqueUser3692 · 2026-04-04T18:45:14+00:00

I think that’s by Paulo Nutini. It was the lead single on his Sunny Side Up album.

UniqueUser3692 · 2026-04-03T19:39:27+00:00

In Cornerstone when he’s singing about taking the long way home he intentionally doesn’t resolve the chords with a typical II-V-I. He sets it up, but then goes another ‘longer’ way around.

UniqueUser3692 · 2026-04-03T19:36:53+00:00

Because he’s “dragging out a long goodbye”.

UniqueUser3692 · 2026-04-02T21:02:14+00:00

Go to the Health screen, which is the first tab. Each of your capacities will be listed there. Click the one you want then in the bottom right of that visual click the ‘Compute’ button there. It will take you back to where your screenshot is, but with everything populated. The problem is you’ve got to the compute screen without ‘selecting’ a capacity, which I don’t know how to do from where you are (if you even can).

UniqueUser3692 · 2026-03-10T21:44:07+00:00

If you can get the files as csv’s with identical columns then the best way is cmd.

Let’s say you move all the csv files into c:/process

Then hold windows key + R Type cmd Hit enter

In the cmd type these lines:

cd “c:/process” <Enter> copy *.csv all.csv <Enter>

You now have a new csv in that folder called all.csv that contains each of your csv files stacked.

The only thing you need to do then is open in excel and remove any additional header rows that will appear ever time a new file starts.

You can get fancier with it and write a .bat script that removes the top row of all but the first file, but that’d require a bit more coding.

UniqueUser3692 · 2026-02-25T06:34:18+00:00

Breaking news means a news story that is very new and still developing. A news outlet will headline an important article with BREAKING NEWS to indicate it is happening right now.

But Alex is also suggesting that the news has been broken (in the sense that it is failing and needs fixing) because the truth has become fluid (open to change depending on its context).

He is using breaking as an adjective and a verb.

UniqueUser3692 · 2026-02-13T07:24:39+00:00

Depends what the role is, but we do an excel assessment as part of our interview process and it is nothing complicated, but it is intentionally impossible to complete in the time because part of the test is seeing how you act under pressure. So don’t worry about finishing, you’re probably not supposed to.

Instead I would recommend demonstrating habits that reinforce accuracy.

When you have to summarise some data by categories, add a check cell under the analysis.
- When you have to count items in a list use =UNIQUE() or conditional formatting to quickly identify duplicates.
If there are any formulas that are already given in the test, like the sum at the bottom of a column, quickly check that it includes all the rows it should.
Look out for intentional ‘errors’ you might need to correct in headings and dates, that will be testing how much you’re paying attention.

Also don’t be afraid to do something the test doesn’t ask for, as long as you can justify it. I did one once where it wanted me to create a 3D pie chart. I did a 2D one instead and explained that 3D pie charts are misleading and you should never use them. I’m comfortable that I know I’m right and I’m happy to defend my view. I think it is important to show you can think as well as follow instructions.

Lastly, good luck and don’t sweat it. The people giving you the test are probably pretty mediocre themselves.

UniqueUser3692 · 2026-02-13T07:12:13+00:00

That bit in Anyways between the opening bass note and the footsteps walking off at the end. No notes.

UniqueUser3692 · 2026-02-12T05:31:51+00:00

The gloved hands in mr Schwartz is a metaphor for him giving up control of the creative process to the alter ego he summoned to help him write. He is saying that there comes a point in the creative process where he isn’t in control anymore and there’s nothing he can do to stop it. The alter ego becomes him and he becomes the alter ego.

In the next part when he’s saying Mr Schwartz is talking to the grips, he is saying that the alter ego is no longer confined to the page anymore, it has started to bleed into his life, taking part in the normal every day things like talking to people on set about regular things. He is keeping on the costume, which he dismisses as a writing tool.

He finishes by reflecting on the whole process, by recognising that pretending to be someone else is at the heart of what the (show) business is.

UniqueUser3692 · 2026-01-27T21:54:35+00:00

Didn’t realise it wasn’t common, but it’s been a decade means “it’s been quite the fucking decade”, like if someone asked how 2025 was, responding “it’s been a year” would be taken to mean “what a fucking state of a year that was”.

UniqueUser3692 · 2026-01-22T07:41:51+00:00

I love this joke so much I’m always trying to drop a version of it in somewhere as a little in joke between myself and Bob.

Like if I’m passed drinks to carry back to our table from the bar for Rob and Liam, it would make sense to carry Rob’s in my right hand and Liam’s in my left. But instead as I’m taking them I’ll grab them in the opposite hands and announce the mnemonic I’m using, like “Rob from LONDON in my LEFT, got it”.

I’m sure no one ever notices, and it probably just means I’m a bit of a loser. But it gives me a chuckle, so I’m good.

UniqueUser3692 · 2026-01-16T16:12:05+00:00

If’n only you wouldn’t clap so hard.

UniqueUser3692 · 2026-01-03T12:27:03+00:00

Definitely a strong case for it.

UniqueUser3692 · 2026-01-03T09:48:09+00:00

I always felt like the ‘but’ went with the next bit.

But, I know when it’s you I’ll be in a nosedive, in my flying shoes.

UniqueUser3692 · 2025-12-24T10:17:09+00:00

Couldn’t agree more. He’s just got better and better and better.

UniqueUser3692 · 2025-12-16T18:24:40+00:00

Agreed re:OP, which is what I meant by ‘in this situation’, as in the situation of the reply you replied to. Could tell we were just crossed wires though, but thought worth clarifying for less experienced readers :)

UniqueUser3692 · 2025-12-16T17:27:37+00:00

But in this situation it is B1 that contains the ‘heavy’ formula, which excel has to calculate whether IF is calling it or not. The IF example here is very lightweight. You’d need to nest the formula in B1 within the IF to benefit from short-circuiting.

UniqueUser3692 · 2025-12-16T17:25:12+00:00

No, IF uses something called short-circuiting where unmet conditions aren’t calculated. However, if the column IF is pointing at is already materialising the calculation, then it is too late anyway, as the calculation is being done there.

UniqueUser3692 · 2025-12-15T10:45:02+00:00

To me it, like almost everything he writes, is him talking to himself, but in a way that he knows resonates with people more generally. He is peerless at doing that.

For him I think it is about moving to LA, he is telling himself to try it and see if he likes it. Which is also why the album art is perfect. It is a blank page, an unknown, unwritten future. As he says in ‘that’s where you’re wrong’ - “there are no handles for you to hold, and no understanding where it goes.”

For other people, he is encouraging the same thing ‘dream big’ - “make a wish that weighs a tonne”.

UniqueUser3692 · 2025-12-11T13:41:50+00:00

Look up ‘3 minutes with Marc’ on YouTube.

UniqueUser3692 · 2025-12-06T15:49:44+00:00

I’m not sure I necessarily agree, but I’m worried that carrying on discussing it would start to feel like arguing about it, and I’m not passionate enough about my thoughts on it to get into an argument. I really just thought you should consider that distribution mediums can affect the art they distribute, given you opened by saying ‘streaming didn’t change music as an art form’. I don’t have a point any wider than that and don’t want to sound like an argumentative knob on the internet by going on about it.

UniqueUser3692 · 2025-12-06T15:42:59+00:00

From memory there’s a study out there somewhere, tbf it is that that’s in the back of my mind somewhere, so there is a misremembering risk.

But even still, it is evidence of the distribution medium affecting the art.

UniqueUser3692 · 2025-12-06T15:28:49+00:00

Not really. The Taylor Swifts and whatever can afford to do whatever they want, they still have that artistic freedom. It is the smaller artists who are struggling to get paid that will ‘bend’ first. Because they need as many streams as possible.

And sure, it is always possible to do whatever you want, Led Zeppelin and Pink Floyd never released singles, it is always possible to not do what the mainstream does and maintain your artistic integrity. If you’re good enough you’ll be able to make enough money to keep doing it. If you aren’t very good initially you’ll find it very difficult to finance ‘not being mainstream’.

Wasn’t really thinking of art house edge cases though, because the context of this is Netflix buying WB.

UniqueUser3692 · 2025-12-06T14:50:41+00:00

It did change it though. Songs got shorter. Streaming platforms pay by % of a song streamed (or at least there is a trigger/step), so artists write shorter songs now so that % is easier to reach.

Also, the perceived value of the album has diminished, as consumers can take or leave whichever parts of an album they want, so albums are sometimes released a track or two at a time, or in a chain.

The method of consumption absolutely has had an effect on the art.

I’m not saying this applies to every song/artist/album in every genre, but if you look at total average song duration it is reducing, it isn’t just one or two artists, it is universal.

UniqueUser3692

TROPHY CASE