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)

1
vote
3answers
48 views

,“>”&0),“”) at the end of a countif formula

I have the below formula, but don't understand why the last part of it ,">"&0),""). Can somebody clarify pls? ...
0
votes
1answer
21 views

VLOOKUP with string returning #REF

I have the following set up in Excel, and I am attempting to lookup the first column in the range A5:A7, and return column 8 (the rate) plus the custom rate. This is the link to the current setup I ...
0
votes
1answer
38 views

Excel - How can I highlight duplicate cells in near-matching worksheets?

I'm running a March Madness bracket tournament using Excel spreadsheets. I have one sheet where I will input the actual winners. I have an additional sheet per participant that is near-identical, only ...
0
votes
0answers
30 views

Keyboard media keys (play, pause etc) don't work while Excel 2013 is active

Excel 2013 appears to "swallow" these keys: whenever it's active, play/pause and similar keyboard keys don't work at all. Activate any other application and they work again. Is there a known fix? ...
0
votes
2answers
42 views

Index and Match to a file posted on SharePoint returning #Ref Error

I have two Excel files posted on SharePoint. With the master file, I've created INDEX, MATCH array formula, referencing the other file. I've entered the entire NUC, and the formula works fine while ...
1
vote
1answer
17 views

custom conditional formats in excel 2013

my goal is to format an entered text if a certain condition is met e.g. user enters "5" in a cell format detects that it is greater than 3, appends "/a" [result: "5/a"] user enters "2" in cell ...
0
votes
1answer
22 views

Ctrl+[ not working in Excel 2013

The keyboard shortcut Ctrl+[ (trace precedents) is not working on my new laptop. I am using Excel 2013. Can anyone explain how to set it to work?
0
votes
1answer
21 views

Relative cell reference in Excel using different axis

Is it possible to make a relative cell reference that extends downwards when I copy the value to the right? Consider this example: 10% 100 150 200 250 300 15% 20% 25% 30% I would like to ...
0
votes
1answer
37 views

How can I hide or show rows automatically based on a value in a cell?

My data looks like this; A B 1 Project A 02/03/2014 2 Project B 03/05/2013 I want to automatically hide the rows with specific dates. I can have a cell outside of the range ...
0
votes
3answers
48 views

Excel freezes when copying a few cells multiple times

I have had a frequent problem in Excel 2013 and Excel 2010 on several different computers, where Excel would freeze for 10-20 seconds when I copied a few cells into 3 or more locations. I frequently ...
0
votes
1answer
25 views

Enable Excel Macro's for one spreadsheet all users

We have a workstation where a large number of users need to work on an Excel 2007 spreadsheet that is stored on the network and contains Macros. We have added the sheets location in the Trust Center, ...
0
votes
1answer
26 views

Excel—Referencing Current Column in Function

I was given a rather large Excel file recently to use for some data entry purposes. I'm trying to perform a find/replace in this file to replace specific text with the value in the current column's ...
0
votes
3answers
38 views

How to remove duplicate row based on some columns

I have a excel sheet which contains duplicate I want to remove a row if its A C D E F columns are same (Ignore B while calculating duplicates but remove it while removing a row) At the moment it ...
1
vote
2answers
15 views

Find most recent date for ID with multiple records in Excel sheet

On Sheet1 in column A, I have a work order number, and on Sheet2 in column A, I have a list of invoices -- each referencing one of the work order numbers on Sheet1. There are multiple invoices for ...
0
votes
1answer
25 views

How do I prevent Excel from changing the color of a clicked link?

I'm using Excel 2010. And as most Excel users know, if a cell is also a link, once you click it it turns to this awful purple color. For me this ruins the color coding I'm using to show the status ...
0
votes
0answers
34 views

Excel: How to attach a note to a specific date in a dynamic graph?

I have a graph that I update every month with new data. I want to annotate some comments to relevant days inside the graph, and when I update it, they stay fixed to that days. Now, I draw this notes ...
0
votes
1answer
27 views

How to change the size of my 'glow' effect on excel, when I use custom color?

When I create a shape in Excel(2007) I apply some effects in it on Format > Shape Styles > Shape Effects, with one of them being "glow" with some predefined colors and sizes. What I'm trying to do ...
-3
votes
1answer
22 views

listing by one particuluar column in excel for mail merging

I would like to list all of the same students with their courses. My example School Teacher Course ID LastName 705 KELLEY AP PSYCHOLOGY 1245 AARON ...
-1
votes
1answer
17 views

numerical value from a word being input

Im trying to work out the formula for someone inputting yes into an excel spreadsheet and it adding a value of 30 which is held in a different cell, which can then be added to a total. or am I best ...
0
votes
2answers
39 views

INDEX MATCH based on 2 Criteria

I'm struggling to create a compound INDEX MATCH in Excel based on two criteria. My data set looks like this: RANGE SITE TYPE 2711260 LOB LBO 2711260 MYP WAN 2711266 ...
0
votes
2answers
50 views

Calculate date and time differences in Excel

I am trying to use Excel 2013 to put together a workbook for timesheet tracking. As an example, time worked yesterday needs to be entered by 10:00 AM on the next business day. Weekends become ...
0
votes
2answers
57 views

How to extract max values from multiple rows and count how many fall to certain criteria, in one-cell function

I have a sheet in Excel that shows success of students in certain parts of the exam (tests, presentations, final exam etc.). I need to calculate some statistical data and the problem is that for some ...
0
votes
1answer
36 views

New instance of Excel does not see already opened instance

I have Avizo.xlt with one Worksheet and a code which intended to put this WS inside already opened document, which is SLK report made by our ancient ERP system, and close this document. Everything ...
0
votes
1answer
16 views

How to refer to a 'related' table in another excel table?

I have created two related tables (tableA and tableB) in excel and linked them using 'Relationships' in Excel 2013. I'm trying to create a new formula field in tableB that refers to two cells from a ...
0
votes
0answers
17 views

export marked rows in Excel

How can I export the subset of all rows marked by an x in column A? Example data set: A B ---------- 1 apple 2 x orange 3 x lime 4 cherry 5 x lemon Exported data set: A B ---------- 1 ...
0
votes
1answer
29 views

Is there a function in Excel or Access to reshape a table to First Normal Form, or a way to do it in SQL?

Very often tables are presented in Excel files in a non-normalized form. I have one such table which I wish to take into (somewhat) First Normal Form using either SQL commands in Access or, ...
1
vote
1answer
25 views

Stubborn “Read-only” notification in Excel won't go away

I have a table in Excel that includes a set of cells copy-pasted from a TFS bulk edit worksheet. I'm usually careful and paste values only so that I don't get any of the data validation, etc. I'd like ...
1
vote
1answer
32 views

How to remove “no cents” when spelling out cents less dollar figures in Excel?

Currently, I am spelling out dollar values using a module from the Microsoft support website. Here is the link http://support.microsoft.com/KB/213360 I am able to spell out dollar values in Excel ...
1
vote
1answer
36 views

Sumif range of criteria

I've checked different questions and answers on the site, but couldn't find what I'm looking for. I try to have a sum of values, using multiple criteria (OR): When I use, e.g., ...
1
vote
1answer
57 views

Format numbers in different locale (with period instead of comma as decimal separator)

I am using Excel 2013 on a German version of Windows 8.1. When I format a number as a number, in cells or in a diagram, it is displayed with a comma as decimal sign (like "3,1415"). I would like to ...
3
votes
1answer
59 views

Excel - Get rid of extra space in cell when using Text Wrap

When I type a long sentence (or more than one sentence) into more than one cell in a row, and apply the Text Wrap option to these cells, the cells have an extra blank line on the bottom of them. There ...
0
votes
2answers
50 views

Correct use of the Formula type in Excel Colour Scales

I'm trying to work some trickery in excel where each cell in a row is shaded based on how many have been completed: So the idea is that as more of the columns in the row are ticked the whole row ...
0
votes
1answer
25 views

How to format cells containing errors

I have several cells containing phone numbers formatted as Text - eg: 3476225598 How can I convert each cell so that it's displayed as 347.6225598 ?
0
votes
1answer
49 views

VBA Excel: Sub procedure to change caption in a UserForm control

I'm creating a user form that shows the value(numeric) of the last used cell in a column. I'm just guessing on how to do it but it doesn't work, this is what I got: Sub show() UserForm1.show ...
0
votes
1answer
31 views

data proccessing in Excel

I have set up a number of columns with some data-numbers. I would like also to present some data resulting from processing these columns: For each of these columns i would like to know the product of ...
1
vote
1answer
24 views

Editing Excel cells with a different format while keeping the current format

Say I have cells in Excel with text in it in subscript format. When I want to add more text in the cells, it will appear in subscript format. To make them appear in normal format, I have to start ...
0
votes
1answer
16 views

How to match Reg No. in one workbook to another

I want to find out a formula to match Reg No. for two workbooks. First work book is a master book I update everyday almost, next workbook I have employees name and ID numbers only, nos are in ...
0
votes
0answers
25 views

How to see green and purple box around charts?

When I create a chart in excel and I click on the chart I would like to see the green boxes around all the data that the chart plots as well as purple boxes around the headings. How do I enable this ...
2
votes
0answers
28 views

Excel 2010 clips top edge of content

In Excel 2010 on 2 different computers, the same file opens differently as follows: Correct: Incorrect: The correct one is displayed first. This is a file exported from a SQL Server Report; when ...
1
vote
1answer
29 views

Dragging a cell reference in intervals

I have data as follows (simplified) in two worksheets on a document: Sheet 1 data: A1=1 -- B1=(Blank) -- C1=(Blank) -- D1=2 -- E1=(Blank) -- F1=(Blank) -- G1=3 ... Sheet 2 data: A1='Stage ...
1
vote
3answers
34 views

Hiding an Excel formula untill the fields before are completed

I'm going crazy here trying to sort the below out. I am trying to hide the "0" (J9) and the "Yes" (K9) until the dates have been filled in The Formula in J9 is =DATEDIF(H13,I13,"d") The Formula in ...
0
votes
1answer
73 views

hide/unhide rows based on cell value

Based on a cell value = true or false, I conditionally formatted rows to turn black. That means that I need to scroll down to find the set of rows that did not turn black. I would prefer that all my ...
0
votes
0answers
28 views

Updating old stock ticker symbols

I did a study in 2003 that produced a list of about 300 publicly-traded US stocks. Ticker symbols can change (ticker symbols can even take over an older company's previous ticker). My situation boils ...
0
votes
0answers
27 views

Excel: Finding comma delimited values in reference range

I have a two-sheet excel file in which I want to see if specific values are present in some column, based on comma separated values in some other cell. The idealized case would be: Sheet1: Cell A1 ...
0
votes
0answers
29 views

Is there a way or code that will pull data from Excel and place it in specific order on powerpoint presentation?

I'm going crazy trying to figure this out, there has to be an easier way. I will try to explain as best as possible: I am preparing a powerpoint presentation for a trial, it will contain aprox. ...
2
votes
1answer
38 views

Excel inconsistent date conversion

I'm running Excel 2007. I've done a dump of data from a MSSQL database into a CSV file, then saved it as part of a larger Excel book. One of the fields is a date, which downloads as: ...
2
votes
5answers
66 views

Sum over every second cell if neighboring cell is not empty

I have created a timesheet in Excel to keep track of my working times. It all works pretty good, but I have one small problem. My sheet has the following layout (In=started working, Out=stopped ...
0
votes
0answers
28 views

How to handle large excel sheet as csv with Chinese characters?

Excel is having issues dealing with Chinese characters saved as a CSV file. I am trying to use the file in a content analysis program, but cannot open the file and view with correct characters (the ...
1
vote
0answers
29 views

In Visio 2013, how do I apply various styles to a timeline element based on a linked data value?

I am building a timeline in Visio 2013 using linked data from Excel. It took me forever to figure out that I needed to add the names "Task Name" and "Start" to automatically populate milestones on ...
-1
votes
2answers
68 views

Spreadsheet for Daily Equipment Hours

My goal on this is to keep track of equipment hours and have a daily report to reflect total hours and run time. I want to make a file with 31 days of worksheets in the workbook for the complete ...