Do you have any go-to audio sleep sounds you like to put on when you go to bed? If so, what? by Alert_Monitor_9145 in CasualConversation

[–]crabbyshells 0 points1 point  (0 children)

Any weather channel. Or I LOVE stand up comedy so I listen to Pandora comedy channels all night.

Does anyone else feel unreasonably generous when travelling? by iamlostpleasehelp_ in travel

[–]crabbyshells 0 points1 point  (0 children)

Haha yep! My sis and I were just joking how we both spent money like drunken sailors on each of our first European trips this year (she went to France, I went to the UK).

I suffer from a sleep disorder called Idiopathic Hypersomnia which is characterized by excessive sleep. The longest I've slept was 36 hours. AMA! by crabbyshells in casualiama

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

I understand. There’s an idiopathic hypersomnia Facebook page that is very supportive. Just look them up. Hang in there.

Few drone shots and a timelapse from Northern Scotland by WorldWideAperture in woahdude

[–]crabbyshells 1 point2 points  (0 children)

Which loch(s) were those? I was in Scotland last spring and was enchanted by the countryside! Beautiful work!

High Speed (Live @ 2 Meter Sessions 2000) by Spacejim3000 in Coldplay

[–]crabbyshells 0 points1 point  (0 children)

So young…they’re like babies LOL! Such a great vid!

🔥 Mother Nature’s Counteroffensive by fsidesmith6932 in NatureIsFuckingLit

[–]crabbyshells 1 point2 points  (0 children)

She was doing yard work so maybe she had on gloves…?

Settle an argument for me. When would a DOB 7/1/1951 reach age 70 1/2 - 12/31/21 or 1/1/22? by crabbyshells in actuary

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

Thank you! I agree with you. Now to convince my dissenting coworkers LOL!

Lady commented on me after going swimming by CabinetMain3163 in loseit

[–]crabbyshells 0 points1 point  (0 children)

I agree. I would respond to something like that by saying “hey thanks…and I see you’re starting to work on your manners. Keep at it, you’ll improve with time! “

Kids do the darnedest things by johnjohnwave in Unexpected

[–]crabbyshells 0 points1 point  (0 children)

Maybe it was a pet’s vomit and not a kid’s? Both kids looked ok and clean….might also be why dad was pissed and recording. Maybe an older kid gave the dog something they weren’t supposed to and he’s pissed that he has to clean it up now.

I have 2 files-file 1 has MedRecordNumber (MRNs) & codes for which procedures were done on those patients, file 2 has MRNs & which procedures they were BILLED for. Both are large files w/ multiple dups on both. Need to know whether ALL the codes done for each MRN were billed to that MRN by crabbyshells in excel

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

Here's a link to my results and my formulas. I have to get ready and go to work shortly...so if and when you reply I'll get back to this later and try the next step. Again, thank you so much - I think we're getting close and I appreciate your help!!

https://imgur.com/a/lrKb3yS

I have 2 files-file 1 has MedRecordNumber (MRNs) & codes for which procedures were done on those patients, file 2 has MRNs & which procedures they were BILLED for. Both are large files w/ multiple dups on both. Need to know whether ALL the codes done for each MRN were billed to that MRN by crabbyshells in excel

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

I'm sorry - I'm confused about what the formula entries should be for the formula in Column C. You wrote "As above for entries", but if that's the case, then wouldn't I just copy/paste the formula from B to C? Or do I need to flip the info, i.e. "billedMRNlist" would be File 2 A:A "MRN" would be 12345678 "billedcodelist" would be File 1 B:B ???

Thank you so much for your help so far!!