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.

Filter by
Sorted by
Tagged with
0
votes
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
2answers
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
3answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
2answers
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
2answers
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
2answers
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
2answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
0answers
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
0answers
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 ...