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
11 views
Ranges (as Variables) and Solver Looping
I have a problem that I couldn't seem to find on Google no matter how much i searched. I have a form that the user inputs data like the variable cell and the input cells (similar to the regular ...
-1
votes
2answers
22 views
I need to load data from excel file into HTML page
I want to import web analytics information listed in an excel file (can import in xls, or csv) directly into my website updating the info just by including this file into the same folder in the ...
0
votes
0answers
5 views
Excel Graph to PowerPoint C++/CLI Exception from HRESULT: 0x800A03EC
I am trying to copy excel graphs and then pasting them into a PowerPoint using C++/CLI although I have run into difficulties when trying to use the Copy() method. Here is a simplified version of my ...
2
votes
3answers
40 views
import huge excel sheets to Datatable
I have a Excel Sheet with two tabs.
One is approx 700 k and other is around 25k. The issue is when i am loading the files my memory gets eaten up and it crashes! How to handle huge files as some ...
0
votes
2answers
20 views
Excel efficiency index bar chart
For a data
Efficiency
ITV Drama 98
C4 Movies 101
More 4 Movies 92
E4 Movies 106
Film4 100
How to get the output as below?
1
vote
2answers
31 views
Get column values from a CSV file w/o for loops
I have a large CSV file in front of me. 10 Columns, 3000 rows. I am looking for a PHP library that would let me simply get all the values in a given column. Something like this:
$columnValues = ...
0
votes
1answer
18 views
How to use formular1c1 without defining the range in vba excel?
My code is:
Range("M1").Select
ActiveCell.FormulaR1c1 = "SUM(R[2]C:R[4157]C)"
My problem is what if I have more than 4157 rows. How do I ensure all rows for that column will be added up?
Thanks!
0
votes
1answer
20 views
Excel QFD (Quality Function Deployment)
I am trying to make a QFD on excel.
The horizontal rows are easy to do but I do not know how to make the diagonal intersecting rows.
An example QFD is ...
0
votes
1answer
21 views
excel 2007, computed style in conditional formatting?
I would like to change the text color of cells based on their content (name1=blue, name2=red, etc.)
I know I can use conditional formatting but it will need as many rules as possible values for the ...
0
votes
2answers
21 views
in excel, how can I use a cell content for column index
for example, in cell $M$1, I store the column index (A,B,C... ...) which I wanna use later.
If now I put character "D" in $M$1, by using =sum($M$1:$M$1), I wanna get the summation of column D. And if ...
-4
votes
0answers
38 views
Having Issue with code please
I'm trying to have excel count the amount of rows in one column and use that count to copy and paste a set of data onto another sheet. In other words I get a variable set of data from a client that ...
1
vote
0answers
23 views
Clojure agents append to excel file
I've been using docjure to write to excel files. Mostly I want to append rows to already existing files, usually one at a time. When I do this without agents/future, I load the file, use add-rows to ...
1
vote
2answers
36 views
VBA column looping
I have a large Excel file and I need to replace all values in 12 columns completely.
Right now, there is a formula in each one of the cells, and I need to replace that formula with my own.
How do I ...
0
votes
1answer
30 views
Removing Data Points From a Chart Using VBA
This question is in reference removing data points from a chart using VBA.
After an extensive search, I have come across some very usefull code. In particular from Jon Peltier (Get Information about ...
0
votes
0answers
18 views
excel PivotTable calculating non-negative total score in order
I have set up a game with some special rules in calculating the total score of participants.
Let's see the following example:
I hope you understand how the rules work.
Blank cells mean that the ...
