My delta column is not getting the exact difference from the two columns (e.g., 23.4% - 23.4% = 0.1%). When I check those two numbers they have 10+ decimal points. I tried using trunc but not getting correct data in all cells. How can I solve this?

Anyone looking to get in at BDO?
Separately, anyone in the southwest or looking to get to the southwest?

Broke up with my BF recently. We usually go to see his family over thanksgiving and now I don’t have any plans. Does anyone have any suggestions one somewhere I can travel to by myself over the break? I live in NYC and like outdoor stuff, hiking, biking, skiing etc

Do any of the top consulting firms have analytics roles (preferably not super technical) that don’t require weekly travel?

Any tips for HireVue interviews/Delta Airlines?

I screwed up. I’m a newb and didn’t know how mileages work and my gold status w AA is about to expire. I travel weekly and idk whether I should fly w/o status or pay $400 to extend it. Thoughts? 😭

I’m a private immigration attorney whose interested into transitioning into a high level federal government attorney position in the future (not in this administration). Ideally, I’d love to work in the solicitor general’s office.

I’m only a year or two into practice and am wondering if there are any tips to best position myself for this type of position? I don’t anticipate making any moves that way for at least 5 more years. No clerking experience or law review, so that’s -2 points for me

Planning to travel during Thanksgiving (super late in planning as usual) any fun recos- travelling from Chicago have boatloads of AA and Bonvoy points to burn. 7-8 nights

I just spilled a bourbon on my iPad due to turbulence. How many points?

Can alt coins be purchased using litecoin? If yes, then please suggest a platform

Is this legal? My spouses company just decided to change their comp structure for account managers. It was base + comm, now it’s commission only but nothing changed, OT commission is the same, didn’t get more points, just took away the base pay and said work harder basically. So now they have to worker harder to get $50k they were already making. (Not a decision based on employee performance, they’ve been crushing it. I think the company is just trying to save money they overspent else where)

AMA: International Travel (US to Europe) During Coronavirus! I found very little info on this topic before my trip and had a bunch of questions which I wish someone could have helped with. Now, a friend and I both traveled US to Europe in the last week, different routes, in Econ/Biz. For anyone else looking to do the same, I’m happy to answer anything about the process - check in, flights, mask usage, security, visa checks, airports, social distancing, etc.

I am stranded in a foreign country, was traveling for personal reasons, because AA cancelled my flight citing weather concerns but is flying other flights at the same time. Is there a way for me to 1. Get an alternate flight that is not painful. 2. Escalate and get compensation? Thank you.

Does United tell you when you clear the upgrade waitlist or do yo have to keep checking?

So I chose an offer for Deloitte India over Infosys as a Node.js developer. Joining next week. But most of the time when people praise Deloitte they mean USI so I have been of two minds and wondering if I made the right decision.
Also is travel needed for Consultant designation?
In the managerial round the guy told me only need to go to office to pickup the laptop and after that it's wfh.

What to do if you love consulting work but hate the travel?

Hpw do I buy alt coins? Deloitte, a u tattooing?

Hotel recommendations in Sydney and Melbourne?

Hotel room A/C... always turn it off regardless of geo location. What about you?

Hi all,

I am an IT professional having almost 5 years of experience and want to move to Canada for PR. My CRS score is not upto the cut off. I need someone who can help in earning connections points for Manitoba PNP program.

As it allows having an acquaintance or a friend to earn those 20 points, it can help my PR application.

Anyone who is PR and resident of Manitoba can dm me to discuss around it. I am ready to pay for this assistance as well.

Does anyone here honestly think Trump will lose 2020?

Hi Fishes, I am a data scientist in EY with 5 years of experience and I am also serving notice period and my last working day is 20th July. Could you please refer me at your places? My major area of expertise is NLP and also Computer vision. I also have experience in making API using Django and Flask. Thanks in Advance!! Adobe Amazon Microsoft IBM Oracle Expedia, Inc. Google Walmart

How difficult is it to switch projects internally in TW? Is there any said amount of time you should be in a project before you can switch?

How do i find out if I will be happier divorced or more unhappily staying married. 2 kids; 2 & 4 YO. They don’t hear the arguments after bed time and don’t understand the bruises yet but I know it’s just a matter of time. It would be so much harder not seeing my kids everyday than living with the pain, loneliness and lost friendships. But I’m tired. And so sad. Lost. So alone. Does anyone have something that turned it around? He changed? You changed so he did? Ayahuasca retreat maybe?

For those in the SCM industry, what is your job title and your daily responsibilities?

Most of my family members think all I do is write addresses on boxes and toss them in the mail. Is there anyone else who has this problem? It feels like people think of logistics as unskilled labor

Is there any not very expensive black tie gown shops near Toronto downtown? New to the city and office party has black tie dress code!

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?

Hi all! Is there a way to easily copy over all the rows from multiple sheets into one consolidating sheet? We have 32 teams filling out transactions in their own tabs and need to consolidate all tabs transactions into one long list of transactions. Thank you!

Has anyone used eharmony? Yay or nay?

What is Pinnacle award ? And How will that benefit me ??

Any good PG's in Viman Nagar for boys? If someone can DM just names or any connects. Would be grateful!

Any recommended books to read prior to beginning a summer associate position? Transactional/ Corporate & Finance

Have interviews set up at FAANG co and getting good signals, for a position that was posted widely (all across US) but not remote. Haven’t broached the subject of location yet. Would you (1) early on clearly state that you’re not open to relocation but that you would be open to visiting a big office once or twice a month; (2) not say anything now and wait to get an offer and ask for an exemption; or (3) something else?

Currently I make a base of $63k/yr and $1k/mo in bonuses pre-tax. I manage a performance for a team of licensed insurance agents (service-based role in a direct business environment), maintain our business relationships, and support adhoc training needs. Is there anyone else in this type of role who is able to share how this compares to similar positions and your general location?

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)

How useful are Macros and VBAs for tax prep?

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

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

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?

Hi all! Is there a way to easily copy over all the rows from multiple sheets into one consolidating sheet? We have 32 teams filling out transactions in their own tabs and need to consolidate all tabs transactions into one long list of transactions. Thank you!

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

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

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

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

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

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

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

What's a simple way to explain data organization to people who don't use formulas very often? People on my team love creating many tabs instead of adding columns for recording the same type of data...

Anyone have a good source to learn sql