Search results

In cell G2: =LET( Table_Range, $A$2:$C$10, Header_Range, $A$1:$C$1, Text_String, $F2, Build_Lookup_Table, HSTACK( TOCOL(Table_Range,3,TRUE), TOCOL(IF(NOT(ISBLANK(Table_Range)),Header_Range,NA()),3,TRUE))...

In the name manager add the following custom function: Name: REPLACEBETWEENCHAR Formula: =LAMBDA( Str, Char, ReplaceWith, LET( CharArray, DROP( REDUCE( ""...

Who here is a Tuesdays, Wednesdays And Thursdays worker?

This is correct for the odds of drawing any specific number (e.g. 6). But if the question is "What are the odds of getting the same number three weeks in a row?" It's just: (1/18) * (1/17) = 1/306

+1

Enjoyed that :cool:

Rather than using VBA you can use a LAMBDA function in the name manager: Go to name manager > Create a new name called "Occurrences" > Paste the following in 'Refers to:' =LAMBDA(Date_Range, Code_Range, Code, LET( RemoveBlanks, IF(Code_Range = "", ":", Code_Range)...

I've just tried this with my One Plus 7 Pro, lined up a reflection in the screen and pressed down and the screen depressess in the same way as yours. Had this phone 3 years and never noticed it before.

How is it? How are you finding the noise level?

I absolutely loved S1 but thought they had cancelled it. Looking forward to S2

It's not pretty but try this Yellow rule: =not(isblank( XLOOKUP(B3,$B$10:$B$29,$C$10:$C$29, XLOOKUP(B3,$I$10:$I$29,$J$10:$J$29, XLOOKUP(B3,$P$10:$P$29,$Q$10:$Q$29, XLOOKUP(B3,$W$10:$W$29,$X$10:$X$29,":")))))) Green rule: =not(isblank( XLOOKUP(B3,$B$10:$B$29,$D$10:$D$29...

No headphones :eek:

More 'desk rave' material :D Probably my favourite hardstyle track: Love it when it kicks in @1.30: Crazy video:

If you're using the latest version of Excel then try this: =FILTER($A$2:$D$15,$A$2:$A$15="Jane") (I'm writing this on my phone so I've not checked it)

I've been enjoying some hardstyle this year, in particular tracks you could sneak into the end of a trance set

Manually type the result you need in a spare column for the first two or three rows, then press Ctrl+E. https://excelnotes.com/ctrle/

I used to love Deadmau5 back in the day - Not Exactly, Faxing Berlin, BSOD, etc. I've not heard anything of his for a while, but the track you posted sounds reminds me of the artist Michael Cassette. E.g.

Found it: Love it when it kicks in at ~2:10

Can anyone help with a track ID? It's the opening track in here: https://soundcloud.com/liz-wigley/liz-wigley-elements-glasgow-guest-mix-ep04

And if you want a dynamic solution (requires the latest version of Excel), try this formula: =FILTER(A1:Z100,NOT(ISBLANK(A1:A100))) Where A1:Z100 should be the range of your table and A1:A100 is the column with the blanks.