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
2answers
37 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
17 views

How to reveal matching and mismatching data [on hold]

I have a table in Excel like below: Name NameFroMFile LastDate Comp1 Comp1 8/1/2019 Comp2 Comp2 9/1/2019 Comp3 Comp8 10/1/2019 Comp8 Comp3 11/1/...
0
votes
0answers
17 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
36 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
68 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
23 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
30 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
51 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
38 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
46 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
0answers
50 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
60 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
30 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
15 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
69 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
34 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
19 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
29 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
32 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
22 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
10 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'...
0
votes
1answer
88 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
18 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
31 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
7 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
8 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 ...
0
votes
0answers
25 views

Seamless way to link time series data from an increasing number of spreadsheets in excel

I have a task that involves plotting data over time from a set of spreadsheets, where the number of spreadsheets increases by 1 each month. I'm wondering what the easiest, most user friendly way to ...
0
votes
0answers
32 views

Substitute function gives too few arguments error

I want to extract the text after the last space with this code I found: =LEFT(A1,SEARCH("^^",SUBSTITUTE(A1," ","^^",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-1) But it keeps saying I have entered too few ...
0
votes
2answers
46 views

How to change start point of Major Gridlines in an excel chart?

I have a chart that has data starting in September 2011 until April 2019 (monthly data). I have plotted it on a chart and put the year of the data on the x axis. The cosmetic issue I have is that the ...
-1
votes
5answers
55 views

Excel 2013 - Multiple numbers in cell as text string, need to identify if any are less than certain value

I have been given a large amount of data (and can't go back and ask them to provide it in a more useful manner). It contains multiple figures in the same cell, separated by a semicolon. A +-------...
0
votes
0answers
18 views

request.getSession(false) is returning a new session?

I am in RAD 9.6.1 debugging against Websphere 9.0. This is a legacy app that is undergoing a feature addition. The request is to download an excel file. The excel plugin comes up, the user hits ...
0
votes
2answers
36 views

Below line of vba code not working for deleting sheet in excel workbook not working in excel 365

I have used below line of vba code: Sub abc() Dim wb As Workbook Set wb = Workbooks("Book1.xlsx") wb.Sheets("sheet1").Activate On Error Resume Next wb.Sheets("Sheet2").Delete wb.Sheets("Sheet3")....
0
votes
0answers
11 views

Excel Pivot with a list of projects which are aggregated and should be used as a entry in another pivot

I have an issue with pivot tables in Excel and hope you can help me. I have two datasets: List of projects List of customer parameter The list of projects contains the following information: ...
1
vote
2answers
37 views

How to fix a Runtime Error 9 on Range Activation that occurs on Office 2013, but not on Office365

A line of code, that seems to work fine in Office 2016 and Office 365, runs into a Runtime Error 9 when using Office 2013. Workbooks.Open Filename:="W:\06 Project Management Master\Project Resource ...
3
votes
1answer
115 views

Why is POISSON function not consistent in Microsoft Excel?

There is a definition in POISSON function that: #NUM! error – Occurs if either: The given value of x is less than zero; The given value of mean is less than zero. But I try to do this in Excel ...
0
votes
0answers
28 views

Find lower price among repeated ID

I have sheet 1 contain col An ID and col B is the price and col An is repeated ; how can I find the lowest price among colum B for the same ID =MIN(IF(D1=Sheet2!$D$2:Sheet2!$D$562;Sheet2!$M$2:$M$562))...
1
vote
2answers
32 views

Loop through tables and delete data

I have the following code that generates an error. I want to loop through all the tables on the active worksheet and delete the data except for the data on two specified in the code. Sub ...
0
votes
1answer
87 views

VBA Connecting to SQL Server 2017 - Error(Unable to complete login process due to delay in opening server connection)

WE use a spreadsheet to collect and distribute various data into sheets for company use. Use were using MS Excel 2013 and an early version of MS SQL Server Which worked perfectly without any errors, ...
0
votes
0answers
40 views

Excel - putting values in different columns based on separator

I have a large string copied into a cell in Excel. The format is like this: key,key; Example: Key 1,key 2;key 3,key 4;key 5,key 6; I want to split the keys using ';' and then split each string by '...
0
votes
2answers
182 views

How to set border by leaving one cell space along each side of entire data using Apache POI 4.0.1 and java

Currently, I'm able to set border beside the entire data (You can refer following image). Current output Code snippet // Code to draw Border at left side int rowstart = 3, rowend = 9;...
0
votes
1answer
83 views

Web query connection does not create table in excel

I have the below external link https://creator.zohopublic.com/inovadms/inova-dms/view-embed/SPO_Export_Public/...
0
votes
0answers
94 views

How to solve error #value! in Excel, by using webservice formula that use Google Map API Distance Matrix in xml?

Since our purchase of Google Map API Distance Matrix Advanced, we try to use a Webservice formula within Excel 2013, in XML, that would allow us to make several requests to retrieve driving mileage ...
0
votes
1answer
14 views

finding specific series of dates between two dates

Im trying to do formula that finds a series of dates from A3 to A6 which falls between two dates H4 and I4 then when find any date sum (holidays) in J4 screenshot of work
0
votes
0answers
22 views

Excel drillable reports

I have an excel that is linked to an sql database. the excel contains columns that represent header records as well as detail lines. I'm trying to make the header records collapsible to be able to ...
0
votes
1answer
36 views

Setting variable to specified workbook generates out of range error

I am trying to write some simple code that pulls ranges from one workbook (source) and pastes them into another workbook (consolidate). I want the "source" workbook to be specified as I run the macro ...
1
vote
2answers
15 views

Chart containing date comparisons using Excel 2013

I am trying to compare data from November 2017 to November 2018, December 2017 to December 2017 to December 2018 and January 2018 to January 2019 for 5 classes in the same Column A is titled Classes ...
0
votes
0answers
20 views

How can I use 3 chart types in excel over both axis OR otherwise properly show the data for multiple data sources?

Sorry about the title, it was hard to figure out how to word this. So, my main problem is a Total Count column represent the overall quantity, but the other columns are PART of a Total Count column. ...
0
votes
1answer
48 views

Clearing Data from Multiple Tables in VBA

I have a series of 20 tables on a sheet called "Builder" all with there own individual names. What i want to do is create a variable that isolates only the 19 tables that i tell it to so that i create ...
1
vote
1answer
81 views

OLEDB 12.0 Connection compatible with both Excel 2010 and Excel 2013

I'm trying to make a connection to MS Access database via Microsoft ACE OLEDB 12.0. I'd like to make it work on both Excel 2010 and Excel 2013, so that the end user would just refresh connection to ...