Looking for some good formulas to use. Not like VLOOKUPs/IndexMatch or INDIRECT...just something interesting. Usually works out best when people have excel problems! I haven’t used a spreadsheet days.

Need 11 like to use app.

We're about to start planning our wedding. I have a huge family and friend group (100+) that I want to invite and she has a very small family and group of friends (>50). We haven't talked about this yet, but I wanted to get some opinions on this before hand. Should I reduce the be l number of people I want to invite to match hers? Is it unfair to her that I'll have a significant majority at the wedding?

I am an RN & obtained a Masters of Science in Healthcare Informatics. I am seeking to pivot into Clinical Applications, but it’s quite challenging with no experience. Any ideas & suggestions are welcomed!

Interested in equity research (preferably in healthcare). Would like to anyone who can give me insight from day-day work, exit opps, and mifid!!!

Are y’all finding that HR is preoccupied with Coronavirus and not the (k) plan?

Hi All,

Need a referral for an in-house legal role at JP Morgan. Kindly connect through DM or comment here if you can help me with your referral.

Folks, based on your experience, what are the pros and cons of making an internal transfer within your firm and/or applying for a role at another firm when making a move to the west?

Wasn't it like a decade ago that O'Reilly sexually harassed a lady by saying he wanted to rub a falafel all over her body? And now he's fired? I just assumed Fox was ok with him being a criminal perv.

Stay.the.course. Easy to say, hard to do. Here is one legendary Bogelhead post from banking meltdown 14 years ago. Worth a read and very instructive….adding link in comments

Good morning everyone. Does any one have any tips of adding Powershell or Python scripting to your resume? I don’t want to just add those buzz words but be able to back it up. Should I have examples on GitHub? Or my own blog?

Thanksgiving is upon us. Send help.

My step in laws are TERRIBLE. Not directly to me but family dynamic is stressful. They parent their youngest kid with pills and ignoring him, so that he does inappropriate things around me with zero correction (walking in on me, insulting me). They are all half siblings (4 boys 30-11) so they all don’t care including my partner. FIL also verbally abuses MIL in front of us. Yet they all want to please him constantly. It’s just bad.

Food was good though.

Does anyone have feedback on working for Mercer Advisors? I see a few positions in the Rockwall/ Dallas area that intrigue me. I’ve read Glassdoor reviews- was looking for more in-depth info.
I have my SIE, Series 6 and Series 63.
What is the work culture like, PTO, management style? Thanks!

How do educational stipends compare across the big 4? Does the amount increase promotion etc? I’ve noticed that I end up using my stipend to attend internal trainings instead..?

Hi, looking for testing openings at Trivandrum location, 9 years of experience. Kindly help

There is a special place in hell for the people who use space of two cars while street parking.

Hi fellow consultants - I am working on an internal project for my company. I am hoping you can help with 3 easy questions:
1. What company do you work for?
2. From a timesheet/utilization standpoint, what does your company consider as a work week? (e.g, 40 hours, 50 hours)
3. How many hours are you expected to work in a week?

I’m copying a report into workbook but the columns don’t line up to the report is there something I can do like to make it if this column name copy here. Not sure if this makes sense. I just fell like it really manual and there has to be an easier way

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 anyone know a shortcut for unhiding rows/columns. I.e. the inverse of Ctrl+9 and Ctrl+0?

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?

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?

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

Looking for a shortcut key that is the equivalent of PowePoint's Ctrl + Shift + Up/Down arrow.

Essentially a way to switch row positions w/o replacing or inserting cells...

There are a lot of recommendations for Excel plug-ins for Excel but they are almost all for the Windows version, so what recommendations for plugins are there for the Mac version?

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?

Is there a way to wrap your header text within access database?

Been in consulting for over a year and wondering what other formulas other than index/match and vmatch is useful.

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.

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 :/

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?

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 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.

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.