excel
44453 TopicsHow to count duplicates ... sort of ...
Greetings! Here is part of a table that I am working on: RepairID ModelID Serial Number Date Started Date Tested ReportedSymptom SPEA-1010 PT206 8FA552 10/22/2025 10/28/2025 No Boot - White Screen SPEA-1024 PT206 8FA552 10/22/2025 11/4/2025 No Boot - White Screen SPEA-1037 PT206 7C99BD 10/22/2025 11/10/2025 EGM No Comms SPEA-1038 PT206 715473 8/21/2025 EGM No Comms SPEA-1039 PT206 715473 11/10/2025 11/11/2025 Failed Battery Test SPEA-1056 PT206 7142AE 10/20/2025 11/12/2025 Black Screen SPEA-1057 PT206 71584F 10/20/2025 11/12/2025 Black Screen SPEA-1144 PT206 7142AE 11/24/2025 11/24/2025 No Boot - Black Screen I am trying to count the number of repairs based on serial number in this table. But there are some duplicates. However, if you look at the rows with red font, you will see that the serial numbers, though they are the same, were not being repaired for the same reason. So, these need to be counted as 2 separate repairs. If the repairs to the same serial number are for the SAME symptom, we only count it once. What would be a good approach to creating a function that will count this into a cell on a separate table? Any assistance would be greatly appreciated.7Views0likes1Commentmerge cells
I have a table with dozens of rows and seven columns. Each column (B through H) contains a two-digit number in txt format because I want to retain the leading zeros. I'm having trouble merging the different numbers from columns B through H into a separate cell (column A). The goal is to merge each individual row (columns B through H) into the same row in column A. A B C D E F G H 12345678909854 12 34 56 78 90 98 54 65432109870203 65 43 21 09 87 02 03 … None of the formulas provided in Excel (Microsoft Office LTSC Professional Plus 2021) help. Do you have a solution? Thanks in advance.7Views0likes1CommentHow to sum chain values from N-number cells?
Hello, I have data of people by age, but 100 different values on a line chart would look... bad. Hence the need to group ages in sets of 5 or 10 on a separe line in chain, but what is the function to do this? It certainly isn't the humble SUM function, since it moves the range by one, producing "1 the problem". Sure, I could do the SUM chain and delete four cells between keepers, yielding "2 the problem", but that's just awful. Or I could do "WHAT I SEEK" manually, if I had an enernity... Thanks in advance, and have a wonderful day!12Views0likes1CommentVBA code to allow dropdown box multiple selection
Hi all, Is there an option to allow multiple selections of a dropdown box within excel? the dropdown would be in column V (v2 downwards, and the list is in tab “Entities” from a2 down to a6. the codes I have tried from online either didn’t allow me to remove a selected item, or when I did remove it and try to select others I ended up with “floating” commas. Ie it went from “apple, pear, banana” to “,pear ,” and I couldn’t remove the commas. thanks16Views0likes1CommentIntroducing the new Get Data dialog in Excel for Windows
We are excited to announce a first step towards modernizing Power Query in Excel for Windows - a new way to connect to data that will make finding and using external data sources faster and more intuitive! The modern Get Data dialog gives you a clean, simple starting point for connecting to data. With built-in search and quick access to popular data sources, you can easily find the right source and start working on your data. How it works Select the Data tab on the ribbon, then select Get Data > Get Data (Preview) to open the new dialog. Browse through popular data sources on the Home tab or use the search bar to find a specific source. Select the New tab under the categories list on the left to browse through all available data sources. What it does When you open the modern Get Data dialog, you’ll be able to search for the connector you need or pick from recommended options—all in one clean view. When you select a source, Excel takes you straight into the familiar, current Power Query import flow and you’ll be able to see the same steps you know today. For more information, check out modern Get Data Dialog in Excel for Windows. Note: You can still import external data from the Get Data dropdown categories as well as from the new Get Data dialog. More to come The new dialog is the first step toward a modernized Power Query experience in Excel, paving the way for upcoming innovations like modern import flows and a modern Power Query editor. In addition, you’ll see more modules integrated into this dialog soon, making it easier than ever to discover, connect, and prepare your data. Availability This feature is gradually rolling out to M365 subscribers in Excel for Windows, with Version 2509 Build 16.0.19328.20000 or later. Feedback We’d love to hear about your experience with the modern Get Data dialog. Let us know: ✔️ Did the overall experience feel intuitive and helpful? ✔️ Which new additions would you like to see? Just click on the 🙂button in the upper right-hand side of the dialog to share your feedback. Your feedback helps us refine the experience and prioritize what’s next.520Views2likes3CommentsWhat's New in Excel (November 2025)
Welcome to the November 2025 update. This month, we’re excited to share several enhancements across Excel. Announced at Ignite, Agent Mode in Excel now includes web search and Anthropic model support, and is available in Excel for Windows—via the Frontier program. Excel for Windows introduces a modernized Get Data dialog, providing a clean, simple starting point for connecting to data. Additionally, users on Windows, web, and iOS can preview comments on protected files directly in email notifications. For Insider users, Excel for iOS adds Liquid Glass styling and template filters, introducing a new, modern home experience. Excel for Windows: - Agent Mode in Excel enhancements (Frontier) - Get Data dialog Excel for Windows, web, and iOS: - Comment previews on protected files #FIA Excel for iOS: - Liquid Glass and template filters (Insiders) Excel for Windows Agent Mode in Excel enhancements (Frontier) 1. Web search. At Ignite last week, we introduced web search in Agent mode. Imagine pulling real-time information from the web straight into your spreadsheet workflows—market trends, historical stats, scientific figures—without juggling browser tabs or copy/pasting from a chat window. For example, you can ask Agent Mode to compile the latest GDP growth and CO₂ emissions data for G20 countries or create a table of this year's Nobel Prize winners with detailed attributes. Copilot can now pull this data from trusted sources into Agent mode's multi-step workflow and build directly in your spreadsheet, saving time and reducing manual effort. Plus, it supports citation links for transparency so you can have confidence in the output. This integration is perfect for analysts, researchers, and anyone who needs up-to-date external data to make informed decisions. 2. Anthropic model support. Choice matters, and we are committed to providing multi-model options in Microsoft 365. Building on Researcher agent and Copilot Studio, Agent mode now offers an option to choose Anthropic’s Claude models to power your experience. Just choose the "Try Claude" option to get started. For enterprise users: your admin must allow access to Anthropic AI models. Learn more about using Claude in Agent mode in Excel. Claude brings a different approach to spreadsheet generation offering a distinct experience from the default OpenAI models powering Agent Mode. While Claude streams its chain-of-thought and explanations differently, ongoing improvements aim to deliver a smooth experience in this early preview. This flexibility ensures you can pick the model that best fits your needs—whether it’s speed, accuracy, or style. 3. Now available in Excel for Windows. Last month, we introduced Agent mode in Copilot in Excel for Web through the Frontier program. At Ignite, we announced that Agent mode is now available in Excel for Windows too, making AI assistance available for users and professionals who rely on Excel in the desktop app for their work. While Mac support is planned for later, Windows users will benefit immediately from this rollout. Users must be in the Insiders Beta Channel on Windows. Get Data Dialog The modern Get Data dialog gives you a clean, simple starting point for connecting to data. With built-in search and quick access to popular data sources, you can easily find the right source and start working on your data. This feature is currently rolling out to Windows Current Channel users. Read more here > Excel for Windows, web, and iOS Comment previews on protected files #FIA Excel now lets you preview comments on protected files directly from your email notifications. When someone adds a comment, the email includes the comment text and its context within the file, so you can quickly review feedback without unlocking or opening the document. Excel for iOS Liquid Glass and template filters (Insiders) Your favorite Microsoft 365 apps on iPhone, iPad, and Apple Vision Pro now feature Liquid Glass styling. We’ve also made the search experience available from the bottom of the screen, to align with iOS 26’s search patterns and make it easier to use with one hand. When searching for templates, you’ll now also see quick filter buttons at the top that let you browse by category – like Flyers, Resumes, or Invoices – instead of scrolling through a single long list, so finding the perfect template is faster and more intuitive. Read more here > Check if a specific feature is in your version of Excel Click here to open in a new browser tab Many of these features are the result of your feedback. THANK YOU! Your continued Feedback in Action (#FIA) helps improve Excel for everyone. Please let us know how you like a particular feature and what we can improve upon—"Give a compliment" or "Make a suggestion".. You can also submit new ideas or vote for other ideas via Microsoft Feedback. Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on X, formerly Twitter. Special thanks to our Excel MVPs David Benaim, Bill Jelen, Alan Murray, and John Michaloudis for their contribution to this month's What's New in Excel article. David publishes weekly YouTube videos and regular LinkedIn posts about the latest innovations in Excel and more. Bill is the founder and host of MrExcel.com and the author of several books about Excel. Alan is an Excel trainer, author and speaker, best known for his blog computergaga.com and YouTube channel with the same name. John is the Founder & Chief Inspirational Officer at MyExcelOnline.com where he passionately teaches thousands of professionals how to use Excel to stand out from the crowd.142Views0likes0CommentsExcel bug Data sorting largest to smallest
I have some problems by sorting data in excel. First sorting by column M Largest to Smallest, than by column L also Largest to Smallest. In one case sorting is not successfully (Marked font color RED). Can someone explain this to me? https://drive.google.com/file/d/1n_IWsw9YH6FDxXnFm_wWwJEVQIN9AxRu/view?usp=sharing125Views0likes5Commentsi need the data from all the sheets in the workbook to link to one data sheet.
A colleague of mine made a data spreadsheet (lets call it SHEET 1), he no longer works for the company and over time the worksheet has been amended, so doesn't work like it should. There are several sheets in the workbook and all data that is copied into these needs to go into SHEET 1 (doing it itself, not manually). My question is when I download my data and paste into SHEET 2, how do I get it to automatically go on to the SHEET 1, taking only certain parts of the data, in this case B and F. The attached is just a small example of the data I need from SHEET 2. On SHEET 1 There is a list of numbers on the left and more, how can I get this data to filter itself onto SHEET 1 in the right column then adding the numbers on the left together. So, on SHEET 1, 160 -T will show 7 because there is 7 1's below for that Org. Sorry if i have made this sound long winded, I am awful at explaining. I have basic knowledge of excel but I cannot get my head around formulas. It should look something like this. Any advice would be great. Thanks95Views0likes2CommentsInserted Excel spreadsheet in Word not updating with added rows
Hi, I have inserted an Excel spreadsheet into my Word document via Insert --> Table --> Excel Spreadsheet. The contents of this spreadsheet show up in my Word document. However, if I insert a new row in Excel, while the row's contents show up and save in the Excel file, they do not appear in the Word document. This seems to be happening particularly if the new rows are added towards the bottom of the table. I cannot figure out why this is happening and there is plenty of space in the Word document for the new rows to appear. I have tried expanding the size of the table in Word and still no luck. Any assistance would be appreciated. Thank you.47Views0likes2Comments