Need quick help - numbers disappear or rather just become zero when I am adding or subtracting amounts from two different cells.. hardcoded amounts are fine just summation .. hopefully excel is not corrupted

Which case studies book to refer to for management consulting interviews??

Any splunk developer jobs please comment.

I’ve (consultant) delivered one engagement very badly, director was not satisfied with quality and I could admit it.
What do I do ? Do I need start looking for other job?

Where did you find your mentor who has truly made a difference in your career? How did they contribute?

I have an offer from IBM of 16 lpa, but recently I got promotion in my current company and package got raised. Should I ask IBM to increase my package?

Y. O. E - 5.10

Do the layoffs worry you?

Do infosys still ask for 60% throughout academy for experience people as well?

Need a book recommendation.. something intellectually intriguing yet fun to read. Bored of all business and safe advice books.

We’re WFH for another 5-8 months. To be honest, I think it’ll be a while before NYC goes back to the office. I’m saving so much money living at home. Should I just go for the Tesla?

Design Leaders! Have you ever gone through the process of creating a UX Strategy? A UX Vision? Can you talk through how you did it? Can you share examples of what it looked like? Can share the impact it had on the product, and your org?

My boss is a smart rainmaker for the organization. But she bullies people to get her way and doesn’t let people express their opinions. She is very high up and I don’t know what to do. I don’t trust HR and fear it getting back to her and the retribution.

What do you think is the actual income ceiling for software engineering, broadly? I'm genuinely curious and don't even know what's possible

What are Guidehouse’s cellphone benefits?

Memers, what are you upto today?

Anyone knows how alimony works ? In terms of salary ? How much more than your partner do you need to make, to be granted alimony… I’m asking because I have seen cases where one person sacrifices themselves studying and working hard, while the other person is basically doing the bare min, and they can get alimony if they separate ? In some cases, for life.

If I have NAME, REF etc errors in different spots of a very large worksheet, is there a quick way to delete all formulas that are bringing errors?

How do you make defined name ranges stay the same when the source is changed in power query? I’ve been really struggling.


I have a model with many defined name ranges in it that are referenced throughout. Each named range is set to be 250 rows long that way it works as long as the data set has less than 250 responses. However, when I switch the data source in PQ, it inexplicably shortens all my named ranges by around 4-6 rows (for example, one that was $B$3:$B$252 becomes $B$3:$B$246). Help?

Problem:
There is a table. Column A:D are mapped to column E with unique records. In a new column (Q), there is a list of values that that contain any randomized value from Columns A:D. What is the syntax to map Column Q to column E?

Is using INDEX/MATCH the right direction?

Does EY’s version of excel have Xlookup? I don’t see it

Does anyone know a shortcut for unhiding rows/columns. I.e. the inverse of Ctrl+9 and Ctrl+0?

Can you use the SUBTOTAL feature with formulas as well? Such as IF statements

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

How do you create a Pareto chart in excel? Like I want to identify what percentage of customers contribute to 80% sales. I have data at individual customer level.

I have a filtered date data and wanted to only copy the visible cell in column A and paste it to the next column (column B) with special paste. Because it is filtered data, I could not simple copy the whole column and paste it all at once. What is the quickest way to do this? I tried to search macro online but still cannot do it right.

My boss has advanced skills in excel and I don’t. We share documents but we are never on the same page with the data updates. How do I make the document a live doc, like google sheets? Also does anyone know how I can sharpen my skills without being in a lecture? I’m a visual learner, I have to see someone do it then I pick it up :/

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?

I am running a macro that uses "Application.FileDialog(MsoFileDialogType.msoFileDialogFilePicker)" to select a single workbook file and then open the selected workbook.

Cell A1 on Sheet1 of the workbook that is running the macro contains sheet names that can be selected from a drop-down list. I want to be able to use the sheet name that is in cell A1 to select that sheet in the newly opened workbook.

It's probably something simple, but I can't seem to get it to work. Any ideas?

I’m looking to get a second laptop strictly for the use of excel & financial modelling. I currently have a Mac and would prefer to spend around $500 CAD. Any suggestions?

I have zip-zip routes for a trucking company. Most of them have price info but some are blank. Is it possible to do a count of those with price and without price in two columns of a pivot? I want to show that prices are missing across the board and that we can use the majority to replicate the missing few.

Has anyone had any success here with recording a macro to set up a pivot table? For context, I am just looking to run a pivot and then run the macro and have it show the pivot table completed with the right fields in columns, rows, and values and then also formatted how I want. I tried to just record doing the setup of the macro, but I got an error message when trying to rerun.

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

Anyone know how to capture reference text (I.e. some reference of a particular word in a given cell with multiple words) within a Median(if()) formula? Usually I use the funky “*”&xyz&”*”, where xyz is the word I’m looking for, but isn’t working in this formula I have down:

=IFERROR(MEDIAN(IF(Data!$AR:$AR>0,IF(Data!$Y:$Y>0,IF(Data!$M:$AM="*"&D$345&"*",Data!$BR:$BR)))),"")