why is index match superior to vlookup?

Can someone please tell me about the type of work in SC pay project for Java Developer?

Say you're a manager in a trucking & supply chain company. One of your drivers crashes your truck and leaves some damage on it. Truck is uninsured. Who should cover the repair costs? Me, being the owner of said truck, or the driver, being the one who caused the damage?

8.5 years of experience and _vpis is offering 22.10 lpa ( fixed + 13% variable) . I had asked for around 24. Is this a good offer ? Should i accept ?

Any women doing GORUCK ?

hey all, I’m a (female) freelance producer/PM based in Amsterdam. I would really like to network with more female creatives in Europe in general… know of any existing groups? (Please no, why only women? Genuine replies only ☺️)

Anyone have any info on Ausley McMullen?

Florida associates (3-6 years experience) at regional decent size firms (or I guess really any firm), what is your hourly rate and salary? Thinking ahead about asking for a raise this year, and wondering if I’m limited at my firm bc our rates are seemingly low.

I got power and internet back last night but I have no pressing matters so my bosses don’t need to know that 🫣🤫

Can you recommend any resources to gather data on risk ratings etc for benchmarking? Particularly interested in sector breakdowns and publicly available sources are scarce. Thank you!

How is SAP practice in LTI... Do we have ample implementation projects?

Will the learning be good and how about firm culture , onsite opportunities?

Any SPACs we should be keeping an eye on?

Does anyone know of a recruiter at 72&Sunny for A/M or Strategy positions?

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

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

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

Building an invoicing template for a construction comp but won’t be industry specific. I’ll be charging 5 hours at US$80/hr. Anyone want a copy of it for US$40 worth of crypto?

Context:
I spent 2 days last week and tmr fumbling over invoicing activity with the owner using a poorly designed invoicing spreadsheet. Last minute changes to already approved templates impacting >30 invoices is ridiculous. There will be a control sheet, an invoice generating sheet and a summary sheet. Q’s or comments?

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.

Best websites to get more of a handle on Excel as a beginner-intermediate?

Is there a way to do a multilevel sort but keep certain rows from sorting? I’ve got a fairly involved project plan with different levels and I need to sort by the dates on certain rows but keep other rows intact

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

Presenting data in 2 tables that refer to the same pivot table as source. However, one requires a filter on the pivot table and when filter undone, values change back to original. How to tackle this?

What are some of the unique use cases you have leveraged excel for?

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 🙏

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

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?