The 2010 version of Microsoft's spreadsheet application.
0
votes
0answers
12 views
VBScript in Windows 7 64bit Scheduled Task - Works with only run when logged in
So basically I have this VBScript that opens up an Excel 2010 instance, run a macro in it and close the spreadsheet. I am calling it using Scheduled Task to automate it. It ran beautifully when I was ...
0
votes
0answers
17 views
How can I get the spreadsheet fit to one page while printing when data exceeds page limit?
I have data in 40 tabs in a spread sheet which are not fitting into one page while printing since the data exceeds the page limit. I can do it by doing ALT+Enter at every end of the data line to fix ...
1
vote
1answer
35 views
conditional chart ranges in excel
I have a table of data in Excel 2010 that looks something like this (but with hundreds of thousands of rows over multiple days):
I am trying to create a dynamic chart where the x-axis is the ...
3
votes
1answer
31 views
Query Members of an Active Directory Group
So in active directory, there is a group called WebSiteUsers that is being used to permit access to a folder I am hosting via IIS. I was wondering (using DSQuery, ADFind or any freely available ...
3
votes
1answer
32 views
Excel conditional formatting fragmentation
Often, I create a sheet with conditional formatting, and set the cell ranges so that the conditional formatting rules are only applied once to a range of cells, e.g.
Make $A$1:$A$30 red and
Make ...
2
votes
1answer
23 views
Excel chart with twin axis
I have this data:
| km/h | mi/h
1 | 100 | 62.13711922
2 | 120 | 74.56454307
3 | 95 | 59.03026326
4 | 80 | 49.70969538
where mi/h is calculated from km/h column, by ...
1
vote
2answers
41 views
How can I make a cell's font transparent?
I'm creating a heatmap using Excel's conditional formatting. I don't want the cell's values to show against the color background. Is there a way to make the font's formatting transparent, similar to ...
1
vote
1answer
38 views
Refering certain rows in other sheets based on a particular condition
I require help for making the following table: Consider that I have three sheets in an Excel workbook.
The first sheet is the summary page. The next two are Subject1 and Subject2.
Each of these ...
1
vote
2answers
32 views
How do I legally run multiple instances of Office on a computer with Server 2008 R2
I have several people who need to work concurrently on a computer in my home office from remote locations. I have found that Windows Server 2008 R2 will allow multiple user sessions but I have not ...
1
vote
1answer
33 views
How to count based upon multiple conditions
I am trying to create the following formula
=SUM(IF(AND(K3:K138="Tekken",L3:L138="American Football"),1))
However, it always seems to result in zero, even where a single row would have both values ...
0
votes
2answers
23 views
Need simple macro for “match” formula
Are column B cells hidden somewhere anywhere in column C? Give results in column A. (true/false or yes/no)
I'm unable to post the simple Excel image I've created as I'm a guest, but it shows simply ...
1
vote
1answer
37 views
Select activation method from dropdown instead of writing it yourself
Answer at bottom of post
I got the code below to work but a question remains. When I copy and paste the code into my project it won't work. But inserting the outline of the call from the dropdown ...
0
votes
0answers
24 views
Paste html into Excel 2010 without Excel parsing the html
I'm running a query on SQL. Typically I can easily copy and paste the results from the query into Excel and it preserves the columns, rows etc.
However, in this case I'm selecting a bunch of emails ...
0
votes
0answers
34 views
Why does my Excel macro fail when run from a hotkey and work when run from the macros ribbon?
I am really confused by what is going on with a macro I created to parse out space delimited files. The macro runs successfully as long as I select the macros ribbon and the macro from the dialog box. ...
2
votes
1answer
55 views
Any way to have Excel 2010 treat a quoted value “08540” as text not number when opening a CSV
I have a CSV with data like this:
"08540",1,"PRINCETON","NJ"
I know that it is possible to specify "Text" when using the Import Wizard and defining columns. But is there a way to tell Excel to ...
0
votes
3answers
72 views
How do I separate three different phone numbers concatenated in one cell into three new rows?
I am doing work for a client and need to know how to separate these phone numbers.
I have
0121 396 0501 / 0121 123 434* / 0797 978 8265
in one cell and I want to end up with the same row ...
0
votes
0answers
35 views
Microsoft Excel - Is the following possible?
Okay, so I have a file with around 8,000 words to translate from one language to another and going through the file, there are words that sometimes are being listed multiple times. Is there a function ...
2
votes
1answer
33 views
Excel 2010 removes data from clipboard, how can I stop it?
The order of my actions is:
Copy data from pivot table from second sheet.
Paste data as value into first sheet.
Notice that something is wrong in the data.
Go back to the second sheet and change ...
0
votes
3answers
28 views
Nested IF statement
I'm having a problem with this code for nested =IF statement. The range is basically:
<=16 to get 5 pts
16-17 to get 4 pts
17-18 to get 3 pts
18-19 to get 2 pts
above 19 to get 1 pt
and my code ...
2
votes
0answers
36 views
Background colors in Excel 2010
I have an Excel 2010 spreadsheet. Right now, the entire background is at 40% gray, and need to be white/transparent.
There's no conditional formatting set.
The worksheet is not locked.
The ...
0
votes
0answers
25 views
Excel formula to copy text from another sheet1 to sheet 2
I am trying everything but nothing works. Please help me.
In sheet 1, when column 3 contains a specific word (like PTA), it must copy the whole row where that PTA word is in, to sheet 2. And the same ...
0
votes
1answer
40 views
Compare two date columns and highlight the newest
I have two date columns in the same sheet. Column B receives its data from a vlookup function.
COLUMN A | COLUMN B
2013-07-05 | 2012-01-01
What I want to do, is to compare the two date columns ...
0
votes
2answers
37 views
CTRL+D in Excel 2010 fills values and formatting, but I want it to only fill values/formulas
When you press CTRL+D in Excel 2007 or 2010 (and probably older versions), it makes an exact copy of the cell above it (modifying cell references, of course). In doing so, it copies everything else ...
0
votes
1answer
49 views
Merge multiple tables by comparing multiple rows
I have multiple three column tables that share two rows in common:
DailyCosts: DailyPrices
CodeRole CodeRegion DailyCost CodeRole CodeRegion DailyPrice
1 1 ...
1
vote
1answer
26 views
How to reuse existing values when using Solver in MS Excel 2010
I need to design a process layout in Excel using Solver.
I have a column of values, that I have assigned as "By changing cells", and which should be changed in order to find the min result. The ...
2
votes
1answer
35 views
Excel visual basic function across workbooks?
This seems like it should be a common issue, but I couldn't find anything on it, maybe I'm just searching for the wrong thing.
Basically I get sent a lot of workbooks that need specific modifications ...
0
votes
0answers
14 views
Deleting a Named Range crashes Excel
I am trying to delete a named range from the Name Manager. The named range is referencing a worksheet within my workbook. If I delete the named range and try to save the file excel crashes. What could ...
3
votes
1answer
39 views
How can I create a separate window in an Excel spreadsheet?
I am working on an excel dashboard. I have several sections and would like to create one section with a "window" of data. The data will be pulled from another worksheet from the same workbook. The ...
0
votes
0answers
10 views
How do you wrap text in an Active X Listbox?
I created an 11 column Active X Listbox. Is there any way to wrap text in a specific column? I have a column that includes customer verbatim from a survey that needs to be wrapped. Some customer ...
0
votes
2answers
26 views
Using conditions to write to new row on new sheet to return value
I would like to be able to use a data-entry page or form to keep track of monthly fulfillment of orders. We have some number of SKUs, lets say 10, and various number of orders against each SKU. ...
0
votes
1answer
42 views
Optimally positioning pie chart data labels in Excel with VBA
I have a worksheet where I create a pie chart from data from a database. The chart changes based on the data it is displaying so the slices often change size.
I want to display the data labels ...
-1
votes
1answer
17 views
How do I use VBA to choose a range depending on what's in another range?
I'm trying to figure out VBA and Excel and I've ran into some problems. I'm trying to select a range, and depending on if another column(P) is empty, I'll choose either column N or M to select.
...
-1
votes
0answers
47 views
Format multiple sheets with irregular headers in Excel
I am trying to format a price list from a supplier for import into my own database. The workbook the supplier generates contains multiple worksheets each with the same columns of data that I want to ...
0
votes
3answers
39 views
Counting occurrences in first column of a file in Excel
I need code to find duplicate numbers and continue to count the number of times the duplicate was found.
Example: I have 20,000 entries and 303 unique numbers. I need to know how many times each ...
-3
votes
1answer
47 views
How to code this macro? [closed]
Well, I tried to look this up on the internet, and I did find something, but I couldn't understand how I could change the macro to relate to my Excel document.
This is the link to my 'something I ...
1
vote
1answer
39 views
Database workflow advice? [closed]
I've got a product database that I need to update a couple of times a week and am looking for some advice on what workflow I should setup. I can export my database from my online store as a CSV, I ...
0
votes
1answer
35 views
Selecting Columns without Header
I am currently making a simple e-mail list to be used by my office for e-mail blasts. I want to have the first row a header (I currently have the first row frozen) and that whenever you click on a ...
0
votes
0answers
54 views
Need to find four common data columns in different locations in multiple workbooks
I am working from reports generated from different projects. Each report has varying columns but all have the four columns that I need. I would like to be able to boil the sheets down to these four ...
0
votes
1answer
20 views
Can I alternate row shading but also give columns colors in Excel?
I'm fairly inexperienced with excel, but I know how to both color a column in a table and also setup a table with alternating rows. What I am trying to do is have alternating row shading in a table ...
1
vote
3answers
41 views
Applying a one time formula to a cell range
I have a big range of data containing numeric values. but due to newer requirement to the maximum and minimum value the numeric data, I have to modified a lot of cells setting the value of each cell ...
0
votes
1answer
41 views
Using the advanced filter in Excel
I have 40 rows in Excel starting with a SerialID in sheet 1. In sheet 2 i have 109 rows which I would like to filter based on sheet 1. Sheet 1 contains records i want to hide from sheet 2.
0
votes
2answers
41 views
How can I use multiple IF functions in Excel 2010?
Well, I am putting multiple =IF functions in a particular cell in Excel 2010. The Value if True part of the function is A18*0.5, however when I put more =IFs in the cell then the Value if True is ...
0
votes
2answers
52 views
May someone be able to fix this function please?
Like, what is the problem with it?
=IF(F2>6,=A18*0.5,=A18*0.6)
It keeps on making it just say =A18*0.5, not the actual contents of half of A18.
So can someone try make this work?
All help ...
0
votes
0answers
28 views
How to change the conditions of a macro under circumstances?
Well, what I want to do is edit if a particular cell has a particular value.
For example, if cell A18 has any number higher than 6, it will make the value of cell O2 say =A18*0.5, however, if it says ...
1
vote
1answer
20 views
How to calculate values between three cells using conditional calculation
I am new to this forum and not very new to Excel (not in depth)
I have to perform a calculation for three cells by conditional calculation. so here is the scenario
Column Name: Total Area (Cell ...
1
vote
2answers
74 views
Excel 2010 Autofilter does not filter
I have been struggling with this for several days now and I would appreciate any help you may be able to provide. I have a sheet with 69 columns and 6600 rows called Raw Data. I also have a sheet ...
2
votes
1answer
28 views
Capitalize first word in each row of a column in mac
I want to capitalize the first letter of every word in each row of a column.
So I create a new column, type in =PROPER(B2), then drag that down the entire length of that column. It works great, it ...
2
votes
1answer
58 views
Make a mixed bar and scatter graph with Excel 2010
Before you post a comment saying that this is a repost - I would like to say that I have looked at the similar questions but some marked the question as answer without being a true answer (like the ...
0
votes
1answer
36 views
Add rows to insert dates from a “from” and “to” column
I want to breakdown an Excel sheet by having it in a specific format.
Right now, the sheet is like this
FROM TO TOTAL
01/27/12 01/27/12 1
03/09/12 03/09/12 1
04/11/12 ...
0
votes
1answer
79 views
In Excel I need to find data matches between two arrays - one horizontal and one vertical
In Excel 2010 (or 2007 - I have both, although my OS is only Win7 32 bit as a limitation for some legacy applications we run), I need to find how I can find and return the matching value from two data ...
