# Tagged Questions

**0**

votes

**1**answer

14 views

### Converting a mmm-yy date in string format to date format

I have an excel document that lists dates in mmm-yy format as a string (they've been copied in from a pdf). I need to be able to determine the number of days between these dates, however excel ...

**1**

vote

**1**answer

15 views

### Find all Excel files linked

I have an Excel file that is the source of data for several other Excel files (they are linked to this one). Is there a way to find a list of all of those files?
To explain another way, this post ...

**0**

votes

**1**answer

19 views

### Align header with cells whose text is oriented at an angle

Is there a smart way to align horizontal-text "header" cells with other cells below whose text is oriented at an angle?
This is what I tried. Obviously this looks awful. The "Benefits" and "Caution" ...

**1**

vote

**1**answer

24 views

### How to efficiently reference an entire row in Excel?

I am working on a budget spreadsheet in which I have to pull in cell data from another external spreadsheet. I have to do this for several different sheets with massive amounts of data in the sheets, ...

**-1**

votes

**2**answers

19 views

### Excel create reference to whole column throught a formula

I have a spreadsheet where I need a reference to a whole column, catch is that I don't know which column ahead of the time, so I use MATCH function to find that out. Once I find the right column I ...

**0**

votes

**0**answers

23 views

### Excel 2010 - Copy worksheet

I have a workbook with various worksheets.
Each worksheet is a month and year.Lets say January 2015, June 2015.
Now I want to copy worksheet June 2015 and rename it to December 2015, but cell A2, ...

**0**

votes

**0**answers

17 views

### vba excel macro runtime error 1004

Dim lastC As Long
lastC = wb2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'highlighted in debug
SourceRange.Copy
wb2.Worksheets(2).Cells(1, lastC + 1).PasteSpecial Paste:=xlPasteValues, ...

**0**

votes

**1**answer

23 views

### Unable to expand cells in Microsoft Excel

I have an odd issue that I need your help with.
Within my spreadsheet there are many cells that although contain data, do not respond when I try to automatically resize them.
I've tried auto-fit, ...

**0**

votes

**2**answers

28 views

### How to use different formula in case of en error?

I want to run the following formulas on a cell, in this order,
in case the previous formula returns an error.
=MID(P2,SEARCH("q=",P2)+2,SEARCH("&",P2)-SEARCH("q=",P2)-2)
...

**0**

votes

**1**answer

20 views

### Excel: How to strip search terms from a cell (referring URL)

I have cells that contain a referring URL of visitors who entered my websites.
this URL always has a different lenght, but it's constant format is such that the search term always shows up between p= ...

**0**

votes

**1**answer

16 views

### Can we set Excel to append cell text on key press instead to delete the current text?

I am using Excel a lot for accounting. It happens a lot of time that I calculate multiple values into the same cell. So my cell may look like =12+345+23+88.
Now, the default Excel behavior is to ...

**0**

votes

**1**answer

12 views

### Cell colours depending on value

I have a column of cells where each cell contains one of the following text values
Optimal
Normal
High-Normal
Mild
Moderate
Severe
I would like the cell colour to be a set depending on what the ...

**0**

votes

**1**answer

8 views

### Page Break lines won't stay off for a shared Excel document

I have a shared Excel document on my NAS, and in Excel I go to options and disable Page Break lines.
However, when someone else opens the document, the page breaks reappear. When I reopen the ...

**0**

votes

**1**answer

18 views

### Excel Values Require Enter within Cell to recognize as number

I have a worksheet where I am getting direct output from STATA that has a weird character format that included " =[ number ]". I put in a new column to strip the characters and leave the numbers. ...

**2**

votes

**2**answers

30 views

### How to find the last value in a column in excel?

I am tracking rooms booked in a hotel on a daily basis in Excel. Every day I input the number of rooms booked in a column to show a trend of pick up over a period. I'd like to return the value of ...

**0**

votes

**3**answers

40 views

### Unable to get Excel to recognise date in column

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what.
I have a spreadsheet, exported from our exchange server, that contains a column ...

**0**

votes

**1**answer

20 views

### Count Row and Column in Pivot Table

Hi I have a sheet that collects the following
++++++++++++++++++++++++++++++++++++++++++++++++++++
+ Name + Address + Borough + Postcode + Date Added +
...

**0**

votes

**1**answer

44 views

### VBA: How to replace entire Excel cell value basing on its content?

I have an Excel Spreadsheet with some names in a cells. There can be as one name per cell as multiple names in one cell.
For example: Cell A5 contains "Joe", cell BD54 contains "Joe;Harry;Molly", ...

**2**

votes

**1**answer

25 views

### How to apply conditional formatting only to cells that contain a subtotal formula

I have a list of values, I have to alternate color of each row (that works fine).
In that list I also have subtotals, calculated using the SUBTOTAL function.
How would I be able to give just the ...

**1**

vote

**1**answer

13 views

### Is there a way to do a partial text vlookup?

I am trying to vlookup partial text which will return a specific value if found within my data. I have a list of postcodes (zipcodes) and would like a vlookup to look up the first part of the postcode ...

**1**

vote

**2**answers

53 views

### Microsoft Office 2010 will not open two xls

I am using Windows 7 and Windows 8 and I see the following behavior with Microsoft Office 2010.
Create two Excel files, say a.xls and b.xls
Open a.xls by double clicking it.
After the file is ...

**0**

votes

**1**answer

29 views

### Sort & Ranking Functions in Excel for Time AND Number Values in one Column

I have a spreadsheet that is being used to track and score a fitness competition, each workout has a time cap, so athletes that complete the workout under the time cut off are given a time as their ...

**1**

vote

**1**answer

27 views

### Excell formula for multiple pasts without repeating previous cells

I have a data set for 12 years of 4,380 days. I want to take the sum of each week. when I make a formula {=SUM(A1:A7)} and drag to drop button to the next cell it shows {=SUM(A2:A8)}. This is not what ...

**0**

votes

**2**answers

17 views

### Hide a column when auto filter is active

I have read this Show Excel column filter information in cells and it basically does what it is supposed to. But I want to hide and unhide column A when a filter is active. So I put in the following ...

**0**

votes

**0**answers

44 views

### Search rows containing a certain value for other values and comparing them

Here is what I'm trying to do:
This spreadsheet contains 40k+ component serial numbers. These assembly serial numbers are in column c.
These components contain sub assemblies and those also have ...

**0**

votes

**0**answers

12 views

### How to embed an icon from one worksheet to another, within the same workbook

Does anyone know how to embed an icon referencing another worksheet page onto another worksheet ... all within the same workbook. I have been trying this out but keep getting information on how to ...

**0**

votes

**1**answer

24 views

### Format dates so they are split across two lines

See the dates above? I'd like to format them so they are split over two lines, as illustrated below (Note: the Oct 13 is a mistake; it should have been split as well).
In other words, between the ...

**2**

votes

**2**answers

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

**1**

vote

**2**answers

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

**1**

vote

**1**answer

18 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

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

**1**

vote

**1**answer

25 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

26 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

39 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

26 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

20 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

17 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

20 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

22 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

21 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

24 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

76 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

31 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

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

**1**answer

30 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

35 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

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