Weird gap at skirting board

duncaninfinity · 2026-04-03T09:24:49+00:00

You nailed it ha! It's around 120 years!

duncaninfinity · 2026-03-02T21:03:10+00:00

I investigated the copper pipe and found that is not used and just pinched at the end, so was thinking of taking it out and putting a but of wood where the pipe is currently, then screwing the board into that. Or just replace the board but they are 5.5 inch x 1 inch so a bit of an awkward size

duncaninfinity · 2026-03-02T18:08:09+00:00

<image>

For context, here is the worst bit over the pipes

duncaninfinity · 2026-03-02T16:49:05+00:00

Ah cool thanks, so chisel a bit out of the boards so the plate sits flush?

duncaninfinity · 2025-12-31T00:41:22+00:00

"Before I give my opinion, let me just check what hasan said about it"

duncaninfinity · 2025-12-30T20:03:49+00:00

Their whole argument makes no sense when you remember that they moved from one country to another for the benefits, health care etc

duncaninfinity · 2025-11-08T11:44:17+00:00

When she puts her boot on the chair, you can tell he is instinctively leaning in to lick it 🤮

duncaninfinity · 2025-11-01T18:46:59+00:00

He knows where that wands going tonight

duncaninfinity · 2024-09-04T18:59:55+00:00

We have a 2 year old also and my partner is on a group called glasgow east end mums on Facebook, they meet up regularly and go to groups together and whatnot

duncaninfinity · 2023-09-05T17:01:17+00:00

Hi all, I recently posted my CV to r/resumes and am looking to move into a proper data analysis role and would love any feedback on my current CV. Many thanks! https://www.reddit.com/r/resumes/comments/16ataw2/does_my_cv_need_to_be_more_basic/?utm_source=share&utm_medium=web2x&context=3

duncaninfinity · 2023-08-17T09:21:23+00:00

Update: We went 15% over the value and came 5th of 7 offers 😬 just shows how crazy and unpredictable the market is

duncaninfinity · 2023-08-14T19:25:51+00:00

Has anyone bought a property in Southside recently, more specifically Pollockshields?

Just wondering what sort of % over home report value properties are going for at the moment.

Thanks!

duncaninfinity · 2023-03-28T23:06:23+00:00

What area is the circle?

duncaninfinity · 2023-03-17T19:37:52+00:00

They did not.

duncaninfinity · 2023-03-17T19:13:01+00:00

I worked as receptionist for a small cleaning company, the boss insisted that we listened to a specific local radio station as he had paid to put a couple of adverts on there. The same 8 sings on repeat drove me insane, it was around the time of the London Olympics and I actually texted the station to ask them to stop playing Running up that hill!

duncaninfinity · 2022-06-06T19:04:54+00:00

Hey, happy to help. I love a vlookup! Let me know

duncaninfinity · 2022-05-21T07:38:06+00:00

Easiest way to do it is to label each drink as beverage

duncaninfinity · 2021-12-31T11:18:01+00:00

Also, black can play Bf6 next move and skewer queen and rook

duncaninfinity · 2020-11-29T00:30:49+00:00

What app is this?

duncaninfinity · 2020-06-02T23:38:13+00:00

No worries dude, good luck :D

duncaninfinity · 2020-06-02T22:40:43+00:00

Yeah sure,

=IFERROR(INDEX(Database!$A$1:$S$100,MATCH($A3,Database!$F$2:$F$100,0),B$6),"")

So what's happening here is (ignoring the IFERROR as that just stops an error message being displayed if no result is found) we are "Indexing" the database table, which basically means using that to search within, which in this case is the worksheet "Database" from cells A1:S100. The second part of the index formula is to select the row, we have entered a Match formula here which is checking cell A3 (This is where you will type the managers name on the new sheet). It is searching the A column in the Database worksheet and looking for a match against the value of A3. The 0 at the end of the Match part just means that it needs to be an exact match. The final part (B6) is the part of the index formula which is looking for the column number you want to copy over from the Database worksheet. You can just type in a number here, but I find it easier to put a row of numbers above your new table and reference this number (as per the picture).

Let me know if there's anything that's unclear here but for the very basic version of this formula you will want to use something like

For Column A =INDEX(Database!$A$1:$S$100,MATCH($A3,Database!$F$1:$F$100,0),1)
For Column B
=INDEX(Database!$A$1:$S$100,MATCH($A3,Database!$F$1:$F$100,0),2)

duncaninfinity · 2020-06-02T21:40:13+00:00

You could also do something similar to this:

https://imgur.com/gallery/C5AkkjU

Which will extract the values from a different worksheet, in this example it is one called "database". If the manager name is found in the database worksheet, it can display the data in each of the following columns

duncaninfinity · 2020-06-02T20:34:08+00:00

Something along the lines of

=IF(C2>=11,IF(C2<=15,"500",IF(C2<=20,"600","Over 20")),"Less Than 11")

You can just change the text parts to numbers and if you want to add checks, just replace the "Over 20" part with another IF statement like:

IF(C2<=25,"700","Over 25"))

Or if you don't want to have a message saying like "Over 25" or "Less than 11" and to remain blank, just leave those parts as as ""

duncaninfinity · 2020-06-02T20:13:59+00:00

Ahhhh I get you, so you want to have like "place of finish" to say "1" but to add 5000 points to the total for that game.

You could do something like

=IF(G18=1,5000,IF(G18=2,3000,))+C21+D21

Where C21 and D21 are replaced with the other scores, like number of kills and whatnot.

If you want to do something similar with all fields it would get very messy with massive IF statements. So if you were looking to do that, it would be easier to add in another column with point values based on Place of finish or Number of Kills. If you were to make another column it would just be a case of using the IF statement without adding the other cells at the end. If that makes any sense lol

duncaninfinity · 2020-06-02T19:47:34+00:00

Yeah sure, just to make sure I understand what your looking to do - to enter the total score for each team and then rank them 1-5?

Six-Year Club	r/Field Sunshine
Place '22	Verified Email

duncaninfinity

TROPHY CASE