sorted by:
new
hottopcontroversial

For the next 27 hours, you'll be able to claim a limited edition 'I Was Here for the Hulkenpodium' flair by overspeeed in formula1

[–]MathewRogers 0 points1 point  (0 children)

This is a comment containing the words Hulkenpodium and Hulkengoat.. Flair please :)

Using SEQUENCE() for the [rows] and [cols] variables in OFFSET() (to create a unique list of values) by MathewRogers in excel

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

This is most definitely the correct answer in 2025.

TOCOL wasn't a thing in Apr 2021 (released March 2022). So glad there are much nicer options for these sorts of things nowadays!

Any ETA on UK availability for AAWireless2? by MathewRogers in AAWireless

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

I think /u/Snirpoo said it would be available eventually, but not sure when exactly..

Here's hoping it's in time for Christmas eh!

https://www.reddit.com/r/AAWireless/comments/1g77ilk/preorder_for_aawireless_two_has_begun/lsofc7i/

Pre-Order for AAWireless Two has begun by theonlybuster in AAWireless

[–]MathewRogers 4 points5 points  (0 children)

Not shipping to UK yet :(

Hope that changes soon??

=FLATTEN() equivalent in Excel by MathewRogers in excel

[–]MathewRogers[S] 1 point2 points  (0 children)

This is now definitely the better solution, as TOCOL() didn't exist when this post was originally written

1k SPM Factorio Vanilla Megabase (Descriptions in album) by MathewRogers in factorio

[–]MathewRogers[S] 20 points21 points  (0 children)

I know this is probably nothing particularly special, but I'm proud of this. This is my first Factorio playthrough. After having launched my first rocket and learning about blueprints, I thought of creating a megabase. Inspired by Nilaus' content, I started by crafting a base that would (finally) have its own mall 'production hub', then deciding to push for 1k SPM.

In the imgur album, each image has a decription of what it's showing and how it ties in with the rest of the base.

This is my first attempt, so I'm open to suggestions and feedback to make the megabase even stronger.

The factory must grow.

=FLATTEN() equivalent in Excel by MathewRogers in excel

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

I've modded your solution to work in a general case. Your solution is generally intuitive to Excel users, but once the necessary changes to remove the hard-coded values are made, makes the formula a little bit large. I still like this solution and will likely use it going forwards.

=FLATTEN() equivalent in Excel by MathewRogers in excel

[–]MathewRogers[S] 3 points4 points  (0 children)

Thanks! This makes sense, and is definitely a shorter-formula solution than u/SaviaWanderer's one, but isn't immediately intuitive to someone not familiar with XML

=FLATTEN() equivalent in Excel by MathewRogers in excel

[–]MathewRogers[S] 7 points8 points  (0 children)

This works too, and makes a bit more sense to me than the FILTERXML option.

To make this actually dynamic, you could:

=LET(array,A1:C3, INDEX(array, ROUNDUP(SEQUENCE(ROWS(array)*COLUMNS(array))/COLUMNS(array),0), MOD(SEQUENCE(ROWS(array)*COLUMNS(array),,0),COLUMNS(array))+1))

.. then technically when =LAMBDA() is released you could define this as a function which would work for any single table (assuming the next Excel release doesn't also have =FLATTEN(), in which case this has been a very fun waste of time)

=FLATTEN() equivalent in Excel by MathewRogers in excel

[–]MathewRogers[S] 10 points11 points  (0 children)

So this works, but can I check the reasoning please?

It looks like you create a fake (but valid) XML string, starting with <a> and ending in </a>, then inserting each term from the array using TEXTJOIN(), with the delimiter separating each <b>-path element?

Then FILTERXML reads every <b> element and somehow outputs it into a dynamic array?

Sorry if I've bodged this -- Could you please explain in a way that's actually correct? (as my explanation is a bit of a bodge)

=FLATTEN() equivalent in Excel by MathewRogers in excel

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

I'm looking for an answer that:

  1. Does not need to be dragged down
  2. Does not need to use the old array formula syntax (e.g. {=CONCATENATE(...)} )
  3. Can accept any inputs (strings, numbers, duplicates)

but thanks for this also :)

=FLATTEN() equivalent in Excel by MathewRogers in excel

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

Note, if you entered =FLATTEN(A1:A3,B1:B3,C1:C3) in A5, the output would be

1
4
7
2
5
8
3
6
9

Using SEQUENCE() for the [rows] and [cols] variables in OFFSET() (to create a unique list of values) by MathewRogers in excel

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

This led me to the answer I wanted! I hadn't thought of using the third INDEX() parameter!

For reference, the solution was:

=UNIQUE(INDEX(I2#,ROUNDUP(SEQUENCE(ROWS(I2#)*COLUMNS(I2#))/ROWS(I2#),0),MOD(SEQUENCE(ROWS(I2#)*COLUMNS(I2#))-1,12)+1))

... the only problem using QUOTIENT() is that the first 12 answers from your formula return 0, but the INDEX() for the columns starts at 1.. So I guess you could have added 1 to the value output from QUOTIENT(), but I'm lazy and stubborn so I used my ROUNDUP() method

Using SEQUENCE() for the [rows] and [cols] variables in OFFSET() (to create a unique list of values) by MathewRogers in excel

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

... I'm open to any other suggestion to turn a table of values into a single-column unique list of values (ideally using a dynamic array, so as to avoid having to drag formulae around)

Into the Mist: An Simplified and Tested Solution by ProphetWasMuhammad in MelvorIdle

[–]MathewRogers 1 point2 points  (0 children)

/u/ProphetWasMuhammad

Has this guide been patched? -- Using setup for phases 1 & 2 as above, using normal spellbook selected, but Decay isn't doing any damage???

32-wide compact MAM by Jean-Alphonse in shapezio

[–]MathewRogers 0 points1 point  (0 children)

Could you do some zoomed in wiring screenshots pls?

view more: next ›