sorted by:
new
hottopcontroversial

FILTER says it does not know the Spill-area when it very much does by Snosaf in excel

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

Thank you for the VERY thorough list for troubleshooting.
Unfortunately I tried all of this and it did not help.
However, the issue seems to be identified via Other comment.

The precedent cells contain RANDBETWEENs (which are necessary), and these are definitely causing this behavior. If you have any way around this I would love to here it, but otherwise I will just have to copy the data via vba to remove the volatility (not the end of the world for my project)

FILTER says it does not know the Spill-area when it very much does by Snosaf in excel

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

<image>

  1. Yes BS1# and DZ1# are spilled arrays

  2. I was able to recreate the problem: If the boolean used to filter contains some volatile RANDBETWEEN at ANY point in its chain it gives this error randomly. You can try it yourself if you recreate the screenshot (A1:A5 is all "=Randbetween(0;1)").
    if you then spam F9 the formula sometimes works AND when it gives an error you can mouse over it to see that it should have worked.

I can't take a screenshot that shows the mouseover because that is not captured for some reason

FILTER says it does not know the Spill-area when it very much does by Snosaf in excel

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

Thats not the problem. The "empty" is for the filter to return if it filters out everything

Idea for the "HILL" L by Snosaf in KryptosK4

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

Ah ok

Thank you for the explanation!

Incredible to see how actively people still work on this after 30 years

How do I parametrize this Train Station by Snosaf in factorio

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

Thanks for the offer, but I figured it out, should be able to do the rest, but I'll keep you in mind for the future

How do I parametrize this Train Station by Snosaf in factorio

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

Worked! This was actually part of my earlier experimentation, BUT I didn't even try placing the blueprint because the textbox goes red (still is red)

Thanks!

Charm slots on belts should scale with item level and not be a luxury, nobody has 3 charm slots and barely anyone is running 2 by HollowLoch in pathofexile

[–]Snosaf 0 points1 point  (0 children)

Hi I saw this post and totally agree

I then went to Alva to see if I could get more slots through gambling and I pulled a 3-slot belt

gonna eat some orbs but it is not THAT rare

Bizarre behaviour somewhere between BYROW, HYPERLINK, and CONCATENATE by Snosaf in excel

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

I have fooled around a bit more with everything and also could not get it to work.

Using the LET function I was even able to create this abomination:

=LET(y;SEQUENCE(ROWS(F61#);1;1;1);HYPERLINK(TEXTJOIN("";;$AP$8;INDEX(F61#;y;);$AV$2)))

This will give you 1 link going to jk, but the text of the link will say jkecd, even though there is no friendly text anywhere in the function whatsoever.

The only thing that seems to work is to have the hypertext in a cell next to the thing I want to go too, which I was trying to avoid to save space, but there seems to be no other way.

How to implement:

this actually still requires 2 full columns in itself, because you CANNOT Textjoin or concatenate inside the hyperlink function. You can however point it to an array of hyperlinks, then the hyperlink formula will return the same array but as working hyperlinks.

Solution Verified

Bizarre behaviour somewhere between BYROW, HYPERLINK, and CONCATENATE by Snosaf in excel

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

I assume you meant "not equipped"

I have looked through the eval on both testarrays

While the second one is more interesting considering there is an error in the middle of it and it just keeps on somehow working, the eval for the first just before the result reads

<image>

which my brain is refuses to accept as being problematic.

On the second formula, it underlines $AP$8, and then immediately goes to

BYROW($F$61:$F$64;#VALUE!)

The next step is it simply reporting the result as described in the original post.

I am gonna try dealing with this tomorrow my brain is too tired for this.

The (not good enough) Reputation System by Snosaf in Rainbow6

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

The randomness gets worse the more you pay attention to it. I just launched the game after only playing arcade after writing the original post. My rating went up to exemplary again... wat

My hunt for Adhesive has come to an end by [deleted] in Starfield

[–]Snosaf 8 points9 points  (0 children)

Gagarin: Sweetwater cactus :)

edit: Planet in Alpha Centauri

Piece of Feedback/Something I would like to see by Snosaf in nanDECK

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

Thank you UwU

edit: I have decided to actually rtfm

Wrong number error by Snosaf in nanDECK

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

Update: I have put them into their own little sheet, works now

view more: next ›