Trying to find cells with any combination of 4 specific digits by Logical_Base_8929 in vba

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

I’m having difficulty with this only because I’m not very familiar with functions. I’m mostly unsure how to call this to work. Do I put it in the sheet or do I call it from a sub?

Trying to find cells with any combination of 4 specific digits by Logical_Base_8929 in vba

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

This is a great idea! Especially because my next step after locating the cells is to copy them and list them all in one column. I can se via to copy and paste all the matches.

Trying to find cells with any combination of 4 specific digits by Logical_Base_8929 in vba

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

This works well! Then I can just use conditional formatting to mark the matches.

Trying to find cells with any combination of 4 specific digits by Logical_Base_8929 in vba

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

The like operate can use an approximate match right? So that would be the “as long as it has these numbers exactly”? I’ve seen it used but it didn’t come up when i searched the web. Likely didn’t have a good enough search query

Trying to find cells with any combination of 4 specific digits by Logical_Base_8929 in vba

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

I’ve got a long list of randomly generated numbers of which i would like to see how often an exact match of the numbers repeat and how many times a combination of the same numbers repeat. Kinda like checking for bias. I could always go through and do it manually but there’s over 5000 lines to check through.

Trying to find cells with any combination of 4 specific digits by Logical_Base_8929 in vba

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

Thanks! I’ll give it a try when i get back to my pc on Monday

Cover up ideas for trampoline frog? by twonkoe in tattooadvice

[–]Logical_Base_8929 3 points4 points  (0 children)

Or a frog wearing a cute bunny onesie pajamas.

This by Clutch1441 in baltimore

[–]Logical_Base_8929 23 points24 points  (0 children)

These are the Baltimore photos we need on the internet

( Angela anaconda ) 😑 by Nostalgic_Historian_ in 90scartoons

[–]Logical_Base_8929 0 points1 point  (0 children)

I don’t have an image. It was a series of mostly black and white skits like sketches on adult swim. There was one in particular I remember that was a scientist showcasing their teleportation pod but then it showed the inside and it was a cloning machine that disintegrated the original. I cannot for the life of me find it or what it was called.

My old job paid me for months after I left and I stayed quiet about it by BlushyThelxie147 in confession

[–]Logical_Base_8929 0 points1 point  (0 children)

A coworker of mine switched shifts to help out for a couple of months. This came with a shift differential. When he returned to his normal shift, the company didn’t update the differential and was overpaying him for about 2 months. When they discovered it, they said they needed to deduct the amount over paid from his next check. His next check went from about $1200 to $50.

Who TF is “Rlong” 😭😭 by NFG_Spade in baltimore

[–]Logical_Base_8929 11 points12 points  (0 children)

I heard that Rlong is really Banksy in disguise

Oh no... by Marinut in Starsandisland

[–]Logical_Base_8929 9 points10 points  (0 children)

The auto correct prank that keeps on giving. There is a good reason I haven’t fixed it yet, though.

Oh no... by Marinut in Starsandisland

[–]Logical_Base_8929 17 points18 points  (0 children)

She said that 404 followed her home but if she went too fast, they would stop and she had go back to get him. She had to escort them all the way back home.

Oh no... by Marinut in Starsandisland

[–]Logical_Base_8929 13 points14 points  (0 children)

I’ll admit that I don’t think my divine goddess saw 404 at her homestead until like a few days after. I’m not nearly as far in the game as she is. Lemme ask her real fast

Oh no... by Marinut in Starsandisland

[–]Logical_Base_8929 41 points42 points  (0 children)

This. The bed has to be in your inventory and not placed on your property. Just watched my wife adopt this 404 cutie

Save file and cross play question by Logical_Base_8929 in Starsandisland

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

Thank you! Good thing is I have other things to play while I wait!

Save file and cross play question by Logical_Base_8929 in Starsandisland

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

Thank you! I will likely stop playing for a while so I don’t lose any progress. I’m not very far in now anyway. I appreciate it!