What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

Any US companies hiring remote @ Canada ?

Currently a MS finance student. Recently secured a year long internship with the Federal Reserve researching commercial banking conditions. The role is tech heavy (python, R, Sql etc ) What kind of roles can I look into in the event there’s isn’t a return offer? Thanks

Hello NYC fishes. If you pay your fares via OMNY for SBS bus, and there is no ticket to show if fare cops ask you for it. Apple Pay history won’t show up immediately after transaction (Chase), then what do you do?

For those that are home grown (at least 2 levels) into the PPMD level, how has your relationship with juniors that you’ve been close to from the start evolved? Have you had to pull away from them (intentionally or not) or are you just as close? Is the saying “it’s lonely at the top” rung true for you?

Alexa is just great. And beautifully produced. Good concept.

Thoughts on EXPR?

Can anyone tell me about EY India ( Not EY GDS) ? Pros and cons

Hi all. . . .
I am thinking of switching to a different company I wanted to know what can I say about the salary expectations. Currently i am a tax associate 2.

What's currently in your refrigerator? I have a bottle of milk that apparently expired a month ago, stale bread and almond butter that could pass as cement. #adulting

Is 2 weeks of vaca looked down upon? Haven’t seen anyone on my team do that...

Let's have a productive conversation about the Google employee who was just fired for his controversial diversity memo

Investment gurus - Appreciate pointers for resources (books, blogs, videos etc.) to read up on investment strategies. Just getting started and could use all the help. 🙏

Best ergonomic desk chairs under $200?

MLE with 4+ yr experience. What ctc I can expect in quantiphi? wlb is bad in quantiphi?

I’m a financial advisor with jpmorgan and i verbally accepted a new job in private banking with another firm. This is my first time transferring licenses. Should i wait to give my two weeks notice until my new firms hr department clears me and gives me a start date or as soon as i sign the offer letter?

Hi everyone, I work for large startup (300 employees) and I have been asked to develop a Progressive HR manual template. Some examples include gender neutral restrooms, lactation rooms, signing off emails with pronouns, and etc. Any tips/links for resources to help would be appreciated.

Can you sell your used shrm cp books from the learning system? If so where?

My inboard portal is showing wrong dob and phone number and i m recieving mails to complete the document process plus the hr is not responding to my mails or calls. Should I submit the documents or wait for them to respond??

Are hexaware offices opening this year or next year ?

How is Austrian Air and Air Canada? Solid airlines for economy seats?

Best websites to get more of a handle on Excel as a beginner-intermediate?

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

Any book recommendations on excel modeling for real world business applications?

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?