**1**

vote

**3**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**5**answers

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

**0**answers

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

**0**answers

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

**2**answers

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