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
3
votes
3 answers

EPPlus Barchart bars not showing colors for negative value in Excel 2013, but works fine in Excel 2007

I am using a BarClustered chart using EPPlus for Excel Package in C#. I am able to generate the bar chart as required. Only problem I am facing is that when I have a negative value, the bar does not show any color. It would be as if a transparent…
Sumesh Kuttan
  • 1,333
  • 1
  • 17
  • 40
2
votes
2 answers

Repeat values n times where n could also be 0.5

I saw the following question on here regarding repeating values: List number of lessons including half lessons based on Number of lessons and lesson name This question needed an older Excel version, I liked the problem statement and liked searching…
P.b
  • 8,293
  • 2
  • 10
  • 25
2
votes
1 answer

Reading [#All/#Headers/#Data/#Totals] didn't work in xlwings (anymore ?)

Hello community I'm new in here and can not "add a comment" now. So I created this question. I've a problem and I don't understand why. The problem was explained in here as well, but didn't work for me. How to reference Excel table column names in…
TenchiMuyo1984
  • 21
  • 3
2
votes
1 answer

Hide Powershell Window From Popping Up | VBA

I have a VBA script that is running PowerShell and submitting the results. The problem I am having is that the GUI window pops up and then disappears. Is there a way to keep the PowerShell GUI hidden completely while it runs? Here is the meat of the…
Tyler East
  • 21
  • 3
2
votes
1 answer

Keeping the Excel drop down list through pandas

I have an excel file where the headers have drop downs which can be used to select rows based on specific column values (exactly what WHERE statement does). I import this file into pandas and perform some operation. Let's say I drop duplicate values…
Freddie
  • 944
  • 9
  • 16
2
votes
3 answers

How to accept 9 first characters in excel formula?

I am trying to get this sort of result, where I check on sheet1 if the first three numbers on column A are found anywhere in the sheet2's column A. If the numbers are found then on column B excel prints Yes and if it is not found excel prints…
waspe
  • 23
  • 4
2
votes
1 answer

Why cannot I not access a worksheet by name?

I'm using Excel 2013. I can access a worksheet by iterating through the worksheets and checking the Name property, but I cannot find it individually by using the worksheet name as a key. Do I really have to iterate through all the worksheets and…
Mark Roworth
  • 409
  • 2
  • 15
2
votes
2 answers

How to add ' before and after number

I am new to Excel I have a around 3000 purchase numbers and I need add ' before and after the numbers, and I need a , after each row's closing '. Eg: '18-0000319-000', '44-000000123-000', '55-00000456-010', Don't know how to do in Excel please help…
Maxtech
  • 111
  • 16
2
votes
3 answers

Creating Pivot Table with Distinct Count using VBA

I am trying to create a pivot table using Excel 2013 VBA with DISTINCT COUNT as a value field. I understand that if you create the pivot table manually, you have to check the "Add this data to the Data Model" checkbox in order to have the distinct…
AFishAnCee
  • 45
  • 1
  • 4
2
votes
1 answer

Proper Calculating (and SUM) Molecular Weight Using Excel

How to recognize (and SUM) also chemical formulas which have more occurrences of elements such as AsH2(C4H9) = where you have H on two places or in CH2COOH where actually only one of the "same" elements will be counted?? It is good explained on…
MmVv
  • 553
  • 6
  • 22
2
votes
1 answer

Why is some table header data missing when I import with Excel's "Data Connection"

I have a workbook that needs to connect to two other workbooks to pull data and summarize it. I have set up a data connection, but on one of the sheets, when the data is imported, some of the table headings are missing (The cell where the heading…
Hammer Bag
  • 31
  • 4
2
votes
1 answer

Word Wrap adds blank line when printing excel sheet due to Page Layout adding additional pixels in width

When I try to print preview or look at the Page Layout (or print) an excel sheet, it changes my column width. I noticed the change is by around 5 pixels. This change is good enough to cause below issue: In below screenshot you can see "Real Estate…
NonProgrammer
  • 1,337
  • 2
  • 23
  • 53
2
votes
1 answer

Microsoft excel color picker is different on different documents

I have two Excel two documents on the same laptop with an extended desktop. For some reason, when i use the color picker, i get different color options on each of the documents. Here are the two options i see: Document1.xlsx Document2.xlsx Does…
ziggy
  • 15,677
  • 67
  • 194
  • 287
2
votes
1 answer

COUNTIF function comparing dates as a criteria is not working

I am using Excel 2013. I have a worksheet that has training completion dates for our employees. I need to determine the percentage of employees that have completed the training. I am using the below COUNTIF formula, but the return is a 0 even though…
Curtis
  • 23
  • 4
2
votes
1 answer

Concatenate formatting when dynamically referencing external sheets

I'm trying to write some code to automate a search we carry out at my company over 64 spreadsheets, with 6 sub-sheets apiece. Due to the typical large-company 'left hand, right hand' issues and due to strict policy, merging the spreadsheets is not…
L Black
  • 21
  • 1
1 2 3
…
99 100