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 need a cell to display the max value of a range who's row is defined by an index and …
excel excel-formula max excel-2010 excel-matchLet's say I had the datasheet A B C D ----------- 5 4 6 3 4 4 3 2 5 4 6 2 And I wanted to do something like A B …
excel excel-formula excel-2010It seem simple but I cannot find a way to define a range that goes up to the end of …
excel excel-formulaFor example, I have a named range A10—A20 as Age; how do I get Age[5] which is same as …
excel excel-formula named-rangesUsing an excel formula to search if all cells in a range read "True", if not, then show "False" For …
excel if-statement excel-formula containsI have a very annoying problem in one of my worksheets in a workbook. I am using EXCEL 2007. Any cell's …
excel vba excel-formula cell enterI want to be able to determine how many times a person's particular ID (e.g. #123) has appeared in a …
excel excel-formula vlookup worksheet-function countifI'm trying to create a chart with a range built dynamically using the INDIRECT function. Excel does recognize the range …
excel dynamic range excel-formula excel-indirectSuppose I have 2 timestamp dates: 2/24/2010 1:05:15 AM 2/25/2010 4:05:17 AM Can anyone please advise what function should I use in Excel to get …
excel excel-formulaI want to select a whole column for a formula in excel. I know I can do this, for example: =…
excel excel-formula