Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
7answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
6answers
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
8answers
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
4answers
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
2answers
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
4answers
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
1answer
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
1answer
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
5answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
2answers
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
2answers
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
1answer
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
0answers
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
3answers
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
1answer
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
2answers
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
3answers
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
1answer
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
1answer
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
1answer
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 ...