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 function? When I use …

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 Office / Subscription, …

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 the number …

May 5, 2025 · I need help with an Excel Date formula. In cell 1, I have a date; in cell 2, I enter a "V"; in cell 3, I enter a state name; in cell 4, I have a date that adds 365 days to another cell's date.

Nov 28, 2018 · Consolidate works for one worksheet but does not work on the other. Not trying to consolidate both sheets. Each sheet contains unique data. Trying to consolidate the data from each …

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 extracting a …

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?

Oct 26, 2021 · =IF (INDIRECT and ISBLANK Functions Hello! I could sure use some help tweaking the =IF (INDIRECT function in one of my Excel worksheets. My workbook has worksheets that track my …

Sep 19, 2024 · So my requirement is match search text in cell E1 in column A range and extract nearest due date to today's date from column C range. What function will give desired results, without VBA …

锁定的问题。 此问题已从 Microsoft 支持社区迁移。 你可投票决定它是否有用，但不能添加评论或回复，也不能关注问题。