I am getting a formula.firewall error in PQ for my merge queries step - I’ve rebuilt both queries (deleted steps in each and recreated them). Is this a security function at my firm or is it something in my model im not understanding?? 😞

like
Posting as :
works at
You are currently posting as works at

Nevermind… I forgot about these privacy setting things mine got reset somehow

like

Related Posts

Anyone recently hired at Big 4 - are there still signing bonuses and referral bonuses? If so, what firm and how much?

like

Just got paid out on my last day. How do I know the amount is accurate? Yep, it's almost equal to 2 paychecks. But I want to know if my pension was paid out to that same check. If it did, then I think I got paid less.

like

How is Capgemini different from Capgemini invent which is better to work.
Also what is the year end cycle for Capgemini invent.

like

Does anyone have a non-compete clause in their contract in the UK (restricting you to work at a competitor firm)?
Do you know if Accenture enforces it at the time of exit?

like

Hi fishes,
LTI is offering me 16lpa(base) +80 k (vp) +retiral benefits.
YOE- 5.2
Np left- 21 days
Tech stack- Ionic,Angular,Typescript
Is it underpaid? How much should I try to negotiate?

like

Should you join Goldman Sachs Bangalore or Goldman Sachs Hyderabad? For growth prospects

like

What was your % increase from associate to senior?

like

Met a guy on Grindr who was visiting my city for the week. We had dinner Friday night. Met up again Sat afternoon and spent a full 24 hours together. Enough in common to keep the conversation going, not get on my nerves, and enough chemistry to be attracted too. Is the next step plan a trip and hang out again for a day or two? I acknowledge jumping to anything more serious than travel buddies would be challenging and unlikely given the distance. Thoughts?

like

What are the best healthcare consultancies for strategy (with or without operations/implementation) for digital health?

like

Could not focus at work the past few days...#crypto

like

I've been working as a building engineer for this company for 3 years. Within these 3 years I have gotten a HBA C education been paid for by the company.They've had me at a very low number for the whole time that I've been working for them, And without a certification in HVAC I completely understood. But now that I have my certifications I am asking for a pay increase of 25%. Do you guys think I am being fair? On top of my certifications I have been doing the work of 2 engineers for the last 2yr

like

What’s a nice and fun place to go for New Year’s Eve. We originally wanted to go to Miami but the hotels prices are wild.

like

Cognizant layed off thousand of employees with fake experience?? Is this true

like
like

Does anybody heard of or working in Rialtes Technology. Want to know about the learning, WLB and policies in it.

like

So I’m thinking of taking a pharmacy tech course at my local community college. I already work in healthcare on the admin side (authorizations, front desk etc) & looking to get a certification that’s quick & don’t have to go back to school. How is it being a tech in the hospital setting? What other paths are there for techs? How much can you make? Or are there any other short certifications that would make more money?

like

Hi
My husband and I just went through a few very difficult months. His mother passed after an aggressive disease and struggle, we had another family member pass, Covid, political climate, +. Just under the surface we are so sad. We have a very easy baby but a young child is still demanding. We are not motivated to work and I can’t figure out how to return to “normal.” I am not pulling my weight at work and generally can’t imagine being motivated like I was. Please send advice.

Does Morgan Stanley provide food allowance? Or free food?
I know some people get it, but this was not mentioned in my employee benefit hr discussion

like

Deloitte vs Accenture which one should I join?

like

Hi fishes.
I'm working at Goldman Sachs Strats, and earning 21 lpa fixed. A friend of mine, from IIT is earning 18 lpa. I have passed out from a local engineering college, so was feeling guilty of earning so much. Sould I request the company to lower my ctc?

funnylike

Additional Posts in Excel Genius

My excel columns have switched to numbers (so I know have numbers for columns and rows). This has also made all of my formulas incredibly confusing. Was this part of some update? How can I switch my columns back to letters?

like

Not Excel related, but any folks in strategy willing to suggest the best and most useful data platform to learn? I’m thinking along the lines of Tableau, Power BI, etc.

likehelpful

Hello Magic Fingers, Looking for your quick suggestions - how to deal with the Trace errors? I am getting trace errors on certain cells whenever I download any datasets out of JDE. For example if an item code is only Numeric then JDE returns that as a Trace error and whenever I use a Vlookup or Index-Match to find something, it always returns NA , because lookup value is 123 and the lookup array has ‘000123. Since I work on more than 200K lines, Excel takes forever if I try to convert to number

like

Is there an absolute moron’s guide to Index Match? I have two tables of users, some exist on table A that don’t on B, and vice versa. I need to merge them based on their email as the unique identifier

like

What are the most useful macros you’ve seen that could be used across multiple projects?

like

How do I get a vlookup to spit out multiple values?

like

How can I make these dates sortable with a filter?

Post Photo
like

There has to be a way to restrict access on a worksheet so that only specific cells can be edited.

No matter how many times I’ve tried to automate and simplify generating reports to just inputting data into specific highlighted boxes, someone just have to try to edit a completely different cell then asking why the worksheet is “broken.”

likefunny

So xlookup? How is it going for you? Still haven’t use it.

like

Hello again fishies...

Column D in tab 1 and tab 2 is a drop down list which has 6 items.

In tab 3 how can I return the Cells in Column a b and c (tab 1 and 2) when the value in cell d(tab 1 and 2) is one of the 6 items selected

like

I have a spreadsheet that includes these columns: total AUM of firm X, % of AUM allocated by X to sector Y, % to sector Z, and so on (one column for each sector). Goal is to present in tabular form...

Dear auditors, please explain how you pick samples for substantative testing.

like

Does anyone here use ASAP Utilites as an Excel add-in? This thing is amazing.

like

Hello! I need to improve my excel skills. I know how to do some basic stuff but I need to do more. A client was teaching me how to use vlookup and I felt so useless! I decided to do something about it. I typed excel in udemy and there were so many results, I immediately became overwhelmed. Which one is the best? And shortest? Thank you!

like

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

My Goal: I have a drop down menu in a cell. I want it to sort conditionally based on what I select. Is that possible?
Ex: If the drop down ="done" it falls to the bottom of the list.

like

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

like

Anyone have recommendations for good hands on courses to increase proficiency in excel? I want to learn how to do vlookups better and use if/then statements and manipulate large sets of data to create dashboards. I know YouTube but I’m asking for courses that I could put down for development as part of my performance review.

like

I have a table in sheet1. Column examples are ID, Initiative, Owner, etc. I’d like to use that table as a growing list of inputs. I’d like for sheet2 to be used by another team for other types of data inputs. But I need sheet2 to automatically populate the IDs from sheet1 as they change. Thoughts?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal