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?

Do people have relationship check-ins with significant others? How soon is too soon to mention the future? (Context: 31F, dating 5 months exclusively, BF likely moving for job in 8 months).

Is the latest Apple Watch much better than previous versions? Worth the money? Thinking about buying

I anticipate trolls/blowback for asking this but hear me out pls: do you think it’d be acceptable at your firm if an analyst has an OnlyFans account? Assume that you/HR finds out by chance (the analyst doesn’t publicly advertise it), and the analyst is a quant (not directly external client-facing)

Hello fishes,
Can a capgemini employee join his client organization.

Hows the h1b visa transfer success rate been lately? Are folks hearing back soon under premium?

Hey, I have around 4.25 yoe, Java Full Stack Dev, curr CTC 14.2 LPA all fixed. I got an offer from Optum 25 Fixed + 5 variable at position level 27. Is it a good offer or shall I negotiate? I have already accepted this offer. Location: BLR

Where to get a great dinner jacket tailored looking for something in navy, maroon, or olive green, price no object

Hi! How do one get from admin assistant role into an executive assistant role? Thank you for all your responses!

Does anyone feel like they’re industry agnostic? Like they’ve worked in many industries and not sure where they can specialise?

given the things Trump did while being president, including the January 6 mob on the Capitol, why has it taken so long for justice?

thinking about studying law .. i feel this would be pivotal in not only my insurance career but in business overall regardless of where my career takes me . I’m 32 and have two young kids , living in Australia .. anyone here studied law later on in their career ? what would be your main advice out there ? was it worth it ? anything you would do differently?

In case y’all haven’t checked, the top news story from Fox News right now is an opinion piece about a rumor being pushed by a pollster that Bill Clinton had an affair(s)...

M1 salary for B4 M&A tax in HCOL city? Looking to jump to B4 as a manager but not sure what salary to ask for.

I am in a small-medium sized firm. Is a $50 gift card appropriate for the administrative assistant? She is not “my” assistant but helps everyone in the firm for timekeeping etc.

I have an interview tomorrow for a tax senior role at a PE firm. Any random things I might be forgetting to prepare? I feel prepared on my background and basic interview questions.

I know this is for excel, but any Tableau experts here can let me know how to present my mixed (countries, states, provinces) data on a map. I’ve tried dual axis but still not where I want it to be.

How would I create a bar graph that shows same store sales growth for 5 products that were promoted during different time periods?

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?

Trying to count the maximum number of overlaps in at a given time in a series of date ranges. Finding an overlap is easy, but not sure how to cycle through date ranges while keeping a Max count

If I have a very large pivot table with a bunch of subtotals, is there an easy way to make those subtotals actually formula driven? Other than just copying the values from the pivot into a new sheet and converting the hard-coded amounts to formulas manually?

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

What are your favorite excel macros to make you more efficient at work?

Has anyone got a relatively straightforward plug and play Excel template they use to generate plan on a page using start and end dates for activity that updates coloured bars and adjusts accordingly on an excel sheet? I can make it look good after, just wanted to see if anyone uses something like that?

Wait … xlookup is basically VLookup and Index/Match?

Is this seriously a viable alternative because what the hell have I been doing with my life?

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?

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

Just here to praise the Unary Operator. Old school programming trick that’s still very relevant.

In Excel it’s =--(Range =or other logic op Condition)

I am trying to create a formula based on data type geography. I want to ba able to write if(cell=NY,,) but I get #value.

How do I get formula to recognize the text of a geography data type?

My company has locked down our Excel so that we can no longer access the VBA Editor (it’s greyed out and Alt F11 doesn’t work). However I can still access the Word VBA Editor. Is there a creative way I can launch the Excel VBA editor via the Word version, or somehow run Excel VBA code via the Word version?

Is it possible to make a VBA userform that let's me interact with the workbook? I know how to create the form but default seems to be that I can't do anything else in the workbook until the form is closed.

Not Excel but Outlook: anyone know how to make it so others can’t recall messages from your inbox?

Is there any big advantage of using gsheets over excel?

I currently work for a manufacturing company and worked my way from an entry level customer service role to a high visibility operation leadership role in 5 years. I currently handle the master schedule, forecast and SIOP process and want to expand on that… I have done all of this with only my GED… I want to grow more and I do not have the right people in my life that can direct me to the right degree. I truly found something I love to do but need the degree to open more doors. Help!