How to apply conditional formatting across tabs in excel sheet? In a drop down data validation I have A (Green) B (Blue) and C (Red). I selected the cells I want to apply, hit format painter and then selected the cells where I want to apply on next tab but not everything carries. Wondering if any tips on what I’m doing wrong

Higbee or dulcich? Ppr

For all those fully remote fishes out there, does your firm require you to be barred in the state of your residence, of the office to which you are aligned, or both? Specifically wondering how west coast offices are handling this.

Hi GL people ,
Are people who joined in this September are eligible for financial year increment that will happen in March 2023??
Thanks in advance .

What is the CTC for Manager level? Asking for both Deloitte India and US

My facility want us to run Bipap on Med-surg floors. I don't think that is safe. It's one RT in the entire hospital.

I accepted a base salary of $60k as a first year associate and to expect an end of year bonus based on the settlement of my partner’s cases that I work on substantially. The bonus was only $2500 and I got a base pay raise that still doesn’t bring me into the lower 25% of the market rate. Feeling really undervalued and not sure if this is normal in “plaintiffs world”

Hi All, I am going to join EY on 29th of March. By when I will be getting my first hike. Generally how much yearly hike and bonus they provide?

What kind of signing bonuses are litigation associates able to get when lateraling currently? I know corporate is more desperately in demand than litigation, but I've seen some signing bonuses for litigation. Class of 2018.

Also, I remember seeing a recruiter sometime ago whose model was to share part of their fee with the associate (sort of like a rebate real estate agent). I can't seem to find anyone like that on Google now, so I'm wondering if anyone has any leads on that.

Hi fishes,
I am looking for a job in PM field. Got experience in 4+ YOE in Project Management and 4+ YOE in Business development.
Please suggest!
Thank you

Has anybody ever gotten a response to any of these spinmaster job postings?

Just got into an argument with someone over this. As an RIA are you considered an "associated person" with a FINRA, NFA, or other Exchange Member Firm?

What % of your savings would you put down towards a down payment?

have a final round interview for a Corporate Banking Analyst position at WF coming up. Virtual interview, about 2 hours long, 30 minute intervals with a rotating panel. (virtual, yet abbreviated super day?) Never had an interview like this before. Any insight on what to expect? Does each interviewer regurgitate the same questions? thanks!

what should be the ideal salary for 6 yoe SDET?

What is the locking period for persistent system for re-attending interview? I gave interview 1.5 months back but was not selected that
Time. But now again getting call. Am I eligible to re-attend?

Thanks.

Have any 🐠 out here pre-ordered, “Quit Like a Woman?” I’m excited to read it. I subscribe to Tempest and Love Sober and Soberistas.

Inflation costs are killing my pipeline. Many of my deals are scaling back greatly because of their rising operating costs.

How do we overcome the inflation objection? I mean obviously the answer is to show how much value we offer, but how do we do that when all of the companies we work with barely have enough funding?

They need our services, which is at least some job security, but their scale back is greatly affecting our projections and quota attainment.

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

I have historical quarterly TTM values for a number but not the value for that quarter itself. Is there a way to back into a given quarter’s value?

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.

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

I have pivot table with a sum column but it won’t let me filter. Any advice on how to fix this

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)))),"")

So i have a list of companies in a list (column A), and a “Y” next to them (column B) if i want to include them in my dataset.
Is there any way i can make a variable list, ie below the full dataset, of just the companies with “Y”, and it being dynamic?
Can post a screenshot tomorrow if useful to explain

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?

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?

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.

Is there a text to rows (instead of text to columns) trick?

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

Any tricks or ideas to turn a table to a JE quickly. Each row of the table would be about 44 lines. Columns are the various dollar values associated with parameters of the first column. I started just transposing the numbers and copying down the first few columns data but there has to be a faster way.

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

Can someone help me with recoding surgery question into binary variables? I’d so appreciate your help! TIA

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

Is there an easy way to see a +/- 10% on all of my variables in a model? Is the easiest way just using a formula and creating separate columns to visualize it

I have a large dataset and when I filter, I keep getting up pop ups that say “fixed objects will move”. How do I get this to stop?