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 have a column of values that often appear as duplicates. I need to create a new column, of unique …
excel excel-formula excel-2010I have an Excel sheet with first names in Column A and surnames in Column B. I want to create …
excel excel-formulaI have an Excel spreadsheet containing a list of strings. Each string is made up of several words, but the …
excel excel-formulaDo you know a way in Excel to "calculate" by formula a list of unique values ? E.g: a vertical …
excel excel-formulaIs it possible to iterate (loop) a group of rows in Excel without VBA or macros installed? A web search …
excel excel-formulaIn a cell in Excel sheet I have a Date value like: 01/01/2010 14:30:00 I want to convert that Date to Text …
excel excel-formulaIs it possible to declare variables in Excel cells and use them as parameters for formulas in other cells? For …
excel excel-formulaI have an Excel file which has a column formatted as date in the format dd-mm-YYYY. I need to convert …
excel excel-formula worksheet-functionIs there an efficient way to identify the last character/string match in a string using base functions? I.e. …
excel excel-formulaI need help on my Excel sheet. How can I declare the following IF condition properly? if A1 = "n/a" …
excel excel-formula