Aug 8, 2023 · In excel, I have a table with two columns (and many lines) and I want to return the unique values of both columns into a single column. How can I do that with the Unique …

Nov 30, 2021 · It looks like I don't have the UNIQUE or SORT functions but I have a 365 subscription and all apps are up to date. Anyone know why?[Moved from Microsoft 365 and …

Feb 2, 2020 · Extract unique occurrences in a list, but only if they meet a second criteria Hello Community, I am on Excel 2010 or 2013 (depending on which computer I'm using). I am …

Feb 25, 2024 · 为什么在将 Excel 工作簿中的一个工作表，移动或复制到另一个工作簿中时，会出现这样的提示：Excel 无法将工作表插入到目标工作簿中，因为目标工作簿的行数和列数比源 …

Oct 12, 2021 · I have to create a spreadsheet with 420 random numbers, each with 4 digits, between 1234 and 9876, but no digit can repeat within the 4 digit number - that is each digit in …

Sep 27, 2024 · Dear respected Al Christenson2, Good day! Thank you for posting to Microsoft Community. We are happy to help you. As per your description, to highlight blank cells in a …

Oct 18, 2024 · I am trying to get the formula for excel that will provide a birthdate. Exact year plus months! For example: the child is 1 year and 4 months old I would like the answer to be in 1 …

Aug 26, 2024 · In Excel, click on File -> Account and then you can share a screenshot of the Office version you see under Product Information. If you're sure you're using a version that …

Jun 30, 2024 · I watched an informative video about the GROUPBY and PIVOTBY function in Excel. However, I can't find them. Where are they hiding?

Windows、Surface、Bing、Microsoft Edge、Windows Insider、Microsoft Advertising、Microsoft 365 和 Office、Microsoft 365 Insider、Outlook和 Microsoft Teams ...