The 2010 version of Microsoft's spreadsheet application.

**3**

votes

**2**answers

84 views

### Excel 2010 formula =IF(S8=“24/03/2015”,“Yes”,“No”) returns “No”

The following formulas in Excel 2010 both give me a "No" answer:
Formula:
=IF(S8="24/03/2015","Yes","No")
where S8 has format/value dd/mm/yyyy / 24/03/2015
=IF(S9>"30/06/2013","Yes","No")
...

**0**

votes

**1**answer

4k views

### Call PowerShell script from Excel macro

I'm trying to call a PowerShell script from a macro in Excel.
I have seen a number of examples along the lines of:
retval = Shell("powershell ""C:\MyTest.ps1""", 1)
When I try to use this, ...

**2**

votes

**2**answers

19 views

### Hide data label containing series name if value is zero

I have made a chart in excel in which I would like to hide the data label if value is zero. For data labels that contain the value itself this is done by using custom formating as explained here How ...

**1**

vote

**2**answers

44 views

### Excel - Manipulating data in awkward format

I have a dataset that I want to analyse, but it is in quite a strange format. See below:
> Account_Details Account_Name
> account # 1 client name
> product 1 name ...

**-2**

votes

**0**answers

16 views

### Excel: Find duplicates among 2 colums [on hold]

Giving an excel file with 2 columns:
A: 5000 numbers (some repeated)
B: 100 numbers
I want to know if for each number in A there is a instace of that number in B. Meaning: for A1, is it anywhere in ...

**0**

votes

**1**answer

20 views

### How to chart two columns of data in excel

I have the following data and I want to create a simple chart in Excel 2010 but can't work out how to get this to work. I've tried scatter charts, switching axes, etc. and nothing seems to give me ...

**0**

votes

**1**answer

12 views

### How can the content of multiple cells be copied to a single cell?

I need to copy content of cells from immediate left but not a range, but selected cells into a single cell. The cells will either have a normal number or a currency figure.
How can I do this?
I ...

**1**

vote

**5**answers

6k views

### How can I count unique values in one column based on criteria in two other columns?

I am trying to to count the number of unique entries in column A where Column C says NO and column D says YES. However, I cannot devise a formula to do this based on two different criteria. How could ...

**-2**

votes

**1**answer

58 views

### Need a formula for Leap Year

I need a formula by which I can find by entering a date whether that financial year has a leap year or not. Let's say if I entered date as 03/01/2015 then it should be consider a Leap Year as ...

**0**

votes

**1**answer

4k 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

**1**

vote

**1**answer

25 views

### How do you create a conditional nesting formula on excel 2010 with more than 3 conditions?

I have "A, B, C and D." I need " if a>0, use a, otherwise, use b. If b has the error "#N/A", use c, otherwise use b. If c=0, use d/61, otherwise use c.
So far, I have this:
...

**3**

votes

**5**answers

29k views

### Why does Excel 2010 automatically reformat numbers?

Excel 2010 is automatically reformatting numbers/cells where a specific number format has already been applied. Whenever I access or modify the cell contents, Excel reformats by changing the number ...

**0**

votes

**0**answers

13 views

### Protect formatting in Excel 2010, and allow editing of text

I am using Excel 2010 with a shared workbook. I need formatting protected, but need to allow users to be able to change text and select from drop down boxes. Following the instructions in this answer ...

**1**

vote

**1**answer

24 views

### Excel to show icon

I want to have icons that will signify increase, decrease or equal from the prior cell.
For example below in C2, the icon should increase when compared to B2 (because its value is greater). The ...

**2**

votes

**0**answers

50 views

### Excel 2010 scrollbar goes too far

My problem is illustrated in the PrintScreen below:
I've searched a lot on the Internet and almost all sources say to delete the empty rows at the end of the sheet and save the document. For ...

**0**

votes

**1**answer

25 views

### Merge two Excel files and only retain new data?

I manage a daily shipping report (an Excel file) that has many date fields (departure, arrival, etc.) that are populated automatically from our shipping system. In the last column of the report I add ...

**3**

votes

**2**answers

25 views

### How to format text between branches excel using a macro Excel 2010

I found a little macro to change all the text between "[" and "]" red in excel.
But i can't get it to work in Excel 2010, i get some errors.
Can someone help me debug this?
At the end i wish that in ...

**0**

votes

**1**answer

4k views

### How to customize Paste Value Excel Short Cut

I was reading in this other post how to set up VBA code to paste values in Excel. I understand how to create the VBA code.
I would like to set the keyboard shortcut to Ctrl d but Excel pops up an ...

**1**

vote

**1**answer

2k views

### Excel 2010 filter arrow not showing text values

I have an odd problem on a tracker spreadsheet I use. All the columns have a filter, but when you click on the filter arrow it doesn't show you a breakdown of all the text values for that column. All ...

**0**

votes

**1**answer

23 views

### Copy Table values from one sheet to another

On the first sheet of the spread sheet I have the following:
1 Item Item Description
2 xxxxxx yyyyyyyyyyyyyyyyy
3
4 Object 1 Object 2 Object 3
5 AAA ...

**0**

votes

**2**answers

2k views

### Complex rota hours calculation in excel

OK so there are a number of different shifts in operation here and I want a total hours formula.
problem is the rota is written using a number of different notations for different shifts
some are ...

**0**

votes

**1**answer

3k views

### Special-Pasting a hyperlink in Excel

Is there a way to use the Paste Special command to paste a hyperlink from one cell in Excel 2010 to another cell?
I am asking specifically about the Paste Special command, not the Paste Link or ...

**1**

vote

**1**answer

22 views

### How do I display the value of one cell in a cell on another sheet?

I would like to build a spread sheet with multiple sheets. The first sheet is the main 'working' page. The additional sheets would be filters of data found on the first sheet. On the first sheet on ...

**3**

votes

**1**answer

2k views

### Macros in Excel 2010 hangs

I have a spreadsheet with several macros. Generally, when previously using Excel 2007, a user clicks a button and everything works as expected (calculations, some email sending & file I/O). ...

**2**

votes

**2**answers

23 views

### Excel text to appear on screen but not print [duplicate]

I am creating a contract in excel and I do not want the line item pricing to appear when printed. Changing the font color to white is time consuming so not an option. Hiding the group of cells would ...

**0**

votes

**0**answers

11 views

### How do i get a cell to read multiple options for a seperate cell [on hold]

I am trying to get a cell to read another cell with different possible names in it and be able to reference the names to a separate items.
Example:
cell b5 has different items and cell c5 reads a ...

**4**

votes

**3**answers

5k views

### Increase size limit of data import from csv into Excel

I have a load of data in a csv file that I'm importing into Excel, most of it is fine, but one of my columns contains up to 1000 characters of data. Unfortunately, Excel has taken it upon itself to ...

**0**

votes

**4**answers

6k views

### How to troubleshoot “Automatic update of links has been disabled”

When I open some spreadsheets I get the error "Security Warning Automatic update of links has been disabled". I can only imagine this might be in reference to formulas or other content in the workbook ...

**1**

vote

**1**answer

33 views

### Excel add-in not loading when opening Excel from VBA

I'm using excel reg-ex add-in and it works well, the only problem with it that it doesn't load when excel is started by VBA.
I've a macro in word to collect some data in Word and copy it to excel, ...

**1**

vote

**1**answer

54 views

### Excel chart for rail car movements

I need to display the movements of a group of rail cars between two locations.
Each car has dates for "left location A", "arrived location B", "left location B", "arrived Location A" - repeatedly ...

**0**

votes

**1**answer

26 views

### Excel Office Pro 2010 SUMIF

Hi Im trying to SUMIF(range;"<>#N/A";range) but the cells im selecting to sum are not in a row adjacent, its every 4th cell in the row.
But when i try it gives an argument error each time i try ...

**2**

votes

**1**answer

221 views

### Excel find values returned by a formula

I have an Excel spreadsheet that has values being returned by formulas. When attempting to seach for these values using the keyboard combination CTRL-F, it returns that it cannot be found even though ...

**3**

votes

**1**answer

35 views

### Excel, how to use text functions on lookup array without putting in another column?

If I'm using a vlookup, or a match function but I need to do some mumbo jumbo on my lookup material, is there a way of doing this in the lookup array without simply adding another column?
Let's say I ...

**3**

votes

**6**answers

39k views

### How to sum a range of cells with N/A values?

I have a range and need to sum it using SUM function but the result is N/A if there is any N/A value. How can I make the SUM function to treat the N/A value as 0 value?
Please help!

**1**

vote

**2**answers

20 views

### Finding repeating digits at the end of a string of digits

I have a list of 10 digit toll free phone numbers. I would like to identify those that contain at least 3 repeating digits in the last 4 digits of the number. For example:
8xxxxx5444
8xxxxx2220

**-1**

votes

**0**answers

19 views

### Replace cell references with values without F9 using macro (2) [duplicate]

I tried to use the macro in this post but it doesn't work on mine. Can you help to tweak this macro abit?
I want to change from this:
=((J26*J27*J28+J34*J35*J36+J30*J31*J32)*24/1000000)
... to ...

**1**

vote

**2**answers

16 views

### Copying many cells to one location

I transfer data around a lot in Excel. I want to be able to copy many random cells to another location so that they are side by side.
E.g. I want to copy a3,d21,aa32,cd121,etc. so that ...

**0**

votes

**1**answer

30 views

### How to translate automatic months from a language to another?

I'd like to translate a billing report from Portuguese to english.
It is accurate by months, and it is an automated sheet.
A contract may start on January, but it's commonly started on the others 11 ...

**1**

vote

**1**answer

26 views

### How to select a cell relative to a button with a macro?

I am trying to create a macro in Excel which I can assign to a number of buttons (one in each row), each of which will operate on the data in the row in which the button is located.
Is it possible to ...

**-1**

votes

**0**answers

24 views

### Extract address from HYPERLINK cell in Excel 2010

I have a HYPERLINK cell in Excel 2010 where I have many rows on it.
I want to extract underlined address from that HYPERLINK cell.
Below macro is not working for me.
Function GETURL(HyperlinkCell As ...

**0**

votes

**2**answers

2k views

### Hyperlink to doc file slow opening

I've two excel file with inside some link to .doc and .pdf file. Both excel files and linked files are on a network shared folder. The first excel file is an .xls, the second an .xlsm.
While opening ...

**0**

votes

**1**answer

31 views

### Functions (specifically text functions) within a countif function

Is there any way to nest text operators within a countif?
I want to check if the first 4 characters of a file are in the form A**.
=Countif(Left(A1,4),"A??.") doesn't work, but I can put in a
...

**1**

vote

**1**answer

25 views

### Excel conditional drop down lists causing massive file size

I have an excel file which relies heavily on data validation. There are about 20 drop down lists per row. One column has a 35 formatting conditions. One column is a conditional drop down list (using ...

**1**

vote

**1**answer

52 views

### How to fetch data from another excel file and sort it under name?

I have 2 excel files, one of them is a list of workers and the other is a list of absences. I need to have the reason and the ending date from the absences list to be fetched into the main list, and ...

**1**

vote

**1**answer

49k views

### Can Excel use formula-input data for cell references?

I have a cell in Excel, to which I want to pull data from another cell that is defined as a value in a third cell.
For example:
A1=5
A2=10
A3=insert syntax here, using A4 as source for cell ...

**-4**

votes

**0**answers

23 views

### Get the average of the last 5 non-zero cells in a row (not column) [duplicate]

Objective: Get the average of the last 5 non-blank cells in a row (not column).
I am using Excel 2010.
I have a row of 12 cells and weekly will enter a number or sometimes nothing at all. After ...

**3**

votes

**5**answers

14k views

### Cell colors change when copy&paste in Excel 2010

We have a 3rd party tool that creates an Excel file (xls, 97/2003 format) and formats some cells in different colours. When I copy a range of cells into a newly created file (xlsx, 2007/2010 format) ...

**4**

votes

**1**answer

6k views

### How can I change the default date format?

When I paste a date into Excel 2010 in the format "2012-12-07 00:00:00.000" I'd like it to be displayed by default as "2012-12-07", but it is actually displayed as "00:00.0".
I know I can work ...

**1**

vote

**0**answers

29 views

### Matching a column range based on a column label

I have written a spreadsheet for Excel 10 and am struggling with the last bit of formula.
I wrote this:
=SUMPRODUCT(--(ISNUMBER(FIND(B7,'PO SHEET'!$K$7:$K$74))),('PO SHEET'!$W$7:$W$74))
However, ...

**2**

votes

**1**answer

38 views

### Excel Strange Extra Digit

In Excel 2007/2010, I get this strange behaviour:
Formula in cell: =2.6+1.4+4.62-8.2
Result in cell: 0.420000000000002000
Weird extra '2' about 14DP in. Can anyone explain why this is happening ...