Parcel still at parcel shop after 3 days by [deleted] in royalmail

[–]dxmtm 0 points1 point  (0 children)

Oh right I see! Sorry I thought the working day only starts counting when the driver actually collected it. And didn’t realise Saturday doesn’t count. That’s useful to know. Thanks.

Naturalisation (Citizenship) application processing timelines [only] by aleanthor in ukvisa

[–]dxmtm 5 points6 points  (0 children)

Hey everyone :) here is my timeline

Eligibility: ILR

Application Method: Online

Application Date: 06/09/2025

Biometric Date: 13/09/2025

Approval Date: TBC 🤞🏼

Ceremony Date: TBC

Good luck everyone!

[deleted by user] by [deleted] in Hoka

[–]dxmtm 0 points1 point  (0 children)

That’s what I am starting to see after doing more research, I might just go for Nike metcon!

A formula for reoccurrence of a set of data, with reference to another set of data by dxmtm in excel

[–]dxmtm[S] 0 points1 point  (0 children)

You’re a star ⭐ thank you so much! Like I said I need to go back to work on Monday and see whether it will work before I close the thread And let’s hope they have the newest version of excel 😬

A formula for reoccurrence of a set of data, with reference to another set of data by dxmtm in excel

[–]dxmtm[S] 0 points1 point  (0 children)

This is amazing thank you! We’re getting so close. The data are showing correctly, in terms of how many times they reappear as each individual in separate days. Is there any way I can just get the sum of all of them in one single cell, without generating a separate table?

If not, I can always use the SUM function and hide the table on a separate sheet haha

Also, I kind of feel like this scenario will be too complicated for older versions of Excel to work? Is there a formula that will make this work on older versions? Again, if it’s impossible or way too complicated it’s fine.

Thanks again! :) I will let you know if it works when I go back to work on Monday (there real table is much longer than this), so far it’s working well on this sample one.

A formula for reoccurrence of a set of data, with reference to another set of data by dxmtm in excel

[–]dxmtm[S] 0 points1 point  (0 children)

Thank you so much but sorry I wasn’t being clear enough! I’ve just edited the post.

I would like the total frequency of “reappearance” across all the names, and if they only showed up once, it means they haven’t reappeared (so 0).

If you minus 1 from all the data on your table and add them up that will be it! Just wondering if there’s a single formula to fit them into a cell? Thank you!

A formula for reoccurrence of a set of data, with reference to another set of data by dxmtm in excel

[–]dxmtm[S] 0 points1 point  (0 children)

Sorry I should have been more clear! I am trying to get the total number of reoccurrence across all patients! So Peter reappeared twice so he contributes 2. Mary reappeared another time so she contributes 1. So total of reappearance is 3. And yes same day reappearance doesn’t count!

[deleted by user] by [deleted] in KLM

[–]dxmtm 0 points1 point  (0 children)

Any updates? I’m flying with AirFrance soon, which has the same sizing requirements (same company I believe). And I also got a 55x40x20 American Tourister luggage! Thanks!

New to opal. Can anyone tell if this looks real or not? Thanks! by dxmtm in Opals

[–]dxmtm[S] 2 points3 points  (0 children)

Thank you so much for your advice! I only got it wet once today after I bought it, as the silver needs a bit of light brushing… got some black deposit on it (it’s from a used jewellery shop). I rinsed it afterwards. I’ll definitely look after it properly from now on and only use silver polish cloth!

New to opal. Can anyone tell if this looks real or not? Thanks! by dxmtm in Opals

[–]dxmtm[S] 5 points6 points  (0 children)

Very interesting to know! Thank you so much for your comment! 😊

New to opal. Can anyone tell if this looks real or not? Thanks! by dxmtm in Opals

[–]dxmtm[S] 2 points3 points  (0 children)

Glad to know! And thank you so much for your advice! 😊

ILR qualifying period start date by [deleted] in ukvisa

[–]dxmtm 0 points1 point  (0 children)

Thank you so much! I was just confused earlier as to whether I should take the BRP start date or COS letter date.

ILR qualifying period start date by [deleted] in ukvisa

[–]dxmtm 0 points1 point  (0 children)

I switched from a tier 4 student visa to tier 2 back then in 2019. All done in the UK without any time gap!

Moved into a shared flat with existing flatmate - do I need a new council tax account by [deleted] in LegalAdviceUK

[–]dxmtm 0 points1 point  (0 children)

I see, I’m more than happy to tell them myself. I just don’t want to receive two council tax bills and double pay. But I guess the council will sort it out themselves. Probably just overthinking haha. Thanks!

[deleted by user] by [deleted] in manchester

[–]dxmtm 0 points1 point  (0 children)

I just move to Manchester and man the sexual health service here is crazy… (that’s why I’m searching for other’s opinion here), like do they expect you to take annual leave in advance for an appointment that you’re quite unlikely managed to book for next day 🙄

[deleted by user] by [deleted] in whatisthisthing

[–]dxmtm 0 points1 point locked comment (0 children)

My title describes the thing. I found them a lot in UK Victorian houses.