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 ...
1
vote
0answers
15 views
Power Method - Non converging system
I am creating a risk parity process, where I need to use a Power method, it is an iterative process to find the eigen values of a system.
The aim is to find to the weight in eaach asset that you are ...
-1
votes
3answers
20 views
If Statement to check time in excel
I need to create an if statement to check time in excel. For instance if time is between
00:00:01 to 06:00:00 I give a value of 1
if time is 06:00:01 to 12:00:00 I give a value of 2
if time is ...
0
votes
2answers
32 views
Plot histogram(change axis)
I have n*2 matrix for example matrix A.First column is some index and the second one is the histogram.I want to visualise only the nonzero histogram,so, I filtered A and deleted the index with ...
0
votes
1answer
19 views
How to Keep Specific Data in ExcelSheet
Hi I have one Excel sheet and version is 2010. In that Excel sheet there is Many column but one of column is Branch which contains Branch Name like AAA, BBB, CCC..etc. Now i want to keep data of only ...
1
vote
1answer
41 views
How to compare two excel sheets and create new one in c#?
I am having two excel files.
sheet1 has 5 columns with values.
sheet2 has only one column.
sheet1 and sheet's first column has some unique values.
I need an another excelsheet, where the new one has ...
0
votes
0answers
53 views
Combining two Excel sheets
I ship a lot of items to a lot of stores and I have two Excel sheets. I have one sheet showing how many items I have shipped to each store and another sheet showing how many I have sold in each store. ...
0
votes
1answer
26 views
How to split a single row into multiple columns in Excel
In Excel, I want to split up the data in row 1 into four single columns. A1:D1 should remain in place. E1:H1 should become A2:D2 and so on.
I am currently using this formula in A2:
...
0
votes
3answers
35 views
Excel: Conditional formatting for clusters of values
In an EXCEL 2010 spreadsheet, how can I create alternating fill color for clustered cell values, changing when a new value cluster is reached?
Assume column A contains the following values:
VALUE
...
-1
votes
0answers
15 views
Could not find installable ISAM query
I came across and issue that it seems very classic,
I got a table in an Excel sheet that i want to load into SQL DB,it gave me an error of could not find installable ISAM. I maybe missed something in ...
0
votes
1answer
18 views
Writing to Excel cells while releasing all COM objects
I am following this posts advice and trying to release all of my COM objects, including all Ranges while writing a List of string tuples to an Excel spreadsheet (using his ComObjectManager class).
I ...
1
vote
0answers
7 views
How to get worksheet rows count in spreadsheet gem?
Is there any attribute to get size of rows?
@sheet = Spreadsheet.open(file.path).worksheet 0
@sheet.rows_count # why they didn't it?
0
votes
2answers
25 views
How to look up value in a column, and assign specific entries
I have a sheet in Excel where the columns contain different names of people that are in different teams in my department (i.e. Names in Column 1 are in Team 1).
For another sheet, I need to have a ...
0
votes
1answer
18 views
multiple use of substitute function but it should combine the results in one column and cell
please check the picture link to understand the query **
I want to combine the multiple raw into one text string , I can use substitute function to change one word in a text string but how can i use ...
-1
votes
1answer
30 views
Can You Access the Excel VBE Selection Programatically?
If I have some VB Component open in the Excel VBE, with some text highlighted as shown,
Is there a way to programmatically grab the text
"zBool"?
Preferrably NOT using Sendkeys
6x New Zealand ...
0
votes
0answers
17 views
Restrict the data in powerpivot for excel 2010 based on the user who is using excel file
I wanted to create a powerpivot report. In which i wanted to show only the data the user authorized to view based on his windows credentials.
For example consider the following table
ID Code ...
