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 …

为什么在将 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 …

Aug 11, 2010 · Formula is actually counting unique number values, then the MOD function alternates between even and odd. For other unique value counting formulas, check out the XL …

Jul 3, 2025 · Hello, Please bare with me on this I am not a pro, just a hobbyist. I am using a lookup function to find a value on a table that is a result of input values. =VLOOKUP …

Microsoft Community

May 17, 2022 · Auto Series Option in Excel for office 365 Can't find the Auto Series Option button in the online Excel. This function allowed me to fill columns with dates for weekdays only, …

Nov 29, 2020 · Dear Simon, It is because in column A of the first sheet, the values are saved as text. The other 2 sheets contain number values, not text values. So, lookup function can't map …