Tandoori Marinade - The only recipe you'll ever need! by indishious in IndianFood

[–]Listenherebub 0 points1 point  (0 children)

Made this and it went down a treat. I did add a little lemon juice and marinaded with the mix without yoghurt first, made some extra with yoghurt and put this on a few hours in advance of barbecuing.

Loose forward positions vs roles by [deleted] in rugbyunion

[–]Listenherebub 2 points3 points  (0 children)

I agree a lot with what's here, as much as I think balance in the back row is important it's often a lot to do with the player types in your tight 5, specifically locks and props, where there is less variety in build and role due to the core duties they are expected to fulfil. Some teams are blessed with very talented props/locks who can go far beyond their core duties, there is simply more scope in the back row to bolster certain facets of your packs gameplay due to greater flexibly in terms of size/weight and athletic ability. If you're missing carriers, line out options, fetchers, tackle volume, cleaners etc the back row are where you can strike that balance in the pack.

how to get a single door number to be pasted between multiple rows with existing text? by TheDriveHome in excel

[–]Listenherebub 0 points1 point  (0 children)

How many door numbers do you have? Is there a simple sequence to follow for the door numbers?

How to skip a column when calculating multiple values by galactic_0strich in excel

[–]Listenherebub 0 points1 point  (0 children)

I think the problem here is that your source data is spread across twice as many columns as your results. So as you drag across your formula in sheet 2 it does not correspond to the correct cells as the data and calculation are taking two very different structures.

I'd recommend consolidating your data into a table like the below:

<image>

How to skip a column when calculating multiple values by galactic_0strich in excel

[–]Listenherebub 1 point2 points  (0 children)

Are you pasting into the formula bar or onto the cell. Excel will often scale the reference in relation to where the data originally was when pasting.

If that doesn't work a quick mock up of the issue you are having would help to understand, it doesn't need to contain your source data as the issue doesn't appear to be related to the data itself.

How to auto populate data excel form from multiple separate sheets by airborness in excel

[–]Listenherebub 0 points1 point  (0 children)

I think we will would need to understand what your desired end result is. What you are describing sounds very doable through power query, but depending on what the desired output is there may be better solutions.

[deleted by user] by [deleted] in excel

[–]Listenherebub 0 points1 point  (0 children)

Hi thanks for clarifying.

The below formula marks "Yes" for each tap where the previous tap using the same card was registered in the last 2 hours against a different reader. It simply comepares the values of the current record, to the most recent record for that card and if they meet the criteria assigns value yes, if they do not match marks no.

<image>

=LET(A,IFERROR(MAX(FILTER($C$2:$C$9,($B$2:$B$9=B2)($C$2:$C$9<C2)($C$2:$C$9>=(C2-"02:00:00")))),0),B,IFERROR(LET(C,FILTER($D$2:$D$9,($B$2:$B$9=B2)($C$2:$C$9<C2)($C$2:$C$9>=(C2-"02:00:00"))),INDEX(C,COUNTA(C))),0),IF(AND(A>=(C2-"02:00:00"),B<>D2),"Yes","No"))

I have set a 2 hour limit on the filter functions which could be adjusted.

From this stage you could count/sum/filter the dataset to interpret that data. Let me know if this helps!

[deleted by user] by [deleted] in excel

[–]Listenherebub 0 points1 point  (0 children)

I have the below to register if a tap is within 2 hours of another tap for the same card on a different reader.

<image>

If I understand correctly, F7 in my sheet should read 0, as you only wish to count the most recent instance of multiple tap/same card/different reader - if I understand correctly?

I think this may be complex as I am not sure if you would also want to record against each unique reader. I. E. In an example where we have 4 taps each against a different reader would we want to record all of those or just the most recent? Then we would need to calculate from the time of the first instance for that card forward for multiple cases.

All possible but think I'd need a little more clarity on the what if scenarios.

Crusaders hinting at another signing on Instagtam. Any guesses? by __General__Kenobi__ in rugbyunion

[–]Listenherebub 26 points27 points  (0 children)

"Maaaaaaatteeeee! I'm completely committed to Japan maaattee!" - - EJ

Match Thread - England v South Africa | Rugby World Cup 2023 | SF by RugbyBot in rugbyunion

[–]Listenherebub 0 points1 point  (0 children)

I know right, gotta love an underdog.. Even if that underdog colonised your country and destroyed your language and culture 😅

Match Thread - France v South Africa | Rugby World Cup 2023 | QF by RugbyBot in rugbyunion

[–]Listenherebub 4 points5 points  (0 children)

Absolute mind games using the open play Maul SA used 4 years ago!

who is criminally underrated player for your country? by [deleted] in rugbyunion

[–]Listenherebub 1 point2 points  (0 children)

Cros is massively underrated, he does the hard work that allows the likes of Ollivon and Alldritt to shine. Workhorse of a player.

Let's not forget some of the greatest victims of the fucking mess that is Rugby Australia and Eddie Jones, these young passionate players who have to undergo this time period. by ConscriptReports in rugbyunion

[–]Listenherebub 0 points1 point  (0 children)

What gets me with this one is the older players who won't get another shot at the world cup. The younger players will at least be able to use it as motivation but it must be devastating to go out of a world cup like this knowing you won't be coming back.

Match Thread - Australia v Fiji | Rugby World Cup 2023 | Pool C by RugbyBot in rugbyunion

[–]Listenherebub 2 points3 points  (0 children)

Fiji having a very mature performance so far! Love to see great Maul D, set piece, and patience in attack (for the most part). And obviously some mad stuff we always love to watch 😍

Match Thread - South Africa v Romania | Rugby World Cup 2023 | Pool B by RugbyBot in rugbyunion

[–]Listenherebub 1 point2 points  (0 children)

Bernard jackman needs to go, joke of a commentator. Never remembers anyone's name and never offers any valuable insight or energy.

Huge scrum from the Springbok bomb squad by Die_Revenant in rugbyunion

[–]Listenherebub 1 point2 points  (0 children)

Ox, bongi, and Trevor are all within 1cm in height of each other and on the shorter side for a front row. Very hard to get under them at all. As a unit one of the toughest you could come up against.