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

Dynamically select a column using month and year, then sumif the values based on criteria in another column

Here is an image of what I'm trying to achieve: I am not well-versed in creating my own VBA script, but can understand code written by someone else if given time to dissect it. If this objective can be resolved without VBA, that would be my…
vtcc87
  • 23
  • 4
2
votes
2 answers

TEXT operator in Excel

Why does =TEXT(16,"TEMP000") return a #VALUE error? I am trying to get TEMP016 as the result. I have tried it with other alphanumeric examples, like =TEXT(16, A092000) which should show A092016, and it works fine there.
Himanshu Agarwal
  • 33
  • 2
2
votes
2 answers

Automatic numbering in Excel with hierarchy

I would like to do an automatic summary numbering. The only thing we could do is to number the A's (the titles) but the subtitles should be numbered automatically. If the title = 1, subtitle 1.1, below 1.1.1 and so on. Let's say the titles are A, B…
AciDroP
  • 69
  • 1
  • 9
2
votes
2 answers

How to return row value that meets two criteria in Excel

I have an excel spreadsheet to keep track of project activities. In Column A I have the Project Name and it repeats several times because the same project has several activities. In Column B I have the Activities related to that project. In…
Leonel Romero
  • 37
  • 1
  • 1
  • 6
2
votes
3 answers

Nested if statement in Power Query

I discovered and started using Power Query yesterday. I have written some queries to populate three drop down lists, with the second and third dependent on what is selected in the first, and the third then further dependent on what is selected in…
mickeyt
  • 91
  • 1
  • 2
  • 10
2
votes
2 answers

Why is my index match function is returning #N/A Error?

I don't know why I am getting #N/A error while I am using index match function. I have two data sets in different sheets: Vehicle group code Vehicle model Vehicle code Vehicle group Vehicle make 41 004 41004 …
Sayam Nandy
  • 87
  • 1
  • 2
  • 10
2
votes
2 answers

Using VBA to autofilter Multiple columns, with values from different sheet

I want to use VBA to filter a dump-sheet by 2 columns, with criteria gotten from values on a different sheet in the same workbook. Used code is: Sub FilterOnCellValue() With Sheets("Dump") .Range("A1:Z10000").AutoFilter Field:=9,…
RobExcel
  • 171
  • 2
  • 6
  • 16
2
votes
3 answers

Excel Week Column Sorting in Ascending Order

I have a Week Range Data as Below which has Start date of the Week and End Date in mm/dd/yy -mm/dd/yy format, I'm Trying to Sort the Column but it doesn't get Sorted as required, Help me on this…
user7569898
2
votes
1 answer

Excel Table Formatting Does Not Re-Apply After Refreshing Data From SQL Server

How would I force cell formatting to take effect automatically after a data refresh? I have a connection set up to pull data from SQL Server to a table in Excel. However, upon initial pull and refresh - cell formatting does not take effect on these…
RoflcopterV RoflcopterV
  • 143
  • 2
  • 14
2
votes
3 answers

Speeding up array search, Possibly 2D Collection if that is possible?

I need some help speeding up the current code I am running. To start, I have a large data sheet That has roughly 180,000 lines, and a unique sheet that has only the unique values from that large list that is roughly 9000 lines so it will currently…
Blake Lindeman
  • 23
  • 5
2
votes
1 answer

Match Function does not work on 2 identical numbers

I have 2 identical numbers which get used individually in match functions. However, the latter value returns a #N/A error. I have done all the checks to see if they were truly identical. Checked if both values equaled each other, made sure there…
Jayesh Surendran Menon
  • 75
  • 1
  • 12
2
votes
1 answer

update excel files in python 2.7

I need to edit an excel file but without overwriting the old content I'm using xlsxwriter to create the excel file but it does not have this option is there any solution ?
ismael bouzoubaa
  • 41
  • 2
  • 4
2
votes
2 answers

How to assign a single value to an entire named range VBA

I am trying to assign a single value to an entire named range. I know this can be done by using for each a in "Named Range" a.value = "Value" next a But is there a way it can be done in a single line of code? So that I can save runtime.
Avi Gupta
  • 57
  • 1
  • 2
  • 9
2
votes
2 answers

Improve function that cleans non printing and other ASCII characters

I have an Excel 2013 Workbook with sheets imported from various sources. These contain Unicode characters all over the place which the clean function do not account for. I found a function which works cell by cell, but I'd like to have it used on…
mightymax
  • 431
  • 1
  • 5
  • 16
2
votes
2 answers

vba replacing two quotation marks with one / generating txt files

I have created a macro that generates txt files with data from every row in excel. I have problem with " (quotation marks) Here is a line from VBA that makes problems: wsTemp.Cells(6, 1).Value = "The ""Number"" is " & wsSource.Cells(r, 3).Value I…
user2463808
  • 179
  • 11
1 2 3
…
99 100