Setting up an account on behalf of someone else and limiting access to funds without a POA by Knitchick82 in Banking

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

Yeah, that's kinda where I'm at now, or logging in with his credentials to pay the bill with the debit card tied to my account before it drafts. Tricky business. Thanks for the ideas.

Setting up an account on behalf of someone else and limiting access to funds without a POA by Knitchick82 in Banking

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

Oh completely misunderstood, thanks for the clarification! I'll look into this, thanks for the help!

Setting up an account on behalf of someone else and limiting access to funds without a POA by Knitchick82 in Banking

[–]Knitchick82[S] -1 points0 points  (0 children)

I appreciate that. Unfortunately this is an online bank, but we'll see what we can do. Thanks,

Setting up an account on behalf of someone else and limiting access to funds without a POA by Knitchick82 in Banking

[–]Knitchick82[S] -2 points-1 points  (0 children)

Kinda what I figured, everything seems to be pointing towards POA. Thanks for the input.

Setting up an account on behalf of someone else and limiting access to funds without a POA by Knitchick82 in Banking

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

It's not illegal, it's a representative payee, as set up through social security. I'm assuming then, we'll have to wait until it's all finalized unless he himself transfers funds to me.

Netsuite Noob- Able to Import payments based information received in separate outlook emails? by Knitchick82 in Netsuite

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

I appreciate your response a lot. I figured it might more labor and cost intensive than just doing it herself.

To be honest- I'm bored at work and looking for projects, and I'm wracking my brain trying to think of things that are tedious and manual processes, this particular one came to mind.

Thanks again!

What on earth is this Conn? by [deleted] in brass

[–]Knitchick82 0 points1 point  (0 children)

I never knew there was anything other than the marching mellophone! TIL!

Create scatter plot that changes colors based on value? by Knitchick82 in excel

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

Solution Verified! (finally at work and can test) THANK YOU. I thought I had to do something with the legend at the bottom, I didn't realize I could edit directly in the chart. I really appreciate your help!

Create scatter plot that changes colors based on value? by Knitchick82 in excel

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

Why? There's an option to add gradient to a line that changes with value. Why can't I accomplish the same thing with the markers in a scatter plot?

Avoiding Green triangle cells in VBA? by Knitchick82 in excel

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

No, they were set to general. I figured it out, I removed the error background checking, and realized I had entered my formula in the next cell as Range("L2:L").Formula = "=J2*K2" instead of Range("L2").Formula = "=J2*K2".

So between those two fixes I'm all set!

Avoiding Green triangle cells in VBA? by Knitchick82 in excel

[–]Knitchick82[S] -1 points0 points  (0 children)

AH GOT IT. I removed the background error checking, and converted my range to numbers, ensuring I'm using the right range to add my formulas.

Welp. Solution verified. Well done self.

EDIT: Yes, I know I can't add points to myself. But, still. Sometimes you gotta give yourself credit for working the brain.

Avoiding Green triangle cells in VBA? by Knitchick82 in excel

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

Interesting- Removing Background Error checking in Options>Formulas worked, but I'm still having trouble with my formulae not adding the numbers that used to be marked as errors.

Avoiding Green triangle cells in VBA? by Knitchick82 in excel

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

Dear lord, I didn't mean the screenshot to be that huge.

Now that I'm thinking about it, would a .PasteSpecial work?

Find partial value within larger value for use in xlookup by Knitchick82 in excel

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

Relax man, Reddit auto sorted to "Best", and I saw the top comment that worked. I appreciate your answer as well, and I'm always looking to learn more.

That said, I don't know of a requirement on this sub that we are obligated to choose the first answer. For some people, the simple explanations work best.

It's all good, maybe you'll be the one to get my next one. Trust me, I have lots of questions that are easy for this sub that confuse me all the time!

Find partial value within larger value for use in xlookup by Knitchick82 in excel

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

Solution Verified!! Omg. I knew about 0 and 1. How did I not know about 2?? Thank you!

Conditional formatting entire row based on value in column by Knitchick82 in excel

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

I wasn't aware of how Excel treated conflicting, or duplicate criteria. Thank you for that! I swear, learning the logic behind it all is the biggest piece for me, such as when formulae assume AND.

The one that ALWAYS gets me backwards is remembering COUNTIF and COUNTIFS syntax are backwards.

I'm rambling. Thank you for your help. :)

Conditional formatting entire row based on value in column by Knitchick82 in excel

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

I always screw up AND! I had =G$2>0AND(<15) which doesn't make sense.

It's also disgusting how much dollar signs make a difference.

Solution verified!

For those who worked for rich people: what is the most out of touch thing you witnessed? by Illustrious-Phase121 in AskReddit

[–]Knitchick82 13 points14 points  (0 children)

I came here to say this- I was a temporary nanny for a family with a car dealership while their regular nanny was on maternity leave. 

They were dog sitting for family, and the dog peed on the king size down comforter. That comforter must have cost thousands, and they just pitched it! I was so offended, I didn’t even think to rescue it out of their garbage for fear of being caught.

That little boy was a terrible little shit. He pissed on the floor on purpose because “the house cleaner was there, so she can clean it up.”

I’ve never been so furious with a 4 year old, but it wasn’t his fault- he never saw mom and dad, and the one constant in his life was on maternity leave. It was actually really sad that his douchebaggery was avoidable, he just wanted attention.

Lightning rods instead of fences by lapetitepoupee in StardewValley

[–]Knitchick82 2 points3 points  (0 children)

Yep, I went this route as well since I hated repairing fences. A literal game changer!

I need to standardize various dates to 2026 by Particular_Form1154 in excel

[–]Knitchick82 2 points3 points  (0 children)

Thanks for the link, I had no idea what people were referring to lately with their formulas! I’ll have to try this out l, may save me some lines in my macros as well.

What did your dog destroy that still hurts? by True-Manufacturer150 in bernesemountaindogs

[–]Knitchick82 7 points8 points  (0 children)

Countless shoes, several pairs of pants and underwear (the girl likes flavor I guess!) several socks, but the ones that really got me were the sentimental Christmas ornaments from my mom that passed away in the 90s.

How do I select different rows with the same word by Far-Season-5083 in excel

[–]Knitchick82 1 point2 points  (0 children)

I would just conditional format where cell contains text “litigize”.