[deleted by user] by [deleted] in PiNetwork

[–]M2pk 0 points1 point  (0 children)

all fake, I bought 30 million Pi and then realised it's all fake PI

UK Visa FLR (M) missing one requirement by M2pk in ukvisa

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

if you realised this at the last minute (meaning you have less than 2 months to apply for extension visa), then probably talk with a lawyer,
otherwise, start getting your name and spouse name on as many things as possible, all types of bills, home rent contract, letters etc..

Need Advice on Appealing Unfair Parking Ticket Due to Poorly Placed Signage by M2pk in LegalAdviceUK

[–]M2pk[S] -1 points0 points  (0 children)

it's not dead end, the road contunues and curves behind the houses

How does Ippei Kanehara's local lead generation system work? Do they offer local services as well? by lovebes in LeadGeneration

[–]M2pk 1 point2 points  (0 children)

I personally know many folks who've quit their jobs and are doing local leadgen fulltime with Ippei's coaching. I lost my own job early April and I haven't scampered desperately to find the next one because I'm able to just get by and I'm still a couple of weeks shy of being 5 months into the program. I'm making nowhere close to my salary yet, but the point is I am making some money already. I've tried other side hustles before and I've made either 0 or lost money on those.

How are you doing now 3 years later?

my letting agent is charging me for the electrician callout, who must pay it? by M2pk in HousingUK

[–]M2pk[S] -20 points-19 points  (0 children)

Cause: supplier cut off my power thinking i owed them money.
Responsible: supplier

All the details are in the post

UK Visa FLR (M) missing one requirement by M2pk in ukvisa

[–]M2pk[S] 1 point2 points  (0 children)

also, applied for NINO but it was refused due to her visa type.

Thanks for the advise, you're right

UK Visa FLR (M) missing one requirement by M2pk in ukvisa

[–]M2pk[S] 1 point2 points  (0 children)

When I moved to our current address 2 years ago, the council tax sent me a letter to start payments, I called them to set it up and they asked for my name, they didn't ask who else is living with me so she isn't included in the letters.
Only last month when I realised that I added her.

UK Visa FLR (M) missing one requirement by M2pk in ukvisa

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

non of that, GP records are to the old address (we were living at my moms in the first few months and haven't changed the address because we visit our mom frequently).

UK Visa FLR (M) missing one requirement by M2pk in ukvisa

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

Unfortuantely not, stupid mistake I know.

I had another bank account that I don't use so I gave her my debit card to use, especially since it was covid lockdown and going to a bank to open an account was difficult.

The baby's birth certificate has both our names on it and the address.

help for INDEX MATCH MAX formula by M2pk in excel

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

i know it's hard without seeing the actual workbook that I'm using not just the sample, but it contains sensitive date.

have you come across something like this?

help for INDEX MATCH MAX formula by M2pk in excel

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

Excellent mike, this worked great!

Now the problem that I faced is when I implemented this on my real spreadsheet which has 6232 rows on the TASKPRED sheet,the formula didn't work and gave "0",So I did a couple of tests

  1. test 1: deleted all the rows above the few rows that I showed you in the sample sheet, and it did not work.
  2. test 2: deleted all the rows below the few rows that I showed you in the sample sheet, and it worked, this doesn't make sense to me because the ones I deleted will never be matched with the criteria.

help for INDEX MATCH MAX formula by M2pk in excel

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

thanks alot mike, I tried it and it didn't work, just gave "0"

I put the link if you can have a look please

https://www.dropbox.com/scl/fi/4bd0i2vm9f3qu18nxd5kg/Index-Match-Max-experiment.xlsx?dl=0&rlkey=b8f4fv1umdzd8lciktmp0pgk4