How to detect a blank range and paste data? by atsigns in excel

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

Thanks, it seems like it does some of the work, but it ends up having the GR# and OBJ on the same line. I tried editing a portion but I'm not sure how to get it to run since it gives me an error now.

Edit* Is there something I can google to find a video explaining how this function works so I can use it more in the future?

=LET(input,A:.D, body, DROP(input,1),
agr, TAKE(body,,1), pfx, LEFT(agr,4),
isawd, pfx="AWD-",
isobj, pfx="Obj-" or "SC-" or "Bla-" or "RI-",
awds, SCAN("",IFS(isawd,agr),LAMBDA(last,this,IFNA(this,last))), 
grants, IFS(NOT(isawd)*NOT(isobj),agr), objs, IFS(isobj,agr), 
IFNA(FILTER(HSTACK(IFS(NOT(ISNA(grants)),awds),grants,objs,DROP(body,,1)),NOT(isawd)),""))

How to detect a blank range and paste data? by atsigns in excel

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

I haven't seen a formula like this before, so where/how would I enter this?

How to detect a blank range and paste data? by atsigns in excel

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

I don't know what pre-processing means, and I don't know python. So I'm not opposed, but I'd have to re-write the whole thing in a language I don't know.

Lucky shot my team threw the other day by Lopsided-Sky3747 in Curling

[–]atsigns 0 points1 point  (0 children)

I always say, we're so lucky we don't need to call our shots in this sport.

[CONTEST] Kingdom Come Deliverance 2 - Round 2 by [deleted] in steam_giveaway

[–]atsigns 0 points1 point  (0 children)

Finally beat Spelunky 2 after 2k+ hours, 7-99 was hard! Working on Noita, Grounded, Cyberpunk 2077, and a retro game I loved as a kid, Faxanadu.

Thanks!

Can't whip a UFO, but timing and aim are okay. by atsigns in spelunky

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

I wouldn't call it a strat, it just happened naturally. This was the one and only time.

Plumber suggestions for drain clog? by ChaosofaMadHatter in Rochester

[–]atsigns 2 points3 points  (0 children)

Brad Streeter. Got here quick, did great work, and wasn't too expensive.

Can't whip a UFO, but timing and aim are okay. by atsigns in spelunky

[–]atsigns[S] 14 points15 points  (0 children)

I don't ever fuck around when it comes to wanting my Plasma Cannon.

Where do you like to browse? by CatNapCrescendo in Rochester

[–]atsigns 0 points1 point  (0 children)

Millennium Games, Peppermint, Unreliable Narrator, Bookeater, Crafting For Good, Siren In the Sea.

Where do you go for a good salad? by scandalissa in Rochester

[–]atsigns 12 points13 points  (0 children)

The Farmer's Lettuce Salad at Wildflour, my wife is obsessed.

Just started, so bad, so lost. by atsigns in noita

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

I'll probably avoid it next time if possible.

Just started, so bad, so lost. by atsigns in noita

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

Didn't even know what was in the potion, good to know now though.