This tag is for Microsoft Excel questions where the question or answers are specifically about the structure, syntax, or output of an Excel formula.
I am trying to count the number of times a sub-string appears within a column of string data in Excel. …
excel excel-formulaHow do I get a nested 'AND' to work inside 'IF' in an array formula? I reduced my problem to …
excel excel-formula array-formulasI have a simple problem that I'm hoping to resolve without using VBA but if that's the only way it …
excel vba excel-formula worksheet-functionI imported a few thousand rows of data into Excel and whereas one item represented one row, I've had to …
excel excel-2007 excel-formulaI have data of program usage in excel file, the data has date and time. I want to summarize this …
excel excel-2007 excel-formulaI have a couple hundred of cells in Excel I would like to concatenate into a single string. Is there …
excel excel-formula concatenation string-concatenationI am trying to work out a formula that will give me the row number of the first empty cell …
excel excel-formula match cellI am wondering if there is any way to represent infinity (or a sufficiently high number) in MS Excel. I …
excel excel-formulaThe vlookup function appears to be broken. It is returning the same value for all lookups, but it should not. …
excel excel-formula vlookupWhat I have: 1 Col A Col B Col C Col D Col E Col F 2 3 Approved Text Text Text Text …
excel excel-formula worksheet-function conditional-formatting