Can't unhide a column | Microsoft Community Hub
Jun 20, 2018 · Windows 10 My column C which I hid last week now won't unhide. I've tried right-clicking unhide, select all unhide, visibility, reformatting all the...
Filter Two Columns in a worksheet with the same value
Jun 5, 2023 · Diamond Contributor to PhilipP1055 Jul 12, 2024 PhilipP1055 Please check How to use Advanced Filter in Excel - criteria range examples with formulas (ablebits.com) Filter by …
DATE IN SPANISH | Microsoft Community Hub
Oct 15, 2018 · In my new laptop, using the same excel and the same template, the funtion TEXTO(A6,"ddd dd mmm") returns the name of the day in english ("Sunday", etc) and I...
Click on a cell to open worksheet | Microsoft Community Hub
Hi All,Is there a way, without using VBA, where I can click on a cell, which opens another worksheet. The answer to that complex calculation on that new or...
sum by color when colors are set by conditional formatting
Dec 20, 2016 · You cannot count colors assigned by conditional formatting, as these cells are effectively still the default background color! Why not just count these cells based on the …
NEED HELP: How To Select All Values Greater than 0 with Find and ...
I am having trouble using the find and replace tool. I am trying to select all values greater than 0 and replace them all with 1 to create a binary in a...
Excel Data Validation using regular expressions | Microsoft …
May 5, 2022 · Excel Your community for how-to discussions and sharing best practices on Microsoft Excel. If you’re looking for technical support, please visit Microsoft Support Community.
VBA Excel Macro - Picture attached to Cell (insert) - Not link
Dec 2, 2020 · I'm looking to simply run a macro that finds a picture's location in one cell and then insert the picture into another cell. But it has to be attached to a...
Formula for tracking service intervals on running equipment
Greetings, all. I've been tasked with creating a live service interval tracking formula for our onsite equipment. I have current hours, and...
Convert week of the year into a date | Microsoft Community Hub
Jul 1, 2022 · Please check here Excel WEEKNUM function – convert week number to date and vice versa (ablebits.com) It also depends on how do you count weeks - by ISO of from 1st Jan, …