# Tagged Questions

**1**

vote

**2**answers

19 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

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

**0**

votes

**1**answer

14 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

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

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

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

**0**

votes

**1**answer

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

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

**0**

votes

**1**answer

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

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

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

**-1**

votes

**3**answers

31 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

**1**answer

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

**1**

vote

**2**answers

24 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

19 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

21 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

**0**answers

12 views

### How can I calculate the grouped averages and maximums per day for a range of dates and times?

I have a CSV dump describing the utilisation percentage of some servers in my organisation, covering data samples from several times per day. Each server belongs to a group. For each group, I have to ...

**0**

votes

**0**answers

10 views

### Saving Excel to fixed Width format - extra tabs

I have a VBA macro that takes a spreadhsheet and turns it into a fixedwidth format in another sheet using the first column only. When I save it, it always seems to have extra tabs in the text file at ...

**0**

votes

**1**answer

19 views

### Calculate Break Point Weight

I have a table like so:
Miles Weight Rate
50 1710 54
50 3417 44
50 7253 38
50 12025 36
50 16052 35
100 1716 55
100 3429 45
100 7269 39
100 12027 37
100 16055 36
Where ...

**0**

votes

**1**answer

17 views

### AVERAGEIF based on formatting

I am using Microsoft Excel 2010. I would like to do an AVERAGEIF, with the criteria based on formatting.
Ex: For cells, I choose A1-A3.
A1 is the percentage value 10%.
A2 is the number value 20.
...

**0**

votes

**2**answers

30 views

### Excel COUNTIF range search returning #N/A

I'm using Excel to search multiple days (my ranges) in a timesheet for hours worked (my HLOOKUP reads the value below the dept number) by multiple members of staff for different departments.
I've ...

**0**

votes

**1**answer

24 views

### Make excel assume that I want to open my xlstart file readonly

I have a workbook called Book1.xlsx in my XLSTART folder. Is there a way to tell excel that I want it to always open this file as readonly unless I specify otherwise? There are two reasons I want ...

**0**

votes

**4**answers

28 views

### Excel - How to merge rows from 2 tables based on a common column?

I am trying to merge 2 worksheets where only one col matches in content.
Column"A" in both worksheets have matching values but all other fields are different.
Worksheet1
Col"A" colb colc cold
...

**0**

votes

**0**answers

35 views

### How do I make a function update dynamically when I make changes to the function in a “master” cell?

For example, column 1 would contain input data, and subsequent columns would perform actions on that data.
Row 1 would be the master row. All changes to the formulas in row 1 would be duplicated ...

**0**

votes

**2**answers

28 views

### How can I find max value for a text as unique identifier in Excel?

This is basically for an auction setup in Google spreadsheet.
Say there are 26 bidders A to Z and each bid 5 times with different values. I need to find the max value bid by each of them and display ...

**-1**

votes

**2**answers

52 views

### Power Pivot - Average time per item

I'm trying to calculate on average, how long it takes to make each item.
Here is the data table:
Date Item Quantity Operator
01/01/2014 Item1 3 John
01/01/2014 Item2 5 ...

**0**

votes

**1**answer

23 views

### How to Run macro in excel instance “2” from excel instance “1”

Lets say i have already opened Workbook 1 in Excel instance 1 and Workbook 2 in excel instance 2
And i have macro called "AAA" in instance 1 and "ASD" in instance 2
i want to call "ASD" in instance 2 ...

**0**

votes

**1**answer

45 views

### Populate default value to a cell based on another cell content

We use a spreadsheet as our time cards. The template is stored in a server with links to it on the individual's desktops.
I am trying to figure out VB code that would help in achieving the flliwing: ...

**1**

vote

**1**answer

33 views

### Comparing two strings in excel, add value for common variables

I'm comparing two large datasets containing strings in excel. Column A contains the numbers 1-1,000,000. Column B contains 1,000,000 strings, neatly organized in the desired order. Column C contains ...

**0**

votes

**0**answers

25 views

### Histogram - adding vertical line (x-value) - Excel

I have created a histogram from a list of data:
-0.0892 8
-0.0711 16
-0.0529 19
-0.0348 13
-0.0166 5
0.0015 12
0.0197 5
0.0378 5
0.0560 3
0.0741 4
0.0923 5
0.1104 1
I would like to add a ...

**0**

votes

**2**answers

50 views

### SUM From Sheet 1 Columns to Sheet 2 Rows

Tried searching for a while, didn't see what I was looking for.
On Sheet1, I have approximately 100 columns, each representing an item. Each row is populated by a quantity of that item. As you can ...

**1**

vote

**1**answer

19 views

### Comment in fixed line in Excel gets truncated when I scroll down

I have an Excel sheet with a fixed header (first row is fixed) and some of the cells in this header contain comments. When I don't scroll down and hover over the cell, the comment is fully visible, ...

**0**

votes

**1**answer

23 views

### Can I use excel to read barcodes and take me to a specific cell?

I work for a community group that holds an annual fund raiser for charity over a weekend. I am an excel user and am wanting to set it up so that I can assign a barcode on a card to a specific person. ...

**0**

votes

**1**answer

22 views

### Named ranges changing randomly in Excel 2010

I'm trying to create some named ranges in Excel that extend using the offset function based on the number of non-empty cells in a column, with the general formula:
...

**1**

vote

**0**answers

24 views

### What can slow down Excel in copying worksheets, but doesn't slow down general responsiveness?

I've got a fairly complex workbook that I'm building, and it looks like it's going to need a number of the sheets copied 10-20 times over - where each copy operation takes ~45s at the moment (over ...

**0**

votes

**2**answers

37 views

### Excel 2010 Data Connection - Add Filter to Command Text

Two relevant workbooks:
Historical Data.xlsx with a table GLDATA, which includes a field cc
Template.xlsx with a named range COSTCENTER
Question: How do I modify the Command Text in the Data ...

**0**

votes

**1**answer

27 views

### Excel 2010- Document Contents Not Scrolling with Scrollbar

For some reason on a couple of computers, Excel 2010 is having issue with the scrollbar.
When the vertical scrollbar is dragged, the contents of the page do not follow (for example, as they do in a ...

**1**

vote

**0**answers

24 views

### Align column of numbers, negative numbers, decimals and percentages in Excel

My list of numbers contains the following:
48.8
4.19
(0.36)
4.52%
and I want them all to align by decimal. As far as I can tell it is not possible in a single step and the best I can do is paste ...

**2**

votes

**1**answer

56 views

### Create a linear trend line in Excel graphs with logarithmic scale

I I have an Excel scatter chart with x and y values.
I set the logarithmic scale in x-axis and y-axis.
When I add a linear trend line to the graph, the line is not linear but appears like a curve.
...

**1**

vote

**2**answers

54 views

### Excel Vlookup for 2nd, 3rd, 4th or 5th text value, instead of 1st matching value

I have rows of possible duplicate employee ID #'s, with another column of different values for the same person. I need a single column of unique ID's with the certifications transposed in the same ...