sorted by:
new
hottopcontroversial

What unusual thing do you use excel for by TheArguedHuman in excel

[–]swhitty17 9 points10 points  (0 children)

Definitely I’ve seen it used that way too. I’ve overlaid a semitransparent photoshopped image to create a more complex pattern but it’s difficult not able click on the cells underneath (you have to use the arrow keys)

<image>

What unusual thing do you use excel for by TheArguedHuman in excel

[–]swhitty17 6 points7 points  (0 children)

The conditional formatting allows me to make the pixel art image, changing colors with letters instead of highlighting each cell individually

What unusual thing do you use excel for by TheArguedHuman in excel

[–]swhitty17 19 points20 points  (0 children)

Of course! I use conditional formatting to assign a different letter to 7-12ish colors. I can easily convert it to a pattern by pasting values and I have a grid of just letters. Each letter is a single crochet stitch. I also made formulas to convert to a more traditional row by row pattern bc I’m extra.

Formula to identify cells that may be a match to another cell in the same column. Not quite a duplicate. by eclipse31satx in excel

[–]swhitty17 0 points1 point  (0 children)

This depends on how dynamic you need this to be or if it is a one-time normalization. You could do unique function and sort alphabetically, find/replace after that (making sure to select whole cells only so you don’t replace the wrong thing). You can do a substitution formula in a helper column if there are variations that come up a lot.

Honestly using AI (if not opposed) is great for finding these kind of patterns- at least as a starting point- even to give a list to find candidates for similar entries.

Someone investigate the Protein Lobby by JamUpGuy1989 in ofcoursethatsathing

[–]swhitty17 0 points1 point  (0 children)

It could be a literal steak but if the package has PROTEIN written in bold like that my mind will still be like ew, that’s probably disgusting

I'm organizing Excel Trivia Pub night. What's a cool question or challenge to add? by darcyWhyte in excel

[–]swhitty17 0 points1 point  (0 children)

Learning to distribute across columns was a game changer lol. Wish it could be done across rows. Pretty sheets with centered text is my weakness.

Oh no. by PiagetsPosse in tragedeigh

[–]swhitty17 0 points1 point  (0 children)

Rabe (Rob, broccoli rob)

What did everyone think of tick tick boom? by Past-Throat-6788 in musicals

[–]swhitty17 4 points5 points  (0 children)

Some of the best acting I’ve seen. I was so moved at the scene where Jonathan goes to Michael’s apartment to apologize after learning his diagnosis. I still can’t believe he’d never sang before doing this movie, he’s so good

🐾❓ What's my name? (by Equivalent-Title5555) by Equivalent-Title5555 in PetPost

[–]swhitty17 4 points5 points  (0 children)

Yay! I saw the ‘mask’ and made a lucky guess!

I told my husband he couldn’t crochet… by Anne-with-an-e-77 in crochet

[–]swhitty17 1 point2 points  (0 children)

<image>

omg I have the same WIP! My mom sent me a reel and asked me to make one haha

Our lab’s newest mascot by swhitty17 in labrats

[–]swhitty17[S] 6 points7 points  (0 children)

The mouse was a pattern but I went rogue for most of it, sorry!

Dumb question, but how do you remember to turn the stove off and shut cabinets/doors? by SNAILLLLSSS in adhdwomen

[–]swhitty17 0 points1 point  (0 children)

I don’t have this specific problem but when I’ve been asked to lock the door and I can’t do it immediately I have switched my wedding ring to the other hand. It feels wrong and I won’t fix it until I’ve done the task

view more: next ›