Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagWorking with tables in Microsoft Excel Ever used Format as Table in Microsoft Excel? Did you know Format as Table can be a whole lot more than just fancy formating? Join MVP Jan Karel Pieterse as he discusses working with tables and how they can help you in your everyday work with Excel. Sign in to our Excel Community and watch now. Jan Karel Pieterse is the owner of JKP Application Development Services (jkp-ads.com). Jan Karel develops custom solutions in Microsoft Office and is a top expert in Microsoft Excel and VBA. Jan Karel has been granted the Microsoft MVP Award for each consecutive year since 2002 for his outstanding community work in newsgroups, forums and publications. Jan Karel lives in the Netherlands. Welcome to your Excel discussion space! If you’re looking to ask a question or start a conversation about Excel, you’re in the right place! Ask away. Please include your Excel version, sample file, and a bit of context to help others answer your question: Device and OS platform, e.g., PC/Windows 10 (see Which version of Windows operating system am I running?) or Mac/macOS Big Sur 11.2.1 (see Find out which macOS your Mac is using) Excel product name and version number (see About Office: What version of Office am I using?) Excel file you’re working with or sample file with data – please remove all confidential and PII data As much context of what you're trying to do - and why - as possible, e.g., how what you're trying to do fits into what larger process or workflow Expected result and method to achieve the result Once you got a good answer to your question, please accept it as solution to help others looking for answer to the same/similar question. Thanks! *Kudos to mathetes Twifoo mtarler for contributing to this welcome message Re: If conditional multiplicationI understand this was a known issue that's been fixed. Please let us know otherwise.Re: Bug ReportingPlease see https://support.microsoft.com/en-us/office/how-do-i-give-feedback-on-microsoft-office-2b102d44-b43f-4dd2-9ff4-23cf144cfb11Re: A question about Microsoft's password management systemHoping someone in this Tech Community forum can help.Re: "Correct highlighted errors" but there ain't anyThanks mathetes for flagging this. I haven't seen this myself. However, that doesn't mean it's not an issue necessarily. I'm going to try reposting your question to https://techcommunity.microsoft.com/t5/community-lounge/ct-p/Community-Info-Center to see if someone there can help.Re: excelCan you change the chart type to a bar chart and share what it looks like?Re: Introduction to Data Analysis using ExcelThanks for letting us know. We updated the link.Re: Corrections and additions to Support Microsoft com Listing of All Functions Norman_Harker Thank you! I heard from the doc team over the weekend. They are working through your feedback - thank you. At the same time, they are focused on updating over a thousand support articles for the next perpetual release of Office LTSC - see Upcoming commercial preview of Microsoft Office LTSC | Microsoft 365 Blog for more info on this release. We really do appreciate your feedback. Please keep them coming. We are working through them. Re: Corrections and additions to Support Microsoft com Listing of All Functions Norman_Harker thanks for the follow up. Let me check with the team on the status of updates. Appreciate your staying on top of it. Have a great weekend! Re: Run chartsPlease try https://templates.office.com/en-us/Run-chart-TM16400683 HTHRe: Corrections and additions to Support Microsoft com Listing of All FunctionsThank you, Norman_Harker. I've shared your list with the team. Have a great weekend! Cuong (MSFT) Re: Corrections and additions to Support Microsoft com Listing of All FunctionsHi Norman_Harker, Thank you so much for putting a list as such! Please share it with me here or send me a direct message and I will make sure it goes to the right team to review and make corrections as appropriate. Warm regards, Re: frequencyDoes this help? https://support.microsoft.com/en-us/office/frequency-function-44e3be2b-eca0-42cd-a3f7-fd9ea898fdb9Re: How to report an error on an Excel help page on the web? Thanks for catching this alfranco17. I've shared your feedback w/ the team. Re: Counting unique posts in a table with multiple conditionsDoes this help? https://support.microsoft.com/en-us/office/count-unique-values-among-duplicates-8d9a69b3-b867-490e-82e0-a929fbc1e273?ui=en-us&rs=en-us&ad=us#:~:text=Let's%20say%20you%20want%20to%20find%20out%20how,two%20unique%20values%C2%A0%E2%80%94%20%22Bradley%22%20and%20%22Doyle%22.%20See%20MoreRe: frequencyCan you share an example of what you're trying to do?Re: merging on excelHave you tried XLOOKUP? https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929Re: Help!!!!Can you mock up the end result of what you're looking for?Re: Excel - create average from indirectDoes this work? =AVERAGE(Form!B:B)
Recent Blog ArticlesNewest TopicsMost LikesTagged:TagMeet Niko Chatzoudis, Excel Forum Contributor Meet Niko Chatzoudis who believes in not only helping the user but also delighting them Excel MVP Blog Roundup Check out this week's latest from Excel MVPs Chandoo and Jeff Lenning Excel MVP Blog Roundup Check out the latest from Excel MVPs Ajay Anand, Mourad Louha, and Ismael Romero Excel MVP Blog Roundup Check out the latest from Excel MVPs Leila Gharani, Bill Jelen, and Cristiano Galvão Spreadsheet Day Celebration - Oct 14, 5 PM ET Spreadsheet Day Celebration - Oct 14, 5 PM ET - hosted by the Toronto Excel User Group Excel MVP Blog Roundup Check out these blog articles by Excel MVPs Paula Guilfoyle, Ron de Bruin, and John MacDougall Excel MVP Blog Roundup Check out these blog articles by Excel MVPs Charles Williams, David Abiola, and Yolanda Cuesta Excel MVP Blog Roundup Check out these blog articles by Excel MVPs Mynda Treacy, Tony de Jonker, and Alan Murray Microsoft Excel at Ignite 2020 Experience a reimagined Microsoft Ignite as a digital event this year, Sep 22-24. This year, we’re excited to share our modern Excel story in the context of insights, collaboration, hybri...Excel MVP Blog Roundup Check out these blog articles by our Excel MVPs Chandoo, Jan Karel Pieterse, and Jeff Lenning
MicrosoftMicrosoftMicrosoftMicrosoft
