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 a beginner and trying to create a formula that modifies the contents of Cell A1 based on the color …
excel excel-formulaI plan to have a workbook with 24 sheets. The sheet names will be: Jan, Jan item, Feb, Feb item, etc. …
excel excel-formula worksheet-functionConsider the following worksheet: A B C D 1 COMPANY XVALUE YVALUE GROUP 2 Apple 45 35 red 3 Xerox 45 38 red 4 KMart 63 50 orange 5 Exxon 53 59 green …
vba excel charts excel-formulaI have a column with names and a column with numbers: FirstName Name Number John Smith 17 John Smith 26 Peter Smith 116 …
excel if-statement excel-formula sum pivot-tableI'd like to know how to pull cell references from the value of another cell and insert them into a …
excel excel-formulaI use this handy equation to search for a term inside of a cell in excel. =IF(ISNUMBER(SEARCH("*Gingrich*",…
excel excel-2007 excel-formula excel-2010 excel-2013What I want to do is to say if the contents of cell D3 (on current worksheet) exist in column …
excel excel-formula vlookup excel-matchI have a very large excel spread sheet that has a column of time stamps. Does anyone know convert that …
excel-formulaI've a huge data in excel file. For eg: say i've a word like paul son,i've to make it …
excel-formula excel-2010I have formula that checks if the cell starts with text "A" returns Pick up "B" for Collect and C …
excel excel-formula