# 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.

1,694
questions

**0**

votes

**1**answer

40 views

### Excel 2010 freezes every time I open a specific sheet

I have an excel file (a large model with several sheets) which was most likely made in Excel 2013 as xlsb file. My Excel program freezes / hangs every single time when I click to open one specific ...

**0**

votes

**0**answers

35 views

### Convert text to number values after Query Editor (stored as text)

Consider 2 sheets, one sheet is lookup one where I am taking my data (matching them with another sheet) using this formula:
=IFERROR(IF(INDEX(Sheet2!A:Y;MATCH($U17;Sheet2!A:A;0);MATCH(X$14;Sheet2!2:2;...

**0**

votes

**0**answers

10 views

### How to “protect” certain fields (to avoid row spacing) in huge excel data set

I am having huge data set, and every-time I am adding new row into it (middle of the table), the tables on left and right side are disrupted. Is there any way to "lock" these tables during my edit or ?...

**0**

votes

**1**answer

53 views

### VBA or function to connect 2x CSV files into 1x XLSX

Greets,
I got this scenario with 3x different files;
1) one CSV file has Column A (-first row) with abbreviations that needs to be copied on XLSX file (also in Column A)
+
2) another CSV has many ...

**0**

votes

**1**answer

77 views

### Excel: how to calculate percentage within 24h when have dynamic data (over 24h)

I cant figure out how to calculate percentage within one day (24h) with a set of data that is dynamically changing, you have one day and different time as you can see on the SS. But thing is, I can ...

**0**

votes

**0**answers

10 views

### Pivot Tables: Slicer (button) color change?

I came across with something, couple of days ago while doing something in Pivots, and friend of mine (who isn't experienced in Pivots) asked if I can change color of buttons in Pivot slicers? At first ...

**1**

vote

**1**answer

38 views

### Excel: Dynamic range within certain rows + data validation update

What I have here is small part of my big data set, with lot of drop downs and functions that are calculating everything around. I am just exceeding this table and trying to make it more automatically ...

**0**

votes

**0**answers

27 views

### Filtering and deleting rows with images in Excel 2013

I have excel sheet having approx. 5000 rows. Column 1 has profile image, Column 2 has signature image, column 3 have roll no. and column 4 has gender. I am trying for Filtering or deleting on Gender ...

**0**

votes

**1**answer

16 views

### Excel “support”: Dynamic chart with multiple selections

I have a set of data that I wanna make dynamically by clicking dropdown and to reflect that on chart. The problem is, I have like small tables (like in Example, Material A, B, C..) with their certain ...

**3**

votes

**1**answer

56 views

### How to reference an old version of the VBA library?

I'm using Excel 2013. The VBA reference is part of Excel (built-in) so I can't remove it.
Is it possible to reference another version of the VBA library? The reason I want to know other than ...

**0**

votes

**2**answers

44 views

### Excel help: appropriate function for lookup/match cases

Got a huge dataset that is dynamically connected and used on one workbook (lets call it W1) and on another workbook (W2) are the data set that has to be updated firstly there (W2) and then on the main ...

**1**

vote

**1**answer

78 views

### How to calculate (summarize) proper Percentage within 24h (to not exceed 100%)

Topic sounds simple but the task that I am interested in is not!
So, I got a set of measurement data that are changing per day, with more instances within one day! So as you can see for 07.02.2019 ...

**0**

votes

**0**answers

12 views

### Excel thinks delimited file is tab not csv when saving

I have read many similar posts but addressing a different issue.
My accounting software creates flat text files that are appended with time stamps. So file names may be similar to "box201910268.34"...

**0**

votes

**1**answer

22 views

### Excel 2013: How to display corresponding text instead of numbers in axis labels?

I've a table of some task's progress, per person and I'd like to plot it on a chart.
Y axis - names
X axis - progress (NA, start, in progress, completed)
and the preferable chart is bars, like that:
...

**0**

votes

**1**answer

34 views

### Formulas become unresponsive to changed value inputs to referenced cells

The question closest to mine did not return a satisfactory answer.
Inserted formula with cell reference does not recognize new input
In a particular macro-enabled workbook, macro-generated formulas ...

**0**

votes

**0**answers

21 views

### Countif Formula with Multiple Criteria - Text and Date in Excel 2013

In my workbook I have a summary page that pulls from the worksheets(Active, Pending and Closed) within the workbook. Those worksheets are linked to other workbooks. On the summary page, I want to ...

**-1**

votes

**1**answer

35 views

### is there a way to sort data depends on a value on excel

I want to put some excel in row if they contain a specific word
A |B
____________________
HP SERVER | 1
HP LAPTOP | 2
DELL SERVER | 2
LENOVO LAPTOP | 3
HP SERVER G8 ...

**-1**

votes

**2**answers

61 views

### A filtered list displayed on a new tab by date ranges

Excel has been out of my scope for a long time, and this feels very simple. Looking for the formula to filter a list, but the results are on a new tab.
Closest thing I have found is this FILTER ...

**2**

votes

**3**answers

46 views

### 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 ...

**0**

votes

**2**answers

46 views

### Hod to copy data from one sheet to another with limited selection of columns using VBA

I need to copy data from one sheet to another with a limited selection of columns using VBA, not continuous and transpose the copied data in a column while pasting to another sheet. Also, I want to ...

**1**

vote

**1**answer

44 views

### Unable to copy all data in column to another sheet - excel VBA

I am unable to copy all data in a column. I would only want to copy data that does not include the first row, (headers), and paste it to another sheet. My current code gives me a partial result as ...

**0**

votes

**1**answer

55 views

### What to use: COUNTIF or Vlookup or combined or else?

I got a big data file where I have to count how many events is per one serial number (in my case P/N) through more sheets (years). Those serials are in Column A (grey). On second picture is lookup ...

**-1**

votes

**1**answer

34 views

### Open Windows Registry Editor from excel

I want to open the default registry editor with a specific registry key opened when I click on a command button in a excel worksheet. Is there anyway I can do it?
Thanks.

**2**

votes

**1**answer

48 views

### 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 ...

**0**

votes

**2**answers

43 views

### Find multiple repeated values and copy rows

I need to pull repeated values from a table and copy information from my Row 2 as many times as there are items returned. The example makes more sense. Here is a truncated example of the table with my ...

**0**

votes

**0**answers

20 views

### Dates/text as x-axis in scatter plot Excel

I have a set of measurements taken on different dates. I would like to plot that data in a Scatter plot, with the dates on the X-axis. Since there is a lot of data, I would like to reduce the number ...

**1**

vote

**1**answer

45 views

### Error 438 object doesn't support this property

I have this macro that works on my office computer but when I run it at a client's computer It doesn't work and shows the
Error 438 object doesn't support this property
marking this line:
...

**1**

vote

**2**answers

89 views

### SUM(if) function for multiple criteria + date/time that is dynamic

I got a problem to "extend" my formula to make correct calculation, in my case SUM() of !Time difference in Column G OR !% of time in Column H using criteria in !System in Column K in certain !date ...

**1**

vote

**2**answers

28 views

### 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-...

**0**

votes

**2**answers

32 views

### Vlookup If Match combination with an array

I have a datasheet with 3 criteria. Cost Center, Employee Level, and work country. The sheet looks a little something like this
Australia China Hong Kong India
All ...

**1**

vote

**2**answers

420 views

### 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 ...

**-2**

votes

**1**answer

40 views

### How to create columns in Excel 2013 using info from another column via VBA? [closed]

I have a column (say MyOriginalColumn) in Excel 2013 including 300+ rows (OriginalData let's say), 3 of them are given as an example below:
CN=myCN1,OU=Workstation,OU=123 (Edmonton),OU=Canada,OU=...

**0**

votes

**1**answer

195 views

### atomsvc in excel from ssrs: “We couldn't get data from the data model”

I have exported an SSRS report to an .ATOMSVC file by running the report and saving as Data Feed. I then try to import the data feed into Excel (Data From Other Sources > From Odata Data Feed) by ...

**0**

votes

**0**answers

5 views

### MS Excel 2013 Conditional formatting

I've used the following formula and($N$2="Submitted",<=$E$2+21)
The values in column N are from a dropdown list and can be "Submitted" or "Outstanding"
Column E contains dates in DD/MM/YYYY ...

**2**

votes

**1**answer

64 views

### 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" ...

**0**

votes

**1**answer

70 views

### How to make Windows forms app to support Older versions of MS Office?

I need to develop a windows app program. I have Office 2013 in my Machine. And I need to develop the app which supports Office 2013 User machine also. How to do reference dll for it?
I expect that I ...

**1**

vote

**2**answers

56 views

### How to quintile by date group using Percentile in excel

Im just wondering if its possible to quintile my data by group in Excel, using the percentile function.
I can quintile my entire data by doing =MATCH(C2|PERCENTILE(C$2:C$20|{5,4,3,2,1}/5)|-1) but I ...

**0**

votes

**0**answers

16 views

### Is there any function in Excel that can search for partial text and return all texts that partial matched at once?

I'm doing some project which I've to take the picture of cells in 96 well plates (each well) every 2 hours for 3 days, and it give me about 3,500 pictures.
I've to see the pictures of each well in ...

**0**

votes

**1**answer

77 views

### Run-time error '1004' when creating macro to delete shape

What I have done is created a macro that deletes any images in a certain range of cells if an image is present Range("D199:U205" and then copies an image named "JB Sig" at the bottom of the sheet, and ...

**0**

votes

**1**answer

36 views

### Rccognise last working day and change substring of cell value

I am trying to change 2 dates ('10-06-19'!F333+'10-06-19'!Y555) in cell value to last working day.
I have a list in Excel of the public holidays which can be maintained.
I have the code to ...

**0**

votes

**0**answers

20 views

### Excel 2013 vLookup multiple comma-delimited criteria return one result

I'm trying to automate a client's Excel 2013 project planning spreadsheet and can't find a way to look up one value using multiple, comma-delimited criteria from one cell.
Here's the project ...

**0**

votes

**1**answer

33 views

### Object variable not set error on Application.StatusBar

I'm trying to access any method of Application in VBA but getting below error
Code:
Application.StatusBar = "Loading input file..."
Application.Cursor = xlWait
Reference list:
It was working fine ...

**0**

votes

**1**answer

35 views

### Excel Code keeps crashing but no Error in code, Application-Definded or object defined error

I am writing a userform in which i have a listbox, when a user selects and item in the listbox it goes to row range in the datasheet and deletes it from the table (list object called data). The ...

**1**

vote

**1**answer

28 views

### How to check if a row in TABLE A matches any row in TABLE B

I am trying to add a column in TABLE A that contains "Y" or "N" next to each row. "Y" if 3 certain columns of that row match ANY of the rows in TABLE B, "N" otherwise.
Example:
I would like to ...

**0**

votes

**0**answers

85 views

### MS Excel 2013 - Data table on chart is not showing the correct data

H! Hope someone can help me. I have a chart that uses a data table to present the values. However, the values on the data table does not match the values on the source table. In the image below, you'...

**2**

votes

**1**answer

286 views

### How to connect MS Excel to Azure Cosmos DB-SQLAPI?

I need to create an Excel table who can query the Database and interpret the data into styled tables so the users can understand it.
It's supposed to be able to query the whole server and put the ...

**2**

votes

**1**answer

66 views

### 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 ...

**1**

vote

**2**answers

35 views

### How to Filter out data ranges when start and end dates are given?

I have been given a set of start dates and stop dates for working days, I have also been given the working days and the daily rate. A person works a certain amount of days between for example Jan 1st ...

**0**

votes

**0**answers

10 views

### Copy format cell to PivotTable Excel

I made PivotTable in Excel 2013 based on a table with about 10 columns, each having their own conditional formatting. Certain values in this table are therefore colored depending on different criteria....

**0**

votes

**0**answers

11 views

### Copy format cells to pivot table Excel

I have a table in Excel from which I made a PivotTable. I applied several conditional formatting rules to that table so that certain values get a certain color. Those certain values are unfortunately ...