Last seen: Jul 3, 2025
Hi Scotty, You cannot use formulas in this situation, you will have to control what happens only with macros. Use Worksheet_Change event to detect ...
Hi, Sounds like you want the ISO Year. Try: =YEAR(DATE(YEAR(A1-WEEKDAY(A1-1)+4),1,1)-MOD((DATE(YEAR(A1-WEEKDAY(A1-1)+4),1,1)-2),7)+(7*IF(...
Chris Yap said 123, 345 and 998 should return "No", basically only Chris Yap said 898 is return No 898 returns no, but it was not in the list ...
Ok, I understand that 998 should return no, but why 898 should return yes? Add a new column with this formula: if List.Count([Grouped][User ...
Chris Yap said and how to incorporate the OR, that is the following conditions fulfilled "Everyone" "UserDomain users" "Everyone" and "UserDomain us...
Hi Chris, When you click the button to add new column, in the dialog window that shows up you should paste only the formula, not the entire step sy...
Use List.Contains. If you refer to a single column from a table, that is a list, you can use List functions on that column: = Table.AddColumn(#"Add...
It's not available yet in Excel Power Query. But you can try opening the PDF files in Word (Open With word, Word app will try to convert the PDF to...
item Number 1 has a value of 2 in the Duplicate Count column, but that number can be found only once in Sheet2, can you clarify? Is the vba solutio...
A credit card should be entered as text, excel works only with numbers up to 15 digits, any digit after 15 digits will be replaced with 0. Most likel...
Hi Jim, Don't be afraid to try, if you think Pivot Column should work. It will not work, because Grouped column has tables, not values. If you c...
Your attempt to Expand columns is not dynamic. If you will have 10 columns for a specific user, the query will not reveal them because the columns you...
You can count before or after expanding the table, does not matter, see attached file.
If you cannot set the start date to a wednesday, then you will have to perform a few extra steps: -Add a new column named Custom.1: = Table.AddColu...
Hi Allison, Add an Index column, starting from 1, then a column with this formula: =Number.RoundUp([Index]/7,0) Make sure your calendar start...