I have a pivot table based on a set of sales data. Values are summed correctly for the order (freight, tax, fees, etc). I need to add a column or calculated field on the pivot for quantity. I want quantity summed if the Manufacturer is Dell. All other summed values should not apply this filter. I can't quite get a calculated field to work. Mfg is not a Row. Basically, I only want a filter to affect the Quantity column and none of the other summed columns. Sum Qty where Mfg=Dell. Help!

Anyone here a student at Ross able to answer a quick question about consulting?

Hi

Does anyone know, In citiusTech. Is it possible to shift to different technology..
Currently working in ETL Testing.. I want to shift to Data Engineering domain..
If possible to what will be the process ....

I was platinum lifetime marriott... on the spg app, i now show gold lifetime. That should show Platinum lifetime right?

Are Uber/Lyft drivers reluctant to drive from DC (Logan) to BWI?

In a science middle school classroom, aside from materials manager, secretary, botanist & cleanup... can you think of any other jobs for students?

For those who use via fairly often: do you tip your via drivers?

First business trip in 20 months. TSA agent yelled at me for nonsensical reasons. I almost cried. I was worried things would change, but they are just as dehumanizing as always. Felt like home.

Does someone with a Lufthansa account mind checking for me how many miles I would need for a 1 way business class ticket from HKG to ORD on 7/28?

I would check myself but they require 7,000 miles.

Thank you so much!!!!!

Any one knows the average salary for an inpatient pharmacy operations manager salary in San Francisco?
Thank you!

Hey Folks, can anyone please tell me how long does it take for HR to get back to you for offer discussion after you have submitted all the required documents.

What's salary range for Senior Associate with 8 Years experience in PWC advisory?

What are the pay grades for C's and M's in S&C?

Did you have someone doing hair/makeup for bridesmaids or did you have them do their own? And were you glad you made the decision you did? I’ve been in weddings both ways and trying to decide what I want to do

I’m not a biglaw attorney but have been working on a few matters with Wilson Sonsoni for some time. We have a good working relationship. Didn’t go to a T14, had middle of the pack grades. What’re the odds they’d consider me as a lateral in the Washington DC office? Is it even worth applying? Is a STEM background absolutely mandatory? Any other insights on culture and expectations at WS’s DC office would be appreciated. Thank you 🙏

I've my eb3 priority date of April'19. In how many years could I possibly expect to get my GC realistically?

What is personal independence??
Why Pwc asked me to fill all investment details for me and my dependant.
Can anyone please help me on this ??

@pwc

Does wells fargo has analytics centre in Gurugram or any future plans to open it there ?

Would anyone be willing to teach me vlookup?

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!

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?

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. 😂🤯

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

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

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

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?

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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.

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 🙏

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