Dec 9, 2013 · In Excel 2013 I am trying to input a "days" function which will return the number of days between to dates. I've been trying to use the "days" function which is in the drop down menu under …

Sep 3, 2012 · Excel Table will replace the header with a formula to header with value/text. How can i write a macro for this situation using this formula " =TEXT (WEEKDAY (Data),"dddd") " ?

I'm trying to add lines to my excel spreadsheet. I can't find how to do that on the Office 2010 Starter edition. Can anyone help me? Thank you.

Feb 5, 2012 · I have created a scatter graph on Excel and i added a trendline, which went through most of my dots. How do i find the equation of the line and R2?

Mar 6, 2020 · The free Excel workbook "Professional_Compare" (updated) is available at MediaFire. (compares every cell in two worksheets Or each row in one worksheet against all rows in a second …

Nov 25, 2010 · PivotTable Calculated Item I have a pivot table and want to add a calculated item using each row's Grand Total: Attended Advisor Name N Y Grand Total I want the calculated item to be the …

Nov 28, 2018 · Excel Consolidate Consolidate works for one worksheet but does not work on the other. Not trying to consolidate both sheets. Each sheet contains unique data. Trying to consolidate the …

I am trying to add slicers in excel 2010 to a table that is not a pivot table - is this possible? I have a query that I would like to apply the slicer to and each time I try to add the slicer I get

Feb 7, 2020 · VBA macro to add table of contents I have a table of contents I use often and have a raw version of it pasted into a recipe.dotm template. I would like to convert it to a macro that I can assign …

Sep 26, 2013 · This question involves 2 functions: AVERAGEIF and custom function STDEVIF (code below). AVERAGEIF treats all text cells as blank cells. STDEVIF returns #VALUE! if there are any …