What does -- do in Excel formulas? - Stack Overflow
Jul 20, 2010 · What does -- do in Excel formulas? Asked 15 years, 6 months ago Modified 6 years, 8 months ago Viewed 57k times
What are the RGB codes for the Conditional Formatting 'Styles' in …
I've got some cells that I have Conditionally Formatted to Excel's standard 'Bad' Style (Dark red text, light red fill). In another column I have cells that I have created a Conditional Formatting …
Quadratic and cubic regression in Excel - Stack Overflow
Jun 2, 2012 · Now Excel will calculate regressions using both x 1 and x 2 at the same time: How to actually do it The impossibly tricky part there's no obvious way to see the other regression …
Referencing value in a closed Excel workbook using INDIRECT?
In the formula, E:\Excel file\ is the full file path of the unopened workbook, test.xlsx is the name of the workbook, Sheet2 is the sheet name which contains the cell value you need to reference …
excel - Test or check if sheet exists - Stack Overflow
Jul 14, 2011 · Dim wkbkdestination As Workbook Dim destsheet As Worksheet For Each ThisWorkSheet In wkbkorigin.Worksheets 'this throws subscript out of range if there is not a …
Excel FILTER() returning 0 for blank cells - Stack Overflow
Nov 10, 2020 · I suspect this has been asked previously, but I can't find it. FILTER() will often return a 0 for blank rows, even when a return string is specified. Using filter() I am often getting …
excel - Check whether a cell contains a substring - Stack Overflow
Sep 4, 2013 · Is there an in-built function to check if a cell contains a given character/substring? It would mean you can apply textual functions like Left/Right/Mid on a conditional basis without …
How to represent a DateTime in Excel - Stack Overflow
Jun 11, 2009 · What is the best way of representing a DateTime in Excel? We use Syncfusions Essential XlsIO to output values to an Excel document which works great. But I can't figure out …
What does the "@" symbol mean in Excel formula (outside a table)
Oct 24, 2021 · Excel has recently introduced a huge feature called Dynamic arrays. And along with that, Excel also started to make a " substantial upgrade " to their formula language. One such …
Parsing an ISO8601 date/time (including TimeZone) in Excel
I need to parse an ISO8601 date/time format with an included timezone (from an external source) in Excel/VBA, to a normal Excel Date. As far as I can tell, Excel XP (which is what we're using) …
Skip to content