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 super novice, trying to navigate data analysis in Excel, so be kind! I need to combine the IF …
excel-formula excel-tablesI want to use COUNTIF function to evaluate how many items out of 2,0,0,5 are greater than 2? In Countif function, first …
arrays excel excel-formula countifI have created a power pivot table as shown in the picture. I want to calculate quarter over quarter sales …
excel excel-formula pivot-table powerpivot daxI need to count a column only if the corresponding cell in another column is a Tuesday. An example image …
excel excel-formula conditional-formatting countif array-formulasMy problem is about programming in excel (create a formula for conditional formatting rule). If i use the following formula …
excel excel-formula conditional-formattingIn excel I have a worksheet with over 30,000 rows. Sample data is shown in the image below. About a dozen …
vba excel excel-formula calculated-columnsI am trying to check a table for specific data and if i found the data it will display the …
excel excel-formula interpolation vlookupUsing MS Excel 2010: I used the CONCATENATE formula to create a text string that looks like a formula and need …
excel text excel-formula excel-indirectI'm stuck on an Excel problem and am hoping someone can assist. I read through 10-15 topics that are similar, …
excel excel-formula excel-matchProblem definition: Enter any number in cell A1. Now try the following formulae anywhere on first row. =SUM(INDIRECT("A"&…
excel excel-2007 excel-formula excel-2003