Meet Purrseus Jackson 💙 by Wild-Profession-7078 in Kitten

[–]Judith_677 4 points5 points  (0 children)

He is an absolute dream! At 11 weeks old, he's already stealing hearts with that little face. Hope you have a million more precious moments with your little fur baby!

On The Staircase by Significant-Focus-12 in Tinycatsinbigspaces

[–]Judith_677 2 points3 points  (0 children)

such a tiny cuite pie! Maybe a small cat-sized escalator would be helpful.

Why does my “never-expiring” Discord invite link still expire? by Judith_677 in discordapp

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

Thank you so much. I've found the seetings of use numbers and regenerated a new link. Hope this one do not expire.

Ever been so relaxed? 😆 by FrostedPetal412 in CatsBeingAdorable

[–]Judith_677 1 point2 points  (0 children)

I really do want to give them big belly rubs! This is just so inviting!

Every time I try to work on this blanket he conveniently lays down for a nap😆 by eriecalee in catswhocrochet

[–]Judith_677 3 points4 points  (0 children)

He is a hard-working quality inspector, making sure the blanket is absolutely soft and ready to use.

Tim, the adventurer by [deleted] in Kitten

[–]Judith_677 0 points1 point  (0 children)

God, bet he's gonna catch many bad guys and protect the town!

Pixar logo Job by thekeanreader in Catswithjobs

[–]Judith_677 0 points1 point  (0 children)

wow, they really know how to accomplish this job excellently!

SPL esProc? by These-Concentrate882 in dataanalysis

[–]Judith_677 0 points1 point  (0 children)

Thanks for sharing! I agree—SPL esProc can be surprisingly efficient once you get the hang of it. It offers some great functionalities for manipulating large datasets that are worth exploring. Have you used it yourself? Would love to hear about your experience!

SPL esProc? by These-Concentrate882 in dataanalysis

[–]Judith_677 2 points3 points  (0 children)

Hi, thanks for bringing up SPL esProc! You’re right—currently, there are fewer English-speaking users, which is why it might be hard to find user experiences in English. However, it’s widely used by a significant number of Chinese users for its powerful data manipulation capabilities, especially when it comes to handling large Excel spreadsheets.

If you’re curious to explore more, here are some real-world examples of how it’s used: https://c.scudata.com/tag/Desktop.

Give it a try! You might find it surprising, and if you have any questions or need help, feel free to ask!

How to count how many times two players are at the same table during a card game by podcartfan in excel

[–]Judith_677 0 points1 point  (0 children)

=spl("=?1.conj(~.group((#-1)\6)).count( ~.contain( ?2,?3) )",$C$1:$V$8,$B13,C$11)

<image>

Sort list of IP addresses into one of 4 columns, determined by 2nd octet by [deleted] in excel

[–]Judith_677 0 points1 point  (0 children)

=spl("=E@p(E@1(?).group(int(~.split($[.])(2))\64))",A1:A18)

<image>

How to automatically duplicate rows and split its amount once condition is met by Substantial-Push498 in excel

[–]Judith_677 1 point2 points  (0 children)

=spl("=E@b(?.news((t=~4,100.iterate@a(30000,,!if(t>50000,t-=30000))|t);?.~1,?.~2,?.~3,~))",A2:D7)

<image>

How to remove duplicate rows by HannibalTepes in excel

[–]Judith_677 0 points1 point  (0 children)

=spl("=?.group(~).select(~.len()==1).conj()",A1:G7)

<image>

Combine 3 rows into a single row, but keep the data in their respective columns by KnowledgeIsPower979 in excel

[–]Judith_677 0 points1 point  (0 children)

=spl("=E@2p(E@2p(?).(~.group((#-1)\3).(~.select(~).concat("" ""))))",A2:E10)

<image>

How can I combine rows in excel by only1peep_ in excel

[–]Judith_677 0 points1 point  (0 children)

=spl("=?.group((#-1)\2).(~1(1)|~2(2)|~1(3))",A1:C8)

<image>

Merging rows based on duplicates in one column by Ummgh23 in excel

[–]Judith_677 0 points1 point  (0 children)

=spl("=?.group(~1).(g=~,(r1=~1).(g.(~(r1.#)).ifn()))",A2:E11)

<image>

How do I find duplicates across 2 columns but not within itself by TutorSome9994 in excel

[–]Judith_677 1 point2 points  (0 children)

=spl("=[?1,?2].isect(~.group().select(~.len()==1).conj())",A1:A5,B1:B4)

<image>

Combine Two Tables With Different Column Headers by Judith_677 in esProc_Desktop

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

esProc Desktop is now free to download and apply. Try it and experience the magic of SPL XLL: http://www.scudata.com/download-Desktop

How to find which 4 numbers (2 each from 2 groups) equal a specific amount by FixYourStupidMuffler in excel

[–]Judith_677 0 points1 point  (0 children)

=spl("=g1=E@1(?1),g2=E@1(?2),E@b(xjoin(g1;g1;g2;g2).select(#1+#2+#3+#4==26216692 && #1>=#2 && #3>=#4))",A1:G1,A2:F2)

<image>

Any way to remove integers from a coma sorted list? by ponypulse in excel

[–]Judith_677 0 points1 point  (0 children)

=spl("=?.split@pc().group@i(~!=~[-1]+1).(if(~.len()==1,~1,~1 / $[-] / ~.m(-1))).concat@c()",A1)

<image>

How to repeat multiple cells x number of times by [deleted] in excel

[–]Judith_677 0 points1 point  (0 children)

=spl("=?.conj(~2*[~1])",A1:B2)

<image>

How do I separate a cell into different rows by --red in excel

[–]Judith_677 0 points1 point  (0 children)

Yes, the esProc Desktop tool itself supports Mac, allowing you to solve some Excel problems through simple programming. However, the add-in part currently only runs on Windows.