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
4 views
Can I Hide the Spreadsheet Tabs In An Excel HTML Document?
It is posssible to Hide the Worksheet Tabs in the Excel Window by deselecting
Tools > Options > View > Sheet Tabs
However if you save the Spreadsheet as an HTML Document and the open this with ...
0
votes
0answers
6 views
COMException 0x800A03EC Chart To Image C# Excel Interop
I'm creating a program that takes a chart from an excel worksheet and converts it into an image.
I'm fine with getting the first chart, but when I try to get the 2nd chart, it gives me a COMException
...
0
votes
0answers
12 views
Excel VBA Macro to populate cells in a spreadsheet depending on the value shared by another spreadsheet?
Apologies if the title is a bit confusing. If someone has a better title that explains this please let me know so I can update the title for future users.
What I am trying to accomplish is this, I ...
0
votes
1answer
5 views
MATCH function in a multi dimensional array
I am trying to extract the row location of a cell with the minimum value in a range which consists of 2 different columns that are not adjacent. It seems MATCH function does not allow the use of more ...
0
votes
0answers
34 views
I need help writing an =if
I have Columns A, B, C.
I need the following formula to be put in Cell C:
If Field B1 = "2" and no other row is = to Field A1 then "1.99"
If Field B1 = "2" and another row is = to Field A1, and ...
0
votes
0answers
24 views
Excel macro to add and stack table coloumns
I've got the following tables with many columns:
I am looking for a macro that can add the two tables and stack the 'added' columns on top of each other.
Giving this as a result:
Any ...
1
vote
3answers
22 views
ActiveCell.Formula Run-time error 1004
I am trying to get the sum of columns G:26 to 1 above the "Total Service Fees" cell. I am running into a Run-time error '1004'. Application-defined or object-defined error. Does anyone know what this ...
0
votes
1answer
26 views
VBA/Excel Error with Find: Object variable not set or type mismatch
In this macro I'm extracting network data from Visio and putting it into an excel file. In the visio file there are objects which may show up multiple times, but I only want these items listed once ...
1
vote
2answers
19 views
Precise process event timeline diagrams (e.g. in Excel)
I need to prepare such diagrams:
I think it's quite intuitive how to read this diagram and this is why I want to create a few of them for my project.
I am quite confused how to create them ...
0
votes
1answer
23 views
Extracting a substring from a string in Excel 2007 where substring is of arbitrary length
I have just a hair over 30,000 tweets. I have one column that has the actual tweet. There are two things that I would like to accomplish with this column.
First here is a snippit of sample data:
RT ...
0
votes
0answers
7 views
ProtectedView error message when generating excel with NPOI excel library using C#, MVC
I am generating an excel file using NPOI excel library for .Net. I am using VS 2012, C#, MVC 4, razor html.
After generating excel with data from database, when I open the file, it displays below ...
0
votes
1answer
24 views
iPad app as wrapper for Excel Model
I've got an Excel file that takes ~10 inputs and outputs ~5 numbers. The problem is, the calculations run involve lots of assumptions, are rather complex, and laid out over 5 excel sheets with lots of ...
1
vote
1answer
21 views
Delete first four rows in Excel with Powershell
I have a powershell script that opens an excel file, re-assigns a blank password, and then saves the file. I want to add a task to the script to remove the first 4 rows of the excel file before ...
-1
votes
1answer
34 views
How to add quotations to words in an array to treat them like strings
In excel, I have a list of city names in a single cell that are comma delimited like this:
Melrose, Mott Haven, Port Morris, Hunts Point, Longwood, Claremont, Concourse Village,
Crotona Park, ...
0
votes
1answer
36 views
Selecting a range on merged workbooks
I need to change the range of the cell being copied and the location on where it is being pasted.
I don't know how to change the range of cells being copied ( i want it to select from A2 to the last ...