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
VBA Ultimate rounding
I've read much about rounding in Excel. I found out that VBA's Round() function uses "Bankers rounding" while Application.WorksheetFunction.Round() uses more or less "normal" rounding. But it didn't ...
-1
votes
1answer
12 views
Speed up Excel formulas
Is there anyway to rewrite this formula to speed up Excel processing?
My spreadsheet has become terribly slow!
=SUMPRODUCT((Sheet1!J:J=Sheet2!A2)*(Sheet1!G:G="Windows ...
-1
votes
0answers
10 views
How do I compare the display layout of two pivot tables displayed next to each other
Below is the layout of the pivot tables but they are displayed next to each other:
Pivot table 1:
Product
Product type 1
-- Type 1
-- Type 2
-- Type 3
Product Type 2
-- Type 1
-- Type 2
-- ...
0
votes
0answers
13 views
PasteSpecial (xlPasteValues) gives #VALUE
I have an excel spreadsheet that exports to a temporary file, before performing a mail merge.
This is achived through a copy/paste as follows:
Dim current As Workbook
Set current = ActiveWorkbook
...
0
votes
0answers
3 views
Excel 2013: Data Connection Wizard - Error on OData feed
When I try to import data from oData feed using
Data -> From Other Data sources -> From OData Data feed, I get the error:
We couldn't get data from the Data Model. Heres the error message we got:
...
0
votes
0answers
38 views
convert txt to excel with delphi
My work is convert .txt to excel
But,I am confuse because this file use MML.script.
Example:
ADD GCELL:CELLID=0, CELLNAME="ML037GA", MCC="510", MNC="08", LAC=471, CI=60911, NCC=1, BCC=1, ...
0
votes
0answers
13 views
Copying Data with Skipped Columns From Excel and Pasting into DataGridView
I've managed to copy from excel and paste it into a datagridview in C#. But when I hold down ctrl, select columns that aren't adjacent to each other, copy and paste into datagridview - all the columns ...
0
votes
1answer
22 views
Error while uploading Excel data to SQL server 2005
I have a requirement to upload excel data into a SQL Server 2005 table. Initially I copied Excel data to a temp table and based on condition I have updated and inserted records into the SQL Server ...
0
votes
1answer
15 views
Repeat some operation in the same column
I'm new to excel. I want to subtract All element of A from I1 and then divide it by J1. So, I use =(A1-l1)/j1 and then paste the same operation for other element but it doesn't work and the operation ...
1
vote
1answer
25 views
COUNTIF crashes Excel
I have an Excel sheet with date and email address columns, sorted by date. I want to count the number of times an email address is in the sheet prior to the current occurrence.
The COUNTIF(B$1:B1,B2) ...
0
votes
2answers
21 views
Limited access to tools and resources to exploit Excel data
I need to quickly sort/analyze data within Excel documents. I want to pull data that matches certain parameters from one Excel doc, count it, and then dump it in a particular cell in another Excel ...
-4
votes
0answers
14 views
use jquery to imitate microsoft excel perspective analysis' drag and drop [on hold]
guys,I want to use jquery to imitate microsoft excel perspective analysis' drag and drop.I have tried to use jquery ui plugin to do this,but failed.Could anyone give me a demo?
-2
votes
0answers
26 views
Excel, check if empty, if empty go to next worksheet [on hold]
I would like to summarize data I have on multiple worksheets onto one worksheet.
I need code for excel to check through the list and then when it hits an empty cell in one worksheet it continues to ...
1
vote
1answer
28 views
VBA Compile Error: Procedure too long
How could I shorten this code? Forgive me for bad coding practices I'm self taught and pretty much a noob.
The code is comprised of 199 "Elseif" statements, I don't know any other way to write what ...
0
votes
2answers
20 views
Excel 2010 - How to create sublist from list
Below is an example of the original column's information and the data I want to extract (using a formula, not a filter).
Where List 1 is column a and List 2 is column b
Example:
List 1:
1 Ok
2 Ok
...
