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'm trying to do conditional formatting so that the cell color will change if the value is different from the …
excel excel-2007 excel-formulaI have this table and I would like to create a formula which would count values based on true conditions …
excel excel-formulaRequirement : If the string in cell A1 contains "abc" as part of the string Then assign value "Green" Else if …
excel excel-formulaI have two columns- column A which extends upto 11027(values) and column I which extends to 42000(values).Both the columns …
excel excel-2007 excel-formula excel-2010 vbaI'm wanting to display a pivot table and for it to show me the actual values, one on each row, …
excel if-statement excel-formula excel-2007 pivot-tableI have a report that is generated in Excel which contains an employee's number, but not his/her name. Not …
excel excel-formula spreadsheet vlookupFor example, if I have ABS YUR YUAO HFH IWO OQNX YQO PQM QUCC How do I extract the last …
excel extract excel-formulaIf I have a block of cells such as A1:D5, what's the quickest way of multiplying each cell by …
vba excel excel-formulaI have a set of data that shown below on excel. R/V(208,0,32) YR/V(255,156,0) Y/V(255,217,0) R/S(184,28,16) YR/…
excel string excel-formula substringIn MS Excel, I would like to format a number in order to show only thousands and with 'K' in …
excel excel-formula