**0**

votes

**0**answers

5 views

### Excel Average by excluding top and bottom 5 values

Trying to get the average by looking up a text and excluding the top and bottom 5 dates based on worst and best values. I am currently using this formula which gets me the all but excluding the top ...

**0**

votes

**0**answers

3 views

### How can I check that a filter applied to a listobject column with vba is legal?

Filtering a listobject(excel table) with a value that doesn't exit results
all rows instead of none
can I get no rows?
can I get list of optional legal parameters?
example
listobject with col A
...

**0**

votes

**1**answer

18 views

### How to reformulate Excel formula with too many levels of nesting

I need to be able to use the following formula in Excel to choose a formula used on a different sheet based on the values in drop-down menus in cells D2 and D3. The only problem is that the formula ...

**0**

votes

**1**answer

21 views

### How to bring to front a series in a scattered chart

This question is almost stupid but, since I'm working late at night in this part of the world, I'm too confused that I can't find the easiest command.
I have a scattered graphs with many series. Some ...

**-1**

votes

**1**answer

29 views

### Enhanced Vlookup Excel Formula

I am looking for an excel formula that I can use to automatically fill E2 in the screenshot below. The intention is to find Marc's age from column B, ie E2 should be 20. Any ideas please? I have tried ...

**-1**

votes

**0**answers

8 views

### Why Excel autofills only from T1 to T4?

I have the text T1 in a row, and I drag it over 10 rows, then it does T1-T2-T3-T4-T1-T2 ...
With A1, W1, Q1 it doesn't do the same, it just continues with 5-6-7-8 and so on.

**-1**

votes

**0**answers

8 views

### How can I extract total time used by an employee from a record mainted in a different tab

How can I add the time used by an employee for different taks and keep track for the total time used in a particular week? Staff will flight out a few times per week with each flight date and time ...

**17**

votes

**7**answers

74k views

### Excel: Find Items in one column that are not in another column

I have two columns in excel, and I want to find (preferably highlight) the items that are in column B, but not in column A.
What's the quickest way to do this?

**-1**

votes

**1**answer

13 views

### How can I merge contents of 2 cells into 1 and shift the remaining columns in Excel?

I'm trying to merge cells in excel that are in the same row into 1 cell and then shift the remaining cells to the left.
Example:
Content | Sample | More | More2
So I want to merge "Content" ...

**0**

votes

**0**answers

24 views

### Why is pasting text into Excel splitting it into multiple cells?

When I am copying partial text from one cell and pasting into another what I am pasting is separating into multiple cells.
Example:
Copying "June 15th" from a cell containing "Little Timmy's ...

**0**

votes

**1**answer

5k views

### Split Excel worksheet into multiple worksheets based on a column with VBA

Question is simple and may be repetitive.
I have an Excel workbook which contains around 50 columns
I have a criteria column for splitting this workbook into mulitple workbooks
The approach is as ...

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

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

**6**

votes

**6**answers

23k views

### When embedding an Excel chart on a PowerPoint slide, why does the text look awful?

I have a recurring problem with Excel 2003/PowerPoint 2003, where I have a nice-looking chart in Excel and try to embed it on a PowerPoint slide. Quite often, the text in the chart (labels, axis ...

**40**

votes

**8**answers

34k views

### Open Excel files in new window

When I have Excel running and I double click an Excel file in Windows explorer, I'd like it to launch in a new window by default so that I can move documents to separate monitors. Is there any way to ...

**0**

votes

**4**answers

5k views

### Keyboard shortcut in excel for expanding the pivot table row?

I'm able to expand/collapse the row in the pivot table with mouse by:
right clicking on cell in the first column of the row + selecting "Expand/Collapse"/"Expand" from context menu.
or double ...

**1**

vote

**2**answers

11 views

### Selecting a button control in Excel 2013 without clicking it

I want to change the name of a button control in Excel 2013. I have my properties window open ready to go. However, I can't for the life of me figure out how to select the button without clicking it ...

**2**

votes

**3**answers

400 views

### Update a summary sheet in Excel

I have a spreadsheet that will eventually contain 52 sheets(one for each week) On each sheet there is a cell with a percentage in it. I would like to copy this cell to a summary sheet so that it can ...

**1**

vote

**1**answer

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

**0**

votes

**1**answer

23 views

### Copy reference instead of value/formula in Excel?

I have some cells from one table I which I want to reproduce in another table, initially in the same order (but later, I'll mess this order up by moving cells around). For the sake of discussion ...

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

**0**

votes

**1**answer

12 views

### named ranges in Excel

I have a list of items in excel and I would like to name the range "Account Payments". It works for ranges with one word names but not with 2 or more words. how do I do this?
thanks for your help

**0**

votes

**1**answer

34 views

### Excel 365 slow keyboard shortcuts

I'm an experienced Microsoft Excel user and I've always loved the software in the past, when I used Excel 2007. One of the best things I liked about Excel 2007 was how I could do everything on the ...

**0**

votes

**1**answer

22 views

### If f=G then h = paid in Excel which formula use for this [on hold]

A B C D E F G h
01-Oct 04-Oct INNOVA 7760 RIYA HOLIDAY 19500 19500 0
.

**5**

votes

**4**answers

2k views

### How to combine data from two rows, when certain criteria is met

click to enlarge
I'm trying to make this Excel document but I want the AdminTimes for the same LastRxNo to be on the same line. So if the LastRxNo is the same, have one line and the AdminTime column ...

**1**

vote

**1**answer

2k views

### Automatic Excel list exported from SharePoint not keeping my local data?

hope you can help!?
I have set up a table in Excel which does a great job of exporting data from a SharePoint however I have added my own columns to add (local) information to each entry.
ie. I am ...

**2**

votes

**1**answer

2k views

### Excel 2010 macro to separate a large data file into workbooks

I found some code which works perfectly to separate a file based on a column (line 31) into separate tabs within a worksheet.
I just need it to separate the files based on a column into a separate ...

**2**

votes

**5**answers

301 views

### Is there an efficient way to copy text from a PDF without the line breaks?

I need to get thousands of snippets of text from PDFs to a spreadsheet. They are short, seldom more than 2-3 rows, but each line break creates a new cell, and I have to repair that manually, which ...

**1**

vote

**1**answer

13 views

### highlighting monthly due dates in excel for the entire year

In excel, is there a formula that can help highlight a reoccuring monthly due date and once that bill is paid for that month it changes back the color?
EXAMPLE
Vendor Due Jan ...

**0**

votes

**1**answer

15 views

### Create an “inverse” pivot table

I have data in the following format
Project Person1 Person2 Person3
A Joe Alice Bob
B Bob Tom Joe
C Alex Alice Tom
D Bob Doug Susan
How can I ...

**-2**

votes

**0**answers

19 views

### VBA Help Please, or Direct me to a good resource

I am new at this VBA Thing and learning as I go, could someone look at the code below and explain why the out put is only one line and it is pasting to Row 39?
Sub AllFiles()
Dim FolderPath As String
...

**2**

votes

**1**answer

846 views

### Excel TEXT function does not work properly

Let say I have the following values in the cells
A1 : `=Now()` which displays 17.03.2014 13:45
A2 : 12.03.2014
Both are in date format and I have the function in another cells like this:
B1 : ...

**0**

votes

**0**answers

20 views

### Area Under Curves in Excel

Are there add-ins for Excel that allow the user to get the percentage of values that lie less than or equal to some value x? Basically I'm looking for an add-in that takes the continuous valued chart ...

**0**

votes

**1**answer

28 views

### modify Excel macro to reference list of text rather than hard code

I’m trying to get some help with the last step of an Excel Macro I’ve been working on. I’ve set up a Macro that will take data from sheets from two different workbooks, and paste them into a third ...

**1**

vote

**2**answers

15k views

### Unable to change Excel cell font or shading colors.

6/15/2012
I'm having the same problem as a previous user's query (linked below) wherein I can't change the font or cell shading color on an Excel spreadsheet. I've confirmed that the cell/spreadsheet ...

**-1**

votes

**2**answers

20 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

**1**answer

82 views

### Is it possible to put a spreadsheet in Thunderbird templates that will calculate?

For various reasons, I am using Thunderbird as my main email client. I'd love to be able to set up a template that will automatically calculate/extend out data for the purposes of quotes, etc.
I am ...

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

**4**

votes

**3**answers

45k views

### How to I auto-refresh an Excel auto-filter when data is changed?

How to I auto-refresh an Excel auto-filter when data is changed?
Use case: I change the value of one cell to a value that was filtered. I want to see the current row disappearing without having to do ...

**2**

votes

**1**answer

3k views

### How to make a Pie radar chart

I want to create a circular chart in Excel with 8 sectors like in this example:
Instead of representing the percentage like in a pie chart, I want the actual value like in a radar chart.
Is it ...

**-1**

votes

**2**answers

41 views

### Excel possible to fill two cells with one if-formula

I have searched on the internet to look if this is possible :
IF(logical test ; true value ; false value )
This is what i try to make for example
A2 =IF( B2 = 20 ; "True" & give C2 value ...

**2**

votes

**1**answer

26 views

### Excel Continuous Pagination

I have the Excel worksheet as shown below on the picture. The data are on the yellow-marked pages. I only need to print the yellow marked pages with continuous pagination.
So the result should be: 3 ...

**0**

votes

**1**answer

2k views

### Excel data validation to whole column

I want apply data validation list to a whole column in excel 2010. How can I do that with out copying the validation rule

**0**

votes

**0**answers

18 views

### Consolidating data from multiple sheets into a single sheet based on specific criteria

I have over 300 excel sheets all having stock data over a year. This data is date wise. However I want to group this data based on stock name, i.e., if I have stock A in all my sheets, then all data ...

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

14 views

### Comparing 2 Cells and then based on their values Multiply another cell

I have a spreadsheet for my insurance business. I want to have a spreadsheet to determine my commission on a monthly basis. So I have one column for Line of Business (Auto, Home, etc) and then another ...

**-1**

votes

**3**answers

35 views

### How to automaticaly convert text to url

I have a list with names and I want to make an other colum with http://name.jpg
is this possible in excel?
and if my original name was 2 words or more can I have auto underscores in the url instead ...

**1**

vote

**1**answer

43 views

### How to combine data from two sheets and conditionally format rows based on sheet of origin

I have 3 sheets in Excel "Open", "New", "Combine"
"Open" Sheet (Old list)
Ticket ID | Priority | Department | Status
36009 | 1 | Finance | 01-Open
34781 ...

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

26 views

### Can't get VLOOKUP working with roster spreadsheet

I have an Excel spreadsheet set up as a roster. The way the roster is setup is for the ease of the person creating the rotation. This roster is not easy to read for the staff.
Mon ...