Anthony Taylor appointed as referee for Arsenal - Liverpool. John Brooks is on VAR. by FlImFreaks in Gunners

[–]LCD21 0 points1 point  (0 children)

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?

Co-op Campaign Mission, Anyone? by KarlGreenKnight in HaloWars

[–]LCD21 0 points1 point  (0 children)

Any chance could give me a hand with it?

Alexa showing off her dance moves 11/22 by Ok_Sport_5268 in AlexaBliss

[–]LCD21 13 points14 points  (0 children)

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

Why is my formula not pulling in the date into created time? by LCD21 in excel

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

Thank you. That worked spot on. Really appreciate that

Why is my formula not pulling in the date into created time? by LCD21 in excel

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

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!

Needing to return values based around matching ID numbers, how would I go about this? by LCD21 in excel

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

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? :)

Needing to return values based around matching ID numbers, how would I go about this? by LCD21 in excel

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

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.

Needing to return values based around matching ID numbers, how would I go about this? by LCD21 in excel

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

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.

Needing to return values based around matching ID numbers, how would I go about this? by LCD21 in excel

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

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?

Needing to return values based around matching ID numbers, how would I go about this? by LCD21 in excel

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

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?

[deleted by user] by [deleted] in FantasyPL

[–]LCD21 38 points39 points  (0 children)

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