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 spreadsheet with approx twenty different sheets named by stock ticker. Because these are templates, the information in …
excel excel-formula formula worksheet-function excel-indirectI need to count the number of cells in a column that contain a certain bit of text. Actually, I …
excel excel-formula excel-2011I have a table in Excel with column headings that correspond to part of a dynamic named range elsewhere in …
excel dynamic excel-formula named-rangesIs it possible to pad a cell with spaces to ensure that it is the correct length? Here's an example …
excel excel-formulaI am trying to achieve a basic lookup using INDEX and MATCH. My layout is: Sheet 1 NAME | SITE | DATE Sheet 2 …
excel excel-formula excel-2010 lookup excel-matchI have following workbook: Worksheet Accounts: Worksheet Posts: I would like to know if it is possible to define Data …
excel excel-formula validationI've been using Excel's COUNTIFS function to count the number of rows in a table that meet certain criteria, E.…
excel excel-formula worksheet-functionI have a table that looks like this B C 43 XS 6 44 S 11 45 M 16 46 L 21 47 XL 26 48 XXL 31 I've written the formula: `…
excel excel-formulaI have learnt to read and write an Excel file using a Java program with the help of Jxl and …
java excel excel-formula excel-2003 jxlI have a need to search a row of cells, and for every cell that contains a specific value, return …
excel excel-formula lookup textjoin