I received a lot of feedback about my post yesterday not having enough info. For those who attempted to help, I appreciate you!

I have attached a mock-up of what I'm needing. I need to be able to track the inventory on my shelves while adding inventory about twice a month.
Blue rows = additional inventory
Yellow rows = shipped from different locations so I want to EXCLUDE from my Current Inventory.
Column C options are from a drop-down list and these are the only options.

Hi,
My date of joining in TCS is 16th November 2022

- Will the onboarding be virtual or physical?
- How many days would it take before I get a laptop and start working?

Would you say your job got easier or harder since Covid started?

D gave me a retention bonus just big enough to cover my sign-on, it’s like they’re encouraging me to go on a job search 🤣

“Junior associates, how many hours per week do you spend on work that you think could be automated?”

Anyone currently working at Grubhub? I have an interview coming up and would love to hear other people’s opinions/experiences working on the product design team there. What’s the culture like?

What are the chances of a H1b change of employer getting rejected. Moving from a EY to Mastercard. Considering the reputation & size of the two companies it should be smooth right? Just nervous and want everything to go right.

What would be the salary range for an entry-level CFM Analyst in Federal? Accenture Federal Services. Based in DC

Hi Folks, I have an offer from IBM. They told me that variable component is not written in CTC breakup but you will get some amount each year

Is it so ?

Phantom of the opera on Broadway - is side orchestra worth about 30-40 more than rear mezzanine? What is better experience for this show?

Do we have anyone from Edwards Lifescience? Would love to talk.

Any designers wanna help me out with my portfolio? Everything is done, I just need some feedback to know how to improve it. I'd be very happy if you could help out!

Question on on labor laws in the US:

Received an offer from Amazon but I'm concerned about negotiating hard and ending up with an offer that's on the higher end of the pay band when compared to the rest of the (future) team. My concern is during an economic downturn, it would be easier to let me go if the team needs to be downsized. This would be because I would have the least experience on the team & more expensive to retain from a cost perspective.

My concerns valid? #amazon #aws #faang

I work in tech in DC area with a salary of 110k. I had 1 YOE when I got the job about 6 months ago. My friend gets paid 150k with 2.5 YOE also in tech. What’s a good TC for SWE/DS in DC area with 2 YOE? I’m feeling insecure about my pay

Did Pinterest lift their ban on advertising branded/unbranded pharma? It got brought up in a brainstorm today and almost spit out my coffee...

Can anyone tell me what first year KPMG audit seniors make in the DC area?

What is the leave policy in JP Morgan?

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.

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

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!

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

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 😭

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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 🙏

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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?

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

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

Would anyone be willing to teach me vlookup?

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

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)?

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

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.