Stack Overflow
Stack Overflow

Questions tagged [excel-2013]

The Excel-2013 tag is used for referencing the Excel Version 2013 spreadsheet application from Microsoft. If your question is about VBA then also tag it VBA. If it is about an Excel formula then tag it Excel-Formula.

Excel 2013 is the 15th version of Microsoft's commercial spreadsheet program. Microsoft has significantly enhanced the charting and Business Intelligence capabilities in this new release.

This tag is used for questions specific to the 2013 version of the program. However, it is usually used in tandem with other tags, to let SO users know what your question is about. If your question is about VBA then also tag it . If it is about an Excel formula, tag it . Questions about addins for Excel 2013 should be tagged .

Links:

1745 questions
0
votes
2 answers

Automate compound annual growth rate (CAGR) calculation

I have a list of firms' revenue and employment (historical and forecast). I want to calculate the compound annual growth rate (CAGR) from 2014 to the latest available year. I used the following formula, =(C17/C12)^(1/COUNT(C13:C17))-1 While the…
cona
  • 169
  • 1
  • 13
0
votes
1 answer

Preventing Excel 2010 to open documents over HTTP in Design Mode

It seems that when Excel 2010 or Excel 2013 opens over HTTP a workbook that contains a macro then it automatically switches to Design Mode. Is there a way to prenvent this ? I have tried many options of the confidentiality center but none seems to…
thesailorbreton
  • 363
  • 4
  • 12
0
votes
4 answers

Use VBA to paste values from one table to another

I have the following VBA code that takes a single row from Sheet "Tabled data", copies the data, then pastes the data into the next available row in Sheet "Running list". However the original row has formulas and I need the values to paste, not the…
Molly
  • 31
  • 1
  • 3
  • 7
0
votes
1 answer

Ignore some rows when using INDEX function on a PivotTable

In Excel 2013 I am using an INDEX function to populate a column with ticker symbols that appear in a pivot table. I find that when I do this it is also pulling in the categories that each ticker appears under - for example "Consumer Discretionary".…
Andrei
  • 3
  • 1
0
votes
1 answer

Count Blank Cells in Column

I have a report that varies in length from month to month because of hires and terminations so last month I had 8354 total employees and this month 8683 total employees. Column Y gives me the Medical Plan the employee is on and it will be blank if…
William
  • 115
  • 2
  • 12
0
votes
1 answer

Time constraint function in Excel 2013

New column should have yes or no. If S1 before 6:30 and after 15:00 print yes OW No If S2 before 14:30 and after 23:00 print yes OW No If S3 before 22:30 and after 7:00 print yes OW No Inputs are like below Shift as per roster | In-Time…
user3626342
  • 11
  • 5
0
votes
1 answer

Automatically populate a column based on the column header name

I've been having lots of trouble trying to change my excel macro to do what I want it to. I have a worksheet (called User Sheet) whose 70th column (BR) gets automatically filled based on a column in another workbook. I need to change my macro so…
LizzyXoXoCaterpillar
  • 9
  • 3
0
votes
1 answer

Excel 2013 - Sumifs - Add all cells in a column

I have the following formula in my Excel 2013 spreadsheet: =SUMIFS(Employees!$T$2:$T$1114, Employees!$L$2:$L$1114, $A5, Employees!$J$2:$J$1114, 1, Employees!$Q$2:$Q$1114, "N", Employees!$K$2:$K$1114, C$3) It is summing column T based on certain…
jesse
  • 71
  • 2
  • 8
0
votes
1 answer

How to suppress excel pivot error - "We can't drill down here."

I've got a pivot table using data from two tables related together - Excel 2013 Data model. I'm gettin an error "We can't drill down here." while double-clicking on a first column items in a pivot. My goal is to execute macro (which will btw…
kafe
  • 157
  • 8
0
votes
1 answer

Dynamically Populate Sum by Dates

I'm hoping someone can help me build a quick function in Excel or an auto-populated table which sums an amount based upon what sales were done on a daily basis. Example Table: -------------------------------------------------- date | gross…
hawkhorrow
  • 475
  • 2
  • 7
  • 18
0
votes
1 answer

Autopopulate a column utilizing the MATCH function

I have 2 workbooks: "MainWorkbook.xlsm" and "ReferenceWorkbook.xlsx". The reference workbook is a report that the main workbook pulls data from. There is a column in my main workbook called "Vendor Name", which is column J. The column in the…
Brian Houlihan
  • 5
  • 3
0
votes
1 answer

I'm trying to copy a range of data from one worksheet to another

When I tried to copy sheet1 of workbook1 to sheet2 of workbook2 it doesn't show anything on sheet2 except the copy selection frame. If I comment out Activeworkbook.Close. the workbook1 is open and the adequate sheet as well. But not only it is not…
MAXStack
  • 11
  • 1
  • 4
0
votes
2 answers

Problems activating worksheet in excel 2013

My macro's were working perfect in excel 2010, but in 2013 I have a major problem with activating workbook in vba and than when certain sheet is selected + cell is selected I can fill in data, but when pressing enter or arrow key, the data is set to…
Marc Kennes
  • 1
  • 2
0
votes
1 answer

Format multiple cells in a row (e.g. B1 to H1) when they are greater than a value indicated in a cell (e.g. A1)?

I need a formula that will allow me to set conditional formatting in Excel 2013 so that it automatically formats multiple cells in a row that are greater than a value in the first column of that row. For example, to format cells in B2 to F2 if they…
Lindsay Furtado
  • 1
0
votes
2 answers

How do you group an Excel PivotChart by a column not selected in category?

Does anyone know if its possible to select one column in an Excel PivotChart (i.e. Name in my example) but sum the values by ID without displaying the ID column in the chart? In the example below, we have two Johns. I want to view both of them in…
datamodel
  • 116
  • 7
1 2 3
…
99 100