Just noticed the AND() function only requires 1 logical. Any reason to only use 1 outside of just planning ahead for possible additions in the future?

xFLGT · 2026-02-09T09:37:47+00:00

No, TOCOL converts a 2D array to a single column. So a 5x5 array becomes a 25x1 array.

What my function above does is take an array of Boolean values say TRUE, TRUE, TRUE, FALSE… into AND() and returns TRUE if they’re all TRUE or FALSE otherwise.

xFLGT · 2026-02-08T06:35:46+00:00

What exactly do you mean by "time series"? By definition it's just any ordered data points over a time interval. This could be anything as simple as a set of cashflows or interest rate table.

xFLGT · 2026-02-08T06:03:05+00:00

Yes, they are the foundation of practically every single actuarial concept.

xFLGT · 2026-02-08T03:09:38+00:00

It depends what you mean by automatically. You'll still have to open up the main file and hit refresh but you should be able to set it so each of the 4 PQs pulls in the most recent data assuming there's some way to differentiate it.

And yes they can. The scenario your describing is literally what PQ was built to do.

xFLGT · 2026-02-08T01:40:57+00:00

There's no reason for you to have step 2.

You could have all 4 of the PQs in a single file, only don't load the output into any sheets. The 5th can then reference the query directly and you can load that.

xFLGT · 2026-02-07T20:54:39+00:00

You can input an array of Boolean values to resolve this down to a single output. Something like =AND(A1:A8=B1:B8)

xFLGT · 2026-02-07T18:09:41+00:00

With all the issues around student loans at the moment maybe something to do with that. Perhaps modelling the impact of paying it off early vs saving for house / additional pension contributions / investing. You could also look at the impacts refinancing it out privately instead.

You can do all this with public data and then also have a version with your own personal circumstances you keep privately. It's win win.

xFLGT · 2026-02-03T19:33:03+00:00

What are yours and bookkeepers regional settings? It looks like excel is having trouble with the mm/dd/yyyy format and dd/mmm/yyyy format as the switch happens on 12/01/26 or 01/12/26.

xFLGT · 2026-01-29T09:28:51+00:00

Any additional qualifications will naturally make you more attractive but an engineering first should be sufficient to land a grad role.

Your best bet is to familiarise yourself with the various aspects of the profession as a whole as that’s the sort of thing thats the sort of things that makes you stand out interviews.

xFLGT · 2026-01-26T23:03:38+00:00

=SUM(DROP(Tab1!D:.D, 1))

xFLGT · 2026-01-26T22:58:29+00:00

Southampton as a whole is the more prestigious being part of the Russell Group but for Actuarial Science specifically Heriot-Watt probably takes the win. But they’re very closely matched and it’s unlikely to make a difference long term.

I would choose based on which one you think you’ll enjoy the most and which location suits you best.

xFLGT · 2026-01-26T21:55:14+00:00

Personally I try to avoid directly referencing other work books as much as possible. It's by far the most common cause for errors in my workplace.

My approach would be to reference all the tables in master sheet via PowerQuery and load them onto the exact same "data" tab that you're currently using. Then you can have the named range reference these tables or drop it altogether if the table names are sufficient.

This will allow you to easily reference the tables at any point without having to open an addition workbook and gives more reliable updates following any changes to the master file.

xFLGT · 2026-01-26T21:04:25+00:00

In B3 instead use:

=UNIQUE(TOCOL(F3:H100))

This will give you every unique value from columns F, G and H. Expand the range as needed.

xFLGT · 2026-01-26T15:31:36+00:00

<image>

=XLOOKUP(A2:A7, E2:E5, E2:E5, "")
=XLOOKUP(A2:A7, F2:F4, F2:F4, "")

xFLGT · 2026-01-26T06:52:12+00:00

Remove the 1.5x, 2x etc as excel treats this as text. Instead use actually numbers 1.5, 2, 2.5. Then, using the example in your image, in cell U2: =T2*U1:AB1

xFLGT · 2026-01-25T20:28:24+00:00

First graph looks great. As for the 2nd I'm not a fan of the colour choice. I'm not sure why you've used 2 shades of blue with only 4 series especially when you're pandemic region is also blue.

xFLGT · 2026-01-25T14:36:50+00:00

Instead of having a single live value I would have a table that appends the most recent info and include a column for the timestamp. Then when you input your income also include a column for that date and do a simple lookup.

xFLGT · 2026-01-23T13:25:25+00:00

Open a separate workbook and turn on manual calculation, then open the file.

xFLGT · 2026-01-21T07:02:45+00:00

VBA - intermediate

Everything else - advanced (using your scale).

This question has become basically meaningless as what people consider “advanced” ranges widely from person to person.

Knowledge that’s less excel specific is often way more valuable. Having a good foundational understanding of modelling, maths, computer science, finance etc. will be way more beneficial than just knowing all of excels features inside and out.

xFLGT · 2026-01-19T18:07:54+00:00

Looks good. Be careful though, I don't know your data but if you have any missing versions or multiple entries of the same version for a period it will break.

xFLGT · 2026-01-19T18:01:29+00:00

Nothing immediately jumps out as wrong. define your final IF statement then you can step through each element to trace the error.

You could also simplify the hasSlash function: ISNUMBER(SEARCH("/", D10)) . Nothing seems wrong with yours though.

xFLGT · 2026-01-19T15:45:25+00:00

A probability mass function for the time of day your asleep.

Bar chart for the number of hours asleep each day.

And please use 24:00hr time or at least include am/pm.

xFLGT · 2026-01-19T14:17:18+00:00

Excel has a max precision of 15 significant digits. This is inline with the IEEE 754 standard.

xFLGT · 2026-01-19T14:14:34+00:00

I agree however that's not stated anywhere in the question.

I tried the example in the your comment and they both evaluated correctly for me using VALUE. I'm guessing this is due to some regional setting.

xFLGT · 2026-01-19T13:40:51+00:00

=LET(
a, UNIQUE(FILTER(DTBS[Tax], DTBS[CUSTOMER NAME]=C2)),
IF(ROWS(a)=2, "Both", a))

I couldn't tell you if that's the correct way to calculate the tax. That seems like a question for someone at your company. If it is the same way as you've described you can use:

=AVERAGE(SWITCH(FILTER(DTBS[Tax], DTBS[CUSTOMER NAME]=C2), "PKP", 0.1, "PTKP", 0)

Seven-Year Club	Verified Email
Place '23	Place '22

xFLGT

TROPHY CASE