What is this Madness? Weird Average and Sum results
What is this devil math? What am I missing? The darker green value and blue value should match. I checked for truncated decimal values, even rebuilt the sample to ensure nothing was weird about the original cells. This is not an insignificant difference for what I'm doing, and I don't understand why these aren't lining up. I'm sorry if I'm missing something simple, but please, help!
Cross Referencing Data in Excel
Hello, I have a spreadsheet that lists document numbers that are stored in a document management system. I have to cross reference the documents in that management system, which means I have to go into each individual document in the management system and add in all the documents where that individual document is referenced. The attached spreadsheet lists all the documents in our system (column B) and each document where they are referenced (columns C-AP). Is there a way to have Excel search columns C-AP, find a specific value, and provide me with a list from column B where that value is found in columns C-AP?
Combine data from 2 columns into 1 column
I want to do this, but with 2 columns of data. We have a sheet with area codes in one field and phone numbers in another. I need the 2 pieces of data in one field for a list of 500 phone numbers. Do I have to do them one at a time???? Combine data with the Ampersand symbol (&) Select the cell where you want to put the combined data. Type = and select the first cell you want to combine. Type & and use quotation marks with a space enclosed. Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2.
Excel 365 is UNUSABLE for professional work — performance has catastrophically degraded
Subject: Excel 365 is UNUSABLE for professional work — performance has catastrophically degraded I am a financial professional running 67 equity valuation models in Excel. These are serious, production-grade workbooks with time-series charts, shapes, annotations, and financial data — the exact kind of work Excel is supposed to be built for. And your software can no longer handle it. Here is what is broken: — Moving a simple shape (a circled number annotation) across a worksheet takes SECONDS. This is not a complex object. It is a circle with a number in it. — Scrolling is laggy and jerky, even on sheets with minimal data. — Pressing ALT to activate ribbon shortcuts has a delay so severe that subsequent keystrokes are DROPPED. I have to sit and wait for your UI to catch up before I can use keyboard shortcuts I've relied on for over a decade. — Selecting and editing cells is noticeably slower than it was two years ago. — Interacting with comments is painfully slow. — Chart objects are sluggish to select, move, or resize. Here is what I have already tried — NONE of it helped: — Disabled hardware graphics acceleration via registry (since you REMOVED the checkbox from the UI without telling anyone) — Updated NVIDIA graphics drivers to the latest version — Disabled ALL add-ins and tested in Safe Mode — SAME PROBLEM — Rolled back Office builds from Version 2603 to 2602 to 2512 — SAME PROBLEM — Disabled all Windows visual animations — Ran Excel in Safe Mode — SAME PROBLEM Do you understand what that means? The problem is not my hardware. The problem is not my add-ins. The problem is not a specific update. The problem is EXCEL ITSELF. You have systematically degraded the performance of the most important business application on the planet in order to ship a prettier UI that nobody asked for. Your Fluent visual refresh, your new rendering pipeline, your animations and transparency effects — all of it has come at the direct expense of the people who actually use Excel for real work. I am paying for a Microsoft 365 subscription. I am not paying to be a beta tester for cosmetic changes. I am paying for a professional tool that is supposed to WORK. I need you to: 1. Acknowledge that Excel 365 has a serious rendering and input performance regression affecting workbooks with charts and objects. 2. Provide users with the ability to fully disable the Fluent visual refresh and revert to the classic rendering engine — through the UI, not through undocumented registry hacks. 3. Restore the "Disable hardware graphics acceleration" checkbox that you removed from Options without explanation. 4. Prioritize PERFORMANCE over aesthetics. Excel is a financial tool, not a design portfolio. 5. Actually test your updates against complex, real-world workbooks with multiple charts, shapes, and annotations before shipping them. I have 67 valuation models that are materially slower today than they were on Excel 2016. I am now seriously evaluating whether to abandon my 365 subscription entirely and move to Office 2021 — or leave the Microsoft ecosystem altogether. That should alarm you. This is not acceptable. Fix it.
