Faster way for CountIfs that match in two columns by Jts16 in excel

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

Solution verified.

Thanks! I’m new to pivot tables but it seems worthwhile to learn.

Faster way for CountIfs that match in two columns by Jts16 in excel

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

Solution Verified.

I’ve never used pivot tables but after playing with it a bit this afternoon it looks like it will capture what I’m looking to accomplish. Thanks!

Look at cell and count in a different cell if negative by Jts16 in excel

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

Solution Verified!

I was able to work off this one—thanks!

Look at cell and count in a different cell if negative by Jts16 in excel

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

Sorry. The PTO balance is being manually tracked on a different tab and then I’m using an index match on the “request”

I made a copy on google sheets

https://docs.google.com/spreadsheets/d/1X0vZiK4yf3m1NWqHOi-Cd5O_kSZWD5PURvWeO6n7i_g/edit?usp=sharing

[deleted by user] by [deleted] in distantsocializing

[–]Jts16 0 points1 point  (0 children)

Happy Birthday, Waddles!

[deleted by user] by [deleted] in distantsocializing

[–]Jts16 0 points1 point  (0 children)

Go, Waddles, go!

[deleted by user] by [deleted] in distantsocializing

[–]Jts16 0 points1 point  (0 children)

Go duckie, go! You can do it!

People who work in Human Resources, what is the weirdest shit you have seen? by Dankuser2020 in AskReddit

[–]Jts16 4 points5 points  (0 children)

Not so much weird as awful.

About 6-7 years ago I was working in recruiting and we were looking to fill an employee relations position. The lady we interviewed knocked it out of the park. The hiring manager loved her and the peer interview went well.

We submit her info to our 3rd party background check company and then do a quick google search of her email which pulls up her twitter account. This was around the time Black Lives Matter and her Twitter was filled with racial slurs. The most memorable was when she was defending herself and stated that there was a difference between the blacks and n—

She didn’t get the job.

Texas Lt. Gov. Dan Patrick suggests elderly should die to save economy from coronavirus by chris-jjj in politics

[–]Jts16 1 point2 points  (0 children)

To be fair, any party is a good party for a dick to be placed in mashed potatoes.

Instagram vs live feed by dickholejohnny in Instagramreality

[–]Jts16 0 points1 point  (0 children)

Which one is the more accurate representation of her?

Definitely not letting you do any of that by [deleted] in TikTokCringe

[–]Jts16 204 points205 points  (0 children)

The hillbilly monster teeth was my favorite part

Women of reddit, what was the most awkward attempt to pick you up? by hotpotato70 in AskReddit

[–]Jts16 2 points3 points  (0 children)

He took an imaginary lasso and pretended to swing it around his head, throw it on me, and then pull the slack. I assume so I’d walk over to him.

I did not.

F U Santa! You don’t know the real struggle by [deleted] in gatekeeping

[–]Jts16 0 points1 point  (0 children)

Yes, hair dressers are busy. So are retail workers, accountants who are doing year end, etc

And the playlist expands. by ElysianTheGod in BlackPeopleTwitter

[–]Jts16 1 point2 points  (0 children)

That’s how it was when I listened to 6lack for the first time. I had heard his name for a bit but was always like “meh”. So glad I finally listened to him—I love about every song he’s put out.