Microsoft Excel Customer Service Issues

I am attempting to organize a pivot table by month and want the rows to stack instead of repeating the month names. I have designated "Month" in the column row and placed the numerical columns in the Values section. Currently, the two values are displayed side by side for each month. I am uncertain if I need to adjust the data structure or if there is a pivot setting I can change to exhibit the two columns row by row per month rather than individually listed out.

I have a named range called Reg_type (C9:CX9) in my workbook. I've successfully created a process using VBE that ensures all cells in the range are valued before closing the workbook, by setting Cancel=True initially. Now, I am attempting to implement an IF statement in my process to check if the named range C9:CX9 is not empty before closing. I want to confirm if it's possible to check multiple cells within a named range.

Yesterday evening, there was an unexpected upgrade to my Outlook [redacted], which seems to have caused an issue with my Excel document. Despite having Autosave activated, the document reverted to its state from mid-November after the system restart, resulting in the loss of a month's worth of entries. I have attempted to follow online recovery instructions without success. How can I retrieve the missing data from the Excel file?

Hello, I am using Excel [redacted] and need assistance with a formula. I have one Excel sheet containing three tabs: sheet 1, sheet 2, and Output sheet. All sheets have the same three columns: material, price, and vendor. The goal is to compare the material costs between sheet 1 and sheet 2 and return the least price in the Output sheet along with the corresponding supplier name. For example, if in sheet 1 material ABC costs $10 (supplied by XYZ) and in sheet 2 material ABC costs $11 (supplied by TPC), I want the Output sheet to display ABC with a price of $10 and the vendor name as XYZ. I have attached a file for reference. I am looking to apply this formula to the entire sheet with thousands of items, so any help would be appreciated. Thanks, MBQ

It is crucial to convey to the client the importance of adhering to scheduled timelines. While we commit to meeting all deadlines, clients must also meet approval and comment due dates. Failure to do so can result in adjustments where task durations are shortened or due dates are extended. The desired outcome is to maintain the final due date while shortening task durations. To illustrate, in the provided spreadsheet, C represents due dates, F represents approval and comment due dates, and B represents task duration. C6 = C4+42 C7 = C6+16 F7 = WORKDAY(C7, D7) C9 = F7+B9 B9 = 21 It is important to note that C4 marks the kickoff meeting, while C36 signifies the final due date that must remain unchanged. In the scenario where F7 is missed by 5 days, adjustments should ideally be made to B9 rather than C9, as C9 = F7+B9. Implementing a formula across all B cells could automate this adjustment but identifying the specific formula remains unclear at this point.

I am encountering an issue while trying to create a series of automatic dependent drop-down lists in Excel. Despite following the necessary steps to set up the dependent drop-down list and applying Excel Data Validation with the "=INDIRECT()" formula, I am unable to populate the list when clicking the down arrow key. While I successfully created a main drop-down list, my aim is to link the data to the dependent lists for a cohesive display. For instance, my main list is "VENUES," and I desire subsequent columns like Addresses, Rooms, Square Footage, etc., to dynamically show information corresponding to the selected venue. I appreciate any suggestions you can offer to resolve this problem.

My Microsoft subscription expired, so I decided to buy the Business Premium with a one-month free trial. I hadn't downloaded the offline Excel sheets yet. While working on an Excel sheet offline, I needed to share a Microsoft sharable link with a co-worker. This prompted me to install Microsoft Office for offline use. When I returned to my Excel sheet, it was missing, and I can't locate it. The sheet contains crucial information. I did attempt to save it, but I'm uncertain if it saved correctly since Microsoft Office wasn't installed at the time. Can you advise on how to recover this important sheet?

I have six Excel datasets, each with about [redacted],[redacted] lines of data and 8 variables. I created 18 x-y plots (three variables per dataset) that I need to share with my client. Since the plots are too large to send with the linked data, I want to save each plot as a picture and email them. I discovered a workaround by selecting the plot, printing it, scanning it, and then sending it via email. However, after doing this three times, every time I hit "Print" in Excel, the program stops responding and remains unresponsive until I shut it down and restart it.

Dear Sirs, I have recently dedicated approximately twenty hours working with my secretary on filling out numerous Excel Spreadsheets, meticulously entering various numerical values into their respective categories. However, we have encountered an issue when attempting to sum up these values using the Excel [redacted] software. Despite pressing the addition button, the software does not respond to our requests for the columns to be added together automatically. The Excel Spreadsheets were carefully saved on my Office Computer, and my secretary diligently input all the values as per my direction. It seems that the automatic addition function within the software is not functioning as anticipated, causing a delay in our calculations. Please assist in resolving this matter promptly so that the sums of the numerical values entered can be computed seamlessly. Thank you for your attention to this matter. Best regards, Caleb Boone

I have a data table with columns A-G, but I'm only interested in columns A and F. Column A contains item names, and column F has their respective prices. I want to create multiple tables based on price ranges (e.g., Table 1 for items $0-$5, Table 2 for items $5-$10, Table 3 for items $10-$15, etc.). I've tried adapting a formula but noticed that some items outside the specified range are still included in the tables. Here's the formula I've been using: =IFERROR(INDEX(DataTable!$A$4:$A$[redacted],SMALL(IF((DataTable!$F$4:$F$[redacted]>=$A$1)*(DataTable!$F$4:$F$[redacted]<=$B$1),ROW(DataTable!$A$4:$A$[redacted])),ROW(1:1))-0,1),””) In this formula, $A$1 and $B$1 represent the price range boundaries (in this case, $A$1=5 and $B$1=0). Can anyone help me identify where I might be making a mistake? The formula seems to be partially effective, but some items above $5 are still being included erroneously.

I have been utilizing shared MS Excel workbooks via Office [redacted] OneDrive. Until yesterday, my partner and I could simultaneously work on a file from different locations with complete functionality. However, as of today, we are unable to change the text color within a cell partially; it only allows us to alter the entire text to a single color. Previously, we could modify part of the text in a cell to different colors. Presently, only one of us can do this if we open the file as a desktop file, not on the cloud as we did before. How can we resolve this to both work on the same cloud file simultaneously and retain the full functionality to change partial text within a cell to different colors as we could previously?

I have a cell in an Excel workbook with a lot of text. I merged and centered the information and wrapped the text across multiple columns due to its length. However, now when I view the cells on the screen, all I see is a series of pound signs "#####", rather than the text. When I hover over the cell, I can still see the text, but it does not display properly on the screen.