The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

1
vote
3answers
4k views

How to make a dropdown list such that… (see details)

I want to plot the stock prices of certain companies VS the S&P500. I have all the price data downloaded in my excel sheet already. I want to create a line graph in Excel. One line is fixed and ...
1
vote
1answer
12 views

How can I link value of a cell from another sheet according to the text which is already in the another sheet?

I am exporting a report from Quickbooks to Excel in a existing excel workbook. In that workbook a table is already created. I am exporting the report to a new sheet in the same workbook. Now I need ...
0
votes
0answers
13 views

Excel: Do not open files in multiple instances

How do I open all excel files in the same instance/window by default (happens only when I open from the menu, but not from the windows explorer)? I have this option unchecked, but is still not ...
0
votes
0answers
11 views

How to disable specific Excel 2010 add-ins at startup?

I want to disable specific add-ins from loading in Excel 2010 every time I open up a new workbook or instance. How do I achieve this? When I disable the specific add-ins by unchecking them in the ...
0
votes
0answers
11 views

Continue from one excel sheet to other without merging them together

i have an Excel workbook whic contain monthly sheets of sales. Each monthly sheet contains sale figures for various items (in columns) on a daily basis. the days are grouped in weeks. Now i want to ...
1
vote
2answers
2k views

Multi-row headers and excel 2010 sort/filtering

I have a spreadsheet which uses 2 rows for header information and some of the columns have the 2 rows merged together as one cell. I a multiple columns merged together in the first row, but the second ...
1
vote
1answer
64 views

Excel VBA - User Defined Function to turn string into formula

I'm looking for something similar to the solution posted here: Excel function that evaluates a string as if it were a formula? Problem is this does not seem to work with a function in there. This ...
2
votes
1answer
3k views

Split Text into Columns Function in Excel

I have an excel spreadsheet with rows of data as shown below. There is a code with the product name and then a number. QA32 Product One (Large) 23 AZ63 Product Two 96 PR65 Product Three 149 How do ...
0
votes
1answer
39 views

Compare Excel Columns A & B and return C

I am a High School Principal and I need help figuring out how to use excel to create a class tracer for my students. A tracer is a spreadsheet that tells you what classroom a student is in during a ...
0
votes
1answer
16 views

LO Calc / Excel - Dropbox change another cell

I am creating a simple Point of Sale System for a store using an excel/libre office spreadsheet. The spreadsheet has a sheet called "Inventory" which has the following columns: Name Price This ...
0
votes
0answers
7 views

Can I use a GUI to import seperate sheets into another workbook?

I am trying to export a single sheet from three seperate excel workbooks to three seperate sheets in one master workbook. I then have to print this master workbook to a pdf, then repeat with three ...
1
vote
2answers
30 views

How to highlight calendar cells based on given start and end date

For a while now, a coworker has been using a chart similar to the one shown below and wants to automate it (i've already added the days before/after due date). The chart is printed or worked on at ...
4
votes
9answers
38k views

Copy Excel worksheet and maintain relative cell reference in formulas

Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes ...
-1
votes
0answers
13 views

How do I make XML Excel files to be opened by Excel by default?

I would like to have Excel files with the extension .XML on the Excel 2003 XML format to be opened by Excel by default. The rest of XML files should be opened by a regular text editor. My files do ...
2
votes
1answer
966 views

Opening 1GB+ XML file for editing [duplicate]

Running Windows 7 64-Bit w/6GB RAM. Attempting to open a 1GB XML file in an attempt to repair an Excel Spreadsheet. I have tried other tools but all caused memory errors. I even tried sed (Windows ...
1
vote
1answer
100 views

Excel “Go To Special” Crashes on Large File

I'm trying to find all cells that have constants. I'm use excel 2010 and the file has 206963 rows and 9 columns. They are all filled with constant values. When I search for constants excel crashes. ...
1
vote
2answers
6k views

Delete default template in Microsoft Excel 2010

A default template has accidentally been made and continues to open on start up of Excel. How can I delete a default template in 2010?
0
votes
0answers
22 views

How to enable macros by hard coding using VBA

I have an attendance tool in MS Excel which is built by having macros. Now the task is to enable macros in customers system by hard coding in the same tool itself when they using this tool for the ...
2
votes
2answers
22 views

How do I drag formula in Excel

I need help with with Excel on trying to drag the formula down without having to copy and paste all the time Example: Column A Row1 =(A1/A2)*100 Row2 =(A3/A4)*100 Row3 =(A5/A6)*100 ...
3
votes
1answer
230 views

Why would an Excel 2010 spreadsheet with VBA lag when opened with other large excel spreadsheets already opened

I've got a relatively small (~100K) Excel 2010 spreadsheet that (via VBA) when opened, closes all worksheets except the start page, checks the user name and cross checks it with a SQL table, bringing ...
0
votes
0answers
18 views

Copy rows from one Excel workbook/worksheet to auto-populate another workbook/worksheet based on text and date criteria?

I have two Excel 2010 workbooks with one worksheet in each (A/"2014" and B/"Allo 2014"). I need to have Excel find each row in worksheet "2014" where U2:U253 equals 'Allo' and AI2:AI253 equals ...
0
votes
1answer
7 views

Prevent Excel from scrolling all the way to the right when adding filters to column headers?

Whenever I add filters to all column headers in Excel 2010 and I have enough data to have to scroll horizontally, it jumps me all the way to the rightmost column. Whatever cell I had selected is still ...
-3
votes
0answers
28 views

I need to know the formula for below [closed]

I need the formula to find the intersection value on table. now when i enter the zone & billable weight, then it want to show the correct intersection value & one more trick is also know the ...
1
vote
2answers
6k views

Very infrequent Excel crash

Have 1 user who keeps experiencing an Excel crash when sorting data. It is very infrequent and as of yet i've not done any serious troubleshooting, just an Office repair. Event log reports the ...
0
votes
1answer
32 views

in Excel, Can I replace “sheet1!” with a formula?

I have 100 sheets named as 1,2,3....100 then in each sheet, there's a value in cell A1. I am building a summary sheet now, in the summary sheet, I want A1 = 1!A1, A2 = 2!A1, A3 = 3!A1 ...... A100 = ...
0
votes
1answer
23 views

In Excel, how can I automatically change the data of a cell (VBA)?

I would like to automatically change the contents of cells when data is pasted into them. The data will be pasted into Column Q of a sheet on Excel. I need it to match it with data in Column A of ...
5
votes
3answers
6k views

Why is Excel truncating my 16-digit numbers?

If I type in a 16 digit number (format: number, no decimals) it changes the number on me. Example: 1234567812345678 changes the view to 1234567812345670. If I type it in as a general format it ...
2
votes
2answers
32 views

How can I get information from one cell in a row, based on the clue of 2 other cells in the same row?

I'm trying to get Excel to give me information in Column C based on the values in Columns A and B. Cell A and Cell B will contain duplicates, and what I'm trying to do is build a formula which finds ...
-4
votes
0answers
23 views

Excel copy paste if macro vba [on hold]

In excel, can you help me build a macro/vba for this task: Copy-paste $M$1:$N$1 to Column M:N, if Cell in column C="price". Thank you all!
0
votes
1answer
21 views

How to compare a column with previous column when the new column has more data sets in it?

I am trying to compare weekly account sales numbers to their previous weekly amount. However the new week has more accounts in it (on average 50 more) than the previous one, how can I add these ...
0
votes
0answers
45 views

Plot two time dependent series in Excel 2010 when the number of data points are different but start and end time are same

I'm trying to plot graphs for pressure and temperature recorded on different devices. The number of data recorded for each device is different (Eg. pressure has 1 reading per second while temperature ...
0
votes
1answer
27 views

How to apply formula to a cell dependent on data from drop down list

I hope I can word this to where it makes sense. I'm working on a budget. Basically broken down by month. So in the budget, if it is February, I have to estimate the remaining months of the year. I ...
0
votes
1answer
18 views

Merge two worksheets with different headers with one similar column

I need to merge two data sheets in excel. Each worksheet has a common column, the number, but some numbers are on one page but not the other and some are on both pages. Additionally, all of the ...
0
votes
1answer
21 views

Highlight Duplicates Not Next To Each Other Using Conditional Formatting

We have a list of parts in Excel in a certain order. For reasons I won't get into, we need to highlight when there are duplicates that aren't next to each other. Currently, I'm using this formula in a ...
0
votes
1answer
23 views

Random Sampling in Excel based on specific criteria from other colums

I have a list of file numbers in Column A, a code associated with the file in column B, and a number of days in column I. Example: File Code Days 12345 AAAA 100 54321 AAAA ...
0
votes
1answer
15 views

How do I exclude blank cells when trying to count unique values separated by commas for multiple cells

I'm trying to come up with a formula that will count unique values separated by commas for multiple cells and count the blank cells as 0. Example: X2; 875 Y2; 575,628 Z2; Blank Should equal ...
1
vote
1answer
129 views

Listing/grouping variables in PowerPivot table field list

I have data with 60+ variables and I would like to group the variables into different collapsible fields in a pivot table, similar to having different tables in the pivot field list - ie, instead of ...
0
votes
1answer
21 views

Chart the TIME something happened on a series of DATES

I have two columns of data. Column 1 is the DATE (i.e. 1/5/2011 ) Column 2 is the TIME a thing happened on that DATE (i.e. 16:42 ) I need the DATE to be on the X axis and the TIME to be on the Y ...
1
vote
1answer
387 views

How to input date range in word for SQL query?

I have an Excel file that uses an SQL query to pull inventory usage of the medications in our pharmacy over a period of time. I currently just have to go to Data > Connections > Properties > ...
0
votes
1answer
3k views

Any trick to calculating percentages when the base is a negative number

I am trying to calculate percent change when the base number (at time 1) can be a negative and the resulting number is positive (at time 2). My problem is the percent change from -4 to +4. A change ...
-2
votes
1answer
19 views

Return segment of statement that makes it TRUE

H I J K L M Lenght Width Height Compare_Length Compare_Width Compare_Height 3.750 3.750 4.500 3.750 3.750 ...
0
votes
2answers
19 views

Sort Excel Row Based on Values in Another Row

Sorry if this question has already been answered, I looked but I didn tfind anything that was quite what I am trying to do. I have a lot of spreadsheets where I have something like: A|B|C|D|E|F... ...
1
vote
2answers
116 views

How to fit mm/yyyy in SUMIF criteria

I've looked around for answers regarding this, but am still a bit confused. I have a column A in Excel with dates in the format mm-yyyy (i.e. September 1014 is Sep-14). I want to add all the values in ...
0
votes
0answers
27 views

how to get exact value from Y axis and X axix for any point in chart

I have a chart with line graph. now for a particular point on the line how can i get the exact co-ordinates from Y axis and/or X axis. For example if the major unit on Y axis is 200 and Minor unit is ...
0
votes
3answers
41 views

group values in set of 5 and then return the first value from each group

I have a long list of values of a stock in minute format. The column C shows the open values(per minute) and column F shows the corresponding close values Now I want to covert this data into 5 min ...
-3
votes
2answers
36 views

how can i make an excel graph of this data (two)

Mean ± SD baseline Mean ± SD Final 56.7 ± 6 84 ± 14 82 ± 13 34 ± 5 33 ± 4.5 42.79 ± 3.19 40.45 ± 3.48 46.75 ± 9.64 ...
2
votes
1answer
26 views

Excel 2007 Formula Issue - Newbie

I have a cell containing 5;9;11;13;15;17. There could be upto 15 different numbers in the cell. These numbers represent attributes. For example 5 = Padlockable, 9 = Keylock etc. There are around 50 ...
3
votes
1answer
2k views

Macros in Excel 2010 hangs

I have a spreadsheet with several macros. Generally, when previously using Excel 2007, a user clicks a button and everything works as expected (calculations, some email sending & file I/O). ...
1
vote
1answer
28 views

Openoffice / Excel combine multiple worksheets into one

I have not yet found the exact answer to my specific problem, so let's give it a shot : The Layout : 1 SharePoint Farm on which a report was run, returning 6 Excel Files with each containing 250 ...
1
vote
1answer
5k views

Excel Help: Fill Tool - Drag to the side (across columns) but increase the formula by Row Number

There are answers out there to this question, but all of them have been under explianed so hence to difficult to coprehend and use them to my advantage. I want to do the seemingly simple (but not) ...