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 get a SUMIFS formula to check a column of dates and sum only the values that …
excel date excel-formula sumifsThis is probably quite a basic thing to do, but I've been looking around the internet and have tried several …
excel excel-formula worksheet-functionI have a problem that should be so simple, but I'm not getting my head around it. I do printed …
excel-2007 excel-formulaI want to categorize numbers from [0:15] into 5 classes: A, B, C, D, E, F Rules: 0-1: Class A 2-4: Class …
excel excel-formula vlookup worksheet-function multiple-conditionsI would like to split all words in my cell by Uppercase, an example: Original values: MikeJones RinaJonesJunior MichealSamuelsLurth Expected …
regex vba excel excel-formulaI need to scrub a column of names in Excel to eliminate all non-Alpha characters including periods, commas, spaces, hyphens …
excel excel-formula substitution excel-udf vbaI am looking for a simple way in Excel to calculate with units of different values. I have a list …
excel excel-formula excel-2013 array-formulasI have a column of text values with repeated values. I want to create a new column of unique values (…
excel count excel-formula pivot-table countifExcel produces scatter diagrams for sets of pair values. It also gives the option of producing a best fit trendline …
excel graph excel-formula curve-fitting least-squaresI have a column A that contains a 1-4 word phrases in each cell. I also have 4 cells that contain 1 …
excel excel-formula excel-2010 conditional-formatting