The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

7 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 ...

**0**

votes

**1**answer

36 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

**1**answer

14 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

**0**answers

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

**2**answers

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 ...

**-1**

votes

**0**answers

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 ...

**0**

votes

**0**answers

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 ...

**0**

votes

**0**answers

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 ...

**2**

votes

**2**answers

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
...

**0**

votes

**1**answer

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

**0**answers

28 views

### I need to know the formula for below [on hold]

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 ...

**0**

votes

**1**answer

31 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 = ...

**-4**

votes

**0**answers

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

**0**answers

44 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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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 ...

**0**

votes

**1**answer

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

**1**answer

20 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 ...

**0**

votes

**1**answer

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 ...

**-2**

votes

**1**answer

18 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

**2**answers

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

**2**answers

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

**1**answer

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 ...

**0**

votes

**0**answers

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 ...

**2**

votes

**1**answer

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 ...

**1**

vote

**0**answers

14 views

### How to select a cell relative to a button with a macro?

I am trying to create a macro in Excel which I can assign to a number of buttons (one in each row), each of which will operate on the data in the row in which the button is located.
Is it possible to ...

**-1**

votes

**0**answers

21 views

### Standard deviation per month in certain year excel

So I have a dataset containing daily stock prices of over 20 years. The dates are the top row and all the companies in the first column. And per date per company is a certain return. Now i want to use ...

**2**

votes

**2**answers

22 views

### Excel: Trying to create a sortable table with 2 rows connected to each individual row in the table

I really don't know how to explain this and I cannot post the picture I made because I'm new. But here goes.
What I'm trying to do is have a table in columns A and B which skips every other row when ...

**0**

votes

**0**answers

17 views

### link excel sheet to word doc and be able to change multiple cell values at one time [closed]

I would like step by step instructions on how to link excel sheet to word doc and be able to change multiple cell values at one time. I have linked up several tables but then if I move to another ...

**2**

votes

**2**answers

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 ...

**1**

vote

**1**answer

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

**1**answer

29 views

### Excel formulas: Dates A, B, C and D. How many days between A and B also fall between C and D

Example:
A1 = 8/5/2004
B1 = 29/12/2004
C1 = 1/1/2003
D1 = 21/11/2004
I want to work out how many days between A and B also fall between C and D. I can't get my head round what the formula to work ...

**1**

vote

**0**answers

14 views

### How do I change the function field in excel to show Bengali Characters?

I received an excel file that has columns translated from english to Bengali. I have a Bengali font installed and it shows up in the main body of the spreadsheet but the characters are not showing up ...

**2**

votes

**0**answers

28 views

### Can you preview Office 2010 files in Outlook 2013?

Issue:
One of our users is using Outlook 2013 and Excel 2010 on a Windows 7 machine. When she receives an email with an Excel file attached, she is unable to preview the Excel file. She gets this ...

**0**

votes

**0**answers

13 views

### Dynamic Scenario output in excel

I have a model where in the input numbers going into the model depend on the cases/scenarios i select from a drop down menu ( Base, Best and Worst). These numbers are then used across all remaining ...

**0**

votes

**0**answers

4 views

### Find max with duplicates XL2010

I have a table and need to find the max in each row, I want it to bring in the header, but there are duplicates, E.G. COLUMNS A-D, columns A and B have 2 and C 3, D 1. I want it to say A, B. Can ...

**1**

vote

**1**answer

22 views

### Flip x and y axes in Excel graph

This should not be very difficult, but I cannot figure out how to do it.
I have a table similar to this
%low %high
0 0 12
1 13 26
...
19 90 94
20 95 100
When I graph it, excel ...

**0**

votes

**0**answers

21 views

### direction does to RTL in Excel when I add sheet

When I add a new worksheet to my workbook in Excel 2010 (by clicking the button insert worksheet next to sheet names), one sheet will be added and the direction goes to RTL from LTR automatically and ...

**0**

votes

**0**answers

14 views

### Why Powerpoint 10 is not opening a file from network?

I upgraded my power-point from 2007 to 2010 recently. Upgraded version is working fine with all the files inside my laptop. But when I tried to open a file from a shared location it fails with a error ...

**1**

vote

**1**answer

39 views

### Use data from a drop down list to populate table

I am trying to make an employee recognition tracking tool. I would like to have in sheet 1 a drop down list of all the employees in the hotel and a drop down list of the month.
When an employee ...

**-1**

votes

**2**answers

26 views

### Excel: Complete row Hash Value calculated as a Numeric value in a cell on same row

I have to manage "Change Control" on Excel spreadsheets comprised of 1000's of rows and dozens of columns.
Downstream Teams often submit revised columns that I have to incorporate into a master ...

**0**

votes

**1**answer

19 views

### Can Excel 2010 Cell Formula Reference Another Cell For A Portion Of The First Formula?

Perhaps this is not doable, but all I can do is ask.
I am using MS Excel 2010. I am going to greatly simplify the issue.
I have a column of many, many cells that all contain the same, very large, IF ...

**0**

votes

**4**answers

49 views

### Excel - How to add cells that have letters and numbers

For example:
A1 - "AA123"
How do I get B1 to read "AA124" and C1 to read "AA125"?
I know that in A1 I can drag the box to the right and it will populate with this, but I need a formula for this. ...

**-1**

votes

**2**answers

17 views

### How to remove some duplicates in Excel

I want to remove all but the topmost value of duplicates in Excel. For example,
I have this:
A B C
R123 5 35
R123 5 14
R123 5 27
R345 89 19
R345 89 42
But I want ...

**-1**

votes

**1**answer

38 views

### Closest thing to variable in Excel formulas( not VBA)

I have following formula
=MID(G34,FIND(" ",G34),FIND(" ",G34,FIND(" ",G34)+1)-FIND(" ",G34))
G34 ="begining middle end"
The goal of this formula is to return "middle" and it achieves it, but the ...

**-3**

votes

**2**answers

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 ...

**0**

votes

**2**answers

37 views

### How to calculate with Microsoft Excel the correct amount of minutes?

64 people receive services 105 minutes per day. How can i use Excel to calculate the total minutes of service per day and then multiply by 7, so i have the total amount of minutes per week, and then ...

**0**

votes

**3**answers

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 ...