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 that has values in random order like A column 2 3 4 2 5 6 4 3 4 I want the row index of a …
excel excel-formulaThis is purely an Excel sheet question. I have a time span that is basically a difference between two cells, …
excel excel-formulaI am receiving an error saying: Microsoft Excel can't insert new cells because it would push non empty cells off …
excel excel-formula excel-2010How to use SUMIF formula in Excel cell that must sum over a given range and instead of finding for …
excel excel-formulaI want to get rid of all the carriage returns in my cell. How do I do this?
excel excel-formulaIf I put the date 31/12/2013 in A1 and another date 1/1/2014 in A2 then a formula like =A1<A2 gives …
excel-formulaIn excel I have sheet1 contains total every month. (please see image below) Then in my sheet2 it will display …
excel excel-formula rows dragI have a 2-D array: dates on a horizontal axis and identification numbers on a vertical axis. I want the …
excel excel-formula excel-2010 vbaI have Excel documents containing Unix epoch timestamps from a Java application. I'd like to see what they translate to …
java excel datetime excel-formulaI am having a lot of difficulty trying to come up with a way to 'parse' and 'order' my excel …
excel excel-formula