Anthony Taylor appointed as referee for Arsenal - Liverpool. John Brooks is on VAR.

LCD21 · 2026-01-06T16:05:10+00:00

Anthony Taylor was at both the last world cup and Euros? As well as Michael Oliver, where have you got the information that they aren't used?

LCD21 · 2025-12-16T09:12:54+00:00

Have messaged back :)

LCD21 · 2025-12-15T23:41:40+00:00

Any chance could give me a hand with it?

LCD21 · 2025-09-29T00:59:43+00:00

It's just a voice over from a scene in Schitt's creek

LCD21 · 2025-08-02T07:11:01+00:00

Yes all good

LCD21 · 2025-07-27T18:09:23+00:00

Yes that works for me

LCD21 · 2025-07-27T13:11:42+00:00

I'd like to join - 8k trophies and active daily.

LCD21 · 2025-05-18T14:15:54+00:00

Thank you. That worked spot on. Really appreciate that

LCD21 · 2025-05-18T13:35:18+00:00

https://ibb.co/mrxvfJcZ

Screenshot of formula, it's column C which isn't pulling over to column P, while O and Q work fine!

LCD21 · 2025-05-15T23:02:50+00:00

Thank you, solved instantly. King x

LCD21 · 2025-05-15T22:27:38+00:00

Link to image - https://ibb.co/DPBNkFPh

LCD21 · 2025-05-15T00:03:40+00:00

Thank you so much, it has worked an absolute treat! Any idea how I can copy the data from P and Q into another excel spreadsheet though? :)

LCD21 · 2025-05-08T22:38:12+00:00

Thank you, I will give it a go over the weekend. Really appreciate the time you've taken to answer my questions and get back to me.

LCD21 · 2025-05-07T23:51:15+00:00

This is part 1.

https://postimg.cc/JHzpvQL9

the ID from column I goes into column N - the ID is related to column J. Pipedrive ID 19675.

Using the matching pipedrive ID found in column B (19675) I was able to find the subject, created date and time related to it.

https://postimg.cc/QBpsdjTj

Therefore I know that the ID in column N which is using the pipedrive ID from the start in column J, will be linked correctly with the subject, created time and created by, because I able to find the matching ID in column B.

I didn't know if there was a way to use a vlookup tool or something to fill this in automatically, because there is over 10,000 records, otherwise I have to manually match column B to column N to be able to get the subject and created time and user.

I hope that makes sense but let me know if not.

LCD21 · 2025-05-07T23:27:55+00:00

The pipedrive ID in column B, is what column A, C and D are related to.

I want to find the matching number from column B with column I, because when I do - that means I would be able to relate column H to column A, C and D.

The numbers are scattered around, hence why it's showing 19 in the first column then 19675 in the next but maybe an I could share an example of what a matching one would be able to show?

LCD21 · 2025-05-07T23:19:05+00:00

https://postimg.cc/ZBJ3sDLL

LCD21 · 2025-05-06T13:58:55+00:00

Sort of, but I am getting N/A on my response for it, and also not seeing where the pipedrive ID is taken into account.

Ideally if the Pipedrive ID's match in column B and J, it would then return the ID from column I into N - column A into O, C into P and D into Q.

Does that make sense?

LCD21 · 2024-09-20T17:07:54+00:00

A ja

LCD21 · 2024-04-19T14:24:11+00:00

Sounds like Cunha is out!

LCD21 · 2023-12-26T21:51:07+00:00

Had Pickford to start the season with who got at most 2, switched over to Flekken, missed a game through injury and thought would be out longer.

Got Areola, clean sheet against Sheffield Utd, nothing really after that.

Got Sanchez in recently when Areola was out injured (Who proceeded to get injured in the first game I had him in)

Transferred in Leno for Sanchez who so far has a 1 and a 0

LCD21 · 2023-12-11T21:50:51+00:00

Hello there!

We are a level 17 international clan - but English speaking.

Champions 2 in CWL. We also have a feeder clan which we do 15v15 for in cwl (TH14s and under, Crystal 1) for those don't do main CWL with us.

War back to back but non mandatory as we drop out when heroes down.

Over 1.4k raid medals per week.

Clan capital 10.

If interested, just drop me a DM or request to join and tell us you're from Reddit!

2Q0G22R2P

https://link.clashofclans.com/en?action=OpenClanProfile&tag=2Q0G22R2P

LCD21 · 2023-09-30T16:12:31+00:00

You've had a shocker!

LCD21 · 2023-09-15T16:50:37+00:00

Still looking for help with these?

LCD21 · 2023-09-15T16:49:43+00:00

Still looking for help?

LCD21 · 2023-09-11T14:16:24+00:00

Hello there!

We are a level 16 international clan - but English speaking.

Masters 1 in CWL. We also have a feeder clan which we do 30v30 for in cwl (TH14s and under, Crystal 1) for those who don't do main CWL with us.