This tag is for Microsoft Excel questions where the question or answers are specifically about the structure, syntax, or output of an Excel formula.
When I want to find the last used cell value, I use: Dim LastRow As Long LastRow = Range("E4:E48").…
excel vba excel-formulaI have names in a column. I need to split just the last names from that column into another column. …
excel excel-formula excel-2007I have data in the A and B columns. B column's data is mostly duplicates of A's data, but not …
excel vba excel-formula conditional-formattingI'm trying conditional formatting on a sheet. I need to fill the cells with a certain color according to the …
excel excel-formula conditional-formattingHoping there is a way this can be done with a formula since I will be putting this on SharePoint …
excel excel-formula excel-2007I've setup a simple =QUERY statement that will pull targeted rows/columns out of a 'response' sheet and put them …
google-sheets excel-formulaI am trying to set up a function to reformat a string that will later be concatenated. An example string …
excel excel-formula nested substitution nested-functionI use the SUM(B1..B20) formula to sum a column, but when I filter the data by an adjacent …
excel excel-formulaI am trying to split a string in an excel formula, something like I can do in many programming languages, …
excel formula excel-formulaIn Excel we have the VLOOKUP function that looks for a value in a column in a table and then …
excel excel-formula excel-2003