Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it [tag:excel-vba]. If it is about an Excel formula or worksheet function, then also tag it ...
0
votes
0answers
3 views
Assign different absolute/fractional uncertainties for each data point, Excel, graphs
I have tried to find information about how it is possible to assign different uncertainties for each data point (using error bars) using Excel, but I cannot really figure out how that is possible. I ...
0
votes
0answers
6 views
Iterate through IE(internet explorer) tabs and take screen shots
My requirement is - I want to iterate through all the currently opened IE (internet explorer) tabs.
After that I want to take a screen shot of specific IE windows and paste them in excel sheet.
For ...
0
votes
1answer
6 views
SUMPRODUCT of large area with differing data types
I'm having an issue counting the number of occurances of a particular company name during different months of the year.
I have a large spreadsheet set out like the below:
employee 1 ...
0
votes
2answers
13 views
Export DataGrid into CSV or Excel
How can i export my DataGrid information into an .csv or excel file?
I tried several solutions but none of them did work for me somehow.
I'm using Microsoft Visual Studio 2010 with .NET Framework 4.0.
...
0
votes
0answers
6 views
Plotting multiple Longitude and Latitude points on a Map?
I have several thousand locations in longitude and latitude that needs to be plotted on the map. Is there any way to plot them? Or do you think there are software to help? These locations are now in ...
google-maps
0
votes
0answers
10 views
How to select data from a filtered column to use in another worksheet (function)
I have the following datas in Sheet1:
OddsId Play Type Sports OUD point AE Point
1 UDP Soccer
2 UDP Soccer
3 UDP ...
0
votes
0answers
6 views
EXCEL graph, plot (plotting failure times for each system and showing total active time for each system)
for my reliability analysis, I need to create excel graph like the one in picture. My situation is exactly same with the one in picture.
What I need: plotting failure times for each system and ...
0
votes
1answer
19 views
Retrieve varbinary data from SQL Server as Excel DataTable
In our application, we are saving the Excel files uploaded by the users to the database with varBinary data type. But, we would also like to retrieve back the data and be able to parse it to get the ...
0
votes
0answers
13 views
Alphanumeric Sorting for multiple columns
Can anyone help me with an alphanumeric sorting code (ascending) for multiple columns sorting (column by column sorting) advance.
Also let me know If the following code can be used for multiple ...
0
votes
1answer
12 views
How to get data from substring of perticular column in Ecxel?
I have a column in which Data is already inserted. Format of data is like "Item(Free)","My Item(Priced)". Now according to the "Free" and "Priced" i need to get the data. Is there any solution to get ...
0
votes
1answer
25 views
Error 13 Type Mismatch
I'm unable to work out why I'm getting an Error 13 with the following code - more specifically at line 8 (dStDev = Round(Application.StDev(rngGrainSummary), 3))
Dim i As Long ...
1
vote
0answers
15 views
report which spreadsheets contain a specific string
I have an excel workbook containing 17 sheets. On the 1st sheet, I have only one column,
it's a list of 2000 names & I need to report in which of the remaining sheets that specific name
can be ...
1
vote
0answers
21 views
Error: invalid signature: 0x4acf92ad (at position: 0x29)
I was trying to convert excel into json in node. I found a few modules that may be helpful.
I tried npm excel https://npmjs.org/package/excel
My app.js
var express = require('express'); //Call ...
0
votes
0answers
15 views
Excel VBA - Issue copying data to the same Worksheet
I'm trying to read table Values (imported from a URL in Column A) on Sheet1 & then paste the table values on Sheet2, Each underneath the other in the row directly beneath the previously pasted ...
0
votes
1answer
18 views
How do I remove duplicate content within a sigle excel cell
I have individual cells in excel with the following content in each of them
...
