hey guys, qq for my excel geniuses: i have an excel that heavily relies on another tab of data for a variety of automated calculations and analyses. If I need to update that tab of data or others, what would be the absolute best way to do it? I have tried before and it will mess up my xlookup references and give me a REF because it loses the references from those updated data sets. Thanks in advance!

What do you guyz think of PLTR?

Looking for advice: Boston ring shopping stores and any general tips on how to shop

Anyone know of a good building for a 1bed/1bath. Need to have parking & a/c. Nice to haves is in-unit laundry, any include utilities, any amenities. Trying to keep it on the cheaper end with a max rent of 1,500, but given our line of work I can bump that up if the place is nice enough to justify the cost. Thanks in advance!

Do you review the other side’s escrow instructions and provide comments? 4 years in and I’ve never done this. Working for a new partner and she insists on doing so “in case there are competing instructions” but isn’t that the entire point of funding through an escrow agent/title company?

Does TechM employees get discounts on TechM cars?

Applying for Uk visa from overseas- How do I know if I am eligible for IHS loan ( immigration health surcharge) can someone explain this here? Thanks a lot

I’m a manager and one of my direct reports makes more than me. It really bothers me. Anyone else been in this situation before? What’s the best way to handle it?

Which is a better option to go with - LTI or Deloitte India?
Both are offering almost same pay.
Technology - SAP ABAP

What monetary goal/target are you telling yourself to hit before quitting big law?

Worst sweatshop, STB LA or Quinn LA?

Can someone please tell me what “suitussy” means

Hi fishes,

Can anyone tell me if infosys promotion is happening as part if retention? Mostly from jl5 to jl6? Did anyone get promotion as part of retention? in infosys?

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

How long did it take you to become good at excel? Like fast?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?