The 2010 version of Microsoft's spreadsheet application.

**-1**

votes

**2**answers

14 views

### Finding the largest value in a 2-dimensional range and returning the column header

I've been struggling to find a solution to locating the maximal number within a 2-dimensional range and then looking up the column header that the maximal number falls into.
For example:
I'm ...

**0**

votes

**0**answers

19 views

### Excel formula sumarizing items over quarters of year

I need a formula so that I can display the S/N in Figure 1 to appear in Figure 2.
I need to categorise the S/N by quarter.
This is the data table:
S/N RailCorp Ref Number Date In
77203 ...

**0**

votes

**1**answer

10 views

### User Input to Select and Fill In value for Cells

I have this excel table: A2 to A11 are class names Class_1, Class_2,..., Class_10.
B1 to K1 are student name 1,2,3,...,10
For each student in his class, I will need to fill out his grade
I would ...

**2**

votes

**2**answers

21 views

### Indicating trends within sparklines in Excel

I have created a load of sparklines in Excel for a variety of diseases over time. However, in order to identify trends from these sparklines, it would be useful to include a little more information ...

**0**

votes

**1**answer

20 views

### Auto-fill rows from columns in another sheet?

I'm using Google Doc's Spreadsheet at the moment and I'm attempting to create the same view in another sheet.
First Sheet:
(yes I need these merged cells)
Second Sheet:
Unfortunately Google ...

**-2**

votes

**0**answers

14 views

### I have 13 spreadsheets with names I have to ensure that the 14th sheet does not duplicate any of the names

I have to send a sheet in every day with a list of names and their date of birth after 13 days the 14th days excel sheet cannot have any names previously used. Is there a formula that I can use that ...

**0**

votes

**0**answers

11 views

### How to trigger on dates in Excel and post in calendar [on hold]

A client has info in an Excel file. Tracks medical people with certification renewal dates, etc...
How can notifications based on dates automatically post in a calendar?
Is it feasible from Excel, or ...

**2**

votes

**0**answers

21 views

### Newlines in description of imported csv in Outlook Calander

I have exported a list of birthdays from excel to csv.
Now I want to import them in Outlook as calander items.
Everything works fine exept I can't do newlines in the desciption.
I've already tried to ...

**1**

vote

**1**answer

15 views

### Office 2010 on Mac OS 10.8: Drawing a Chart

I have a simple data set and I want to make a graph for it.
Years Upper Band Lower Band
2010 0.73 0.63
2020 1.04 0.83
2030 1.36 1.06
2040 1.74 1.31
2050 ...

**1**

vote

**3**answers

25 views

### How to remove duplicate values in col A from col B in MS Excel?

I need to remove the values from column B that exist in column A in an Excel spreadsheet. Data > Remove Duplicates doesn't seem to offer this as an option, so how else can I do this? I need to remove ...

**1**

vote

**1**answer

20 views

### Excel automaticly adding an extra row which already contain formulas for the inputed number of years

I am looking to build a model, I would like is have an input page where you input the range of years you would like to cover. Depending on the inputted number of years, I want a table (on a different ...

**0**

votes

**1**answer

20 views

### How to have a cell that displays the cumulative value of all values entered in another cell?

I want to have a cell on my spreadsheet that updates in a cumulative manner, in response to values being changed in another cell. What would the code for this cell be?
For example the original value ...

**0**

votes

**1**answer

20 views

### Ignoring value IF “[Value_if_false]”

I am trying to figure out the average difference in monthly sales versus previous years, and I have an IF function within an Average function. I want to skip zero values in the average function if the ...

**0**

votes

**1**answer

34 views

### Excel 2010 area chart drop off

I'm trying to create an area chart that shows data over a year. All the data for each month always add up to 100%.
An image is probably worth 1000 words, so here we go:
I would like the area ...

**0**

votes

**0**answers

10 views

### Remove duplicate data for same week in Excel 2010

I pull a combined data for different employees for payroll and if they used R,3,X (codes for payroll). When I pull the data, the report duplicates the employees because if there is an R or 3 for the ...

**0**

votes

**0**answers

13 views

### Can't edit textbox

I just inserted an ordinary textbox in an Excel sheet. Now for some reason, the text box is not selectable at all. When I hover the mouse over it, the cursor turns to a circle with a sloped line ...

**1**

vote

**1**answer

22 views

### Dropdown, multiple values in dropdown

I'm trying to make something for my hobby, and for that I was wondering on how to do it:
These are my input values:
And via dropdown you can choose one player and it autofills the other values:
...

**0**

votes

**1**answer

19 views

### Formula that returns all the different text strings in a range

I have a row with multiple models of cars. Every model in own cell but models repeat multiple times. I want to create formula in Excel 2010, that returns every different model just once.
Look like ...

**-1**

votes

**0**answers

16 views

### Comparing and updating two excel sheets

In one excel file I have have 7 sheets divided according to users.
My second excel file has one sheet which keeps adding data after each month. So I need help in developing a method by which -
I can ...

**0**

votes

**3**answers

16 views

### Spell check across multiple work sheets in excel

Im trying to spell check across multiple sheets in excel and I've come across numerous sites that say you can select all worksheets in a doc, then when you use spell check it should check all sheets.
...

**-1**

votes

**1**answer

24 views

### Has anyone found a way to compare two excel worksheets in office 2010? [closed]

"Has anyone found a way to compare two excel worksheets in office 2010?"
This solution could be in VBA or with formulaic solution.
Not with third party applications, add ons, or other cheating ...

**0**

votes

**1**answer

21 views

### Is there a way to add a scroll bar to a few columns only in Excel?

Most columns in my Excel sheet are only filled in till about row 50. However, I have 3 consecutive columns that are filled in till about row 150.
Is there any way I can add a scroll bar to these 3 ...

**0**

votes

**1**answer

17 views

### How to count only shown in filter heading using COUNTIF (Excel 2010)

I have a list of names, company, meals etc. and there is a filter in each column.
In the top, there is a list of the 5 type of meals, and COUNTIF() is used to count the different types of meal in the ...

**0**

votes

**1**answer

29 views

### Using VBA to calculate unique random numbers in “i” number of rows

I am currently working on a pet project of mine. I am currently making a combat calculator for a gaming group I DM. Essentially, I have a table with the monsters and their stats, and a cell with the ...

**2**

votes

**1**answer

32 views

### What does “--” used in Excel function mean?

I came across this reference in a spreadsheet I'm looking at and don't understand what it means.
=SUMPRODUCT(--NOT((ISBLANK(CONSTRUCT))))
Can anyone tell me what the -- in front of NOT refers to?
...

**0**

votes

**1**answer

9 views

### working with dates and returns

I am doing a training matrix for my company where I enter the date of which a person has been trained and in the next cell automatically updates to the next time the employee has to be trained I have ...

**-1**

votes

**0**answers

20 views

### Excel 2010, IFERROR, INDEX, MATCH

I've got a sheet consisting of various lines like the following.
POH-00006366 CYM001 Cymot NAD 6000
POH-00006366 CYM001 Cymot NAD 7000
POH-00006366 CYM001 Cymot NAD 8000
...

**1**

vote

**0**answers

14 views

### Adding numbers based on their relative position in a worksheet

I have nearly 10,000 numbers arranged on an excel worksheet to form the map of USA.
Now I want to separately add the numbers based on below mentioned four criteria:
1.0 Corner cells i.e cells flanked ...

**0**

votes

**1**answer

28 views

### Excel 2010 Cell Formatting

I have a crew schedule made up in excel. There are 4 different shifts A B C or D. There are 5 people on the schedule, and the schedule is laid out like this in excel:
Each person works the same ...

**0**

votes

**1**answer

22 views

### Timestamp in Excel…not working?

I know this question has been asked numerous times, and I have truly searched and attempted to work it out with the given solutions to no avail. Maybe I'm doing something wrong, but I don't know much ...

**0**

votes

**1**answer

22 views

### Same formula with different results in R and excel?

I have calculated the load for 3 water quality parameters in R for specific days for the whole year using this formula.
I calculated 7 scenarios using the previous formula. Each scenario represent ...

**0**

votes

**0**answers

6 views

### Excel pivot table importing formula rather than value

I'm just starting to use pivot tables and I'm running into this simple issue. I have a load of data imported from a database. In one of the columns I use a lookup to convert a number into a string.
...

**1**

vote

**1**answer

75 views

### Excel - Parsing data to template

I'm not sure if this is possible in Excel.
I have a sheet that looks like:
+---------------+-------+--------+-------+-------+-------+-------+-------+-------+
| | August ...

**0**

votes

**1**answer

32 views

### Excel Pivot Table - How to preserve Filter and Sorting when Data get refreshed

I have a pivot table (Excel 2010). Every Time when I update the data and make a refresh, the sorting and filters of the Pivot Table get lost repsectively I need to explicitely to modify the filter ...

**1**

vote

**1**answer

20 views

### Excel Deleting duplicate entries

I want to delete duplicate entries in the following table:
The problem is that I only want to delete the duplicates in the left hand column, and the right hand column entries must stay with their ...

**2**

votes

**2**answers

28 views

### SUMIF/ COUNTIF (look up names from column 1 then sum numbers from column 2)

I need to look up names from column 1 then sum numbers from column 2. Some names in column one appear more then once. (The spread sheet I am working on has 7400 rows!!!)
Example:
Column A ...

**0**

votes

**0**answers

9 views

### How to Merge Rows based on Row condition in same table

My base data is like
Team Defect id Status testcase tc status
Communication 23423 Closed TC001 No Run
Communication 23545 Closed TC001 No Run
Communication ...

**-1**

votes

**0**answers

15 views

### Selecting values from different rows in an Excel 2010 table and merge them in order in a sinlge row [on hold]

I want to use a formula, or set of formulas, for selecting values from a data table were the number of values differ between rows (see attachment). I do not want to cut and paste or use any commands ...

**0**

votes

**1**answer

34 views

### VLOOKUP using dynamic workbooks in VBA

How do I capture a new workbook (with link location) using VBA and automatically run VLOOKUP to get the data and populate a table in another workbook?

**-1**

votes

**1**answer

10 views

### Excel - need to find all cells in column B where the numbers are in sequential order

Here is what I have
A B C
ICING VEMAG FILLER 200034 200034
RSD BULK 200035 200035
RSD TRAY ...

**-1**

votes

**3**answers

32 views

### how to remove multiple data in excel

I have a email list on excel
that looks like this:
123@abc.com
ad@aaa.com
ydd@asd.com
offf@rty.com
7ff@vvc.com
ass@aaa.com
yss@asd.com
oas@rty.com
I want to remove the below data from email list.
...

**0**

votes

**0**answers

12 views

### Compare two columns on sheet 1 with two columns on sheet 2 and return a value from sheet 2 to sheet 1

I have one sheet that has names, location and numbers
Name Location Number
Bill AA 1234
Bob AA 5678
John CC 1234
Suzy CC 1234
and another sheet ...

**0**

votes

**1**answer

21 views

### How to display series name inside bars of stacked bar chart?

I have a very busy stacked bar chart, some 20 or so series over time
I am not interested in the actual numbers, I just want to show the overall trend over time.
The default colours in Excel 2010 are ...

**0**

votes

**1**answer

21 views

### How can I copy from a shared .xlsm file without having to rename every sheet I copy?

I have to copy data from six (6) different shared .xlsm files. I used to use the Edit - Move or copy sheet to our Data in progress file, in which I run macros to convert the data to the a format that ...

**1**

vote

**2**answers

25 views

### How can I hide 0% value in data labels in an Excel Bar Chart

I would like to hide data labels on a chart that have 0% as a value. I can get it working when the value is a number and not a percentage. I could delete the 0% but the data is going to change on a ...

**1**

vote

**1**answer

17 views

### How can I demonstrate that a user data validation selection clashes with a previous user data validation selection?

Using multiple tiers of drop down lists, I have created a series of user selections. The user selects from the first list on the left. Then depending on the first selection 'Role', the user can select ...

**0**

votes

**2**answers

20 views

### When I change number of decimal places then value in the cell changes

For example I set 5.555 to the cell. When I change number of decimal places to 2, value changes to 5.56. If number of decimal places is 0, value in cell is 6.
If I add decimal places it does not ...

**0**

votes

**0**answers

29 views

### Why am I unable to sort data in Excel?

Here is what my spreadsheet looks like:
I am trying to sort these invoices first by type (Column B) then date, and finally by amount (which shouldn't apply, but why not).
I have checked for ...

**0**

votes

**1**answer

22 views

### Add a series to a chart by pasting its formula no longer works in Excel

I used to be able to add a new series to a chart by typing or pasting a =SERIES() formula into the formula bar when a chart's PlotArea was selected, as indicated here: ...

**0**

votes

**1**answer

28 views

### Filter data in Excel based on column values matched to another column

I have this fairly easy to understand task but I can't figure out how this works in Excel.
I have a datasheet with a column (say ID, ranging from 1 to 10). On a second sheet I have a column (say ...