The 2010 version of Microsoft's spreadsheet application.

**3**

votes

**7**answers

49k 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!

**0**

votes

**0**answers

6 views

### Excel 2010/Hancom Automate the inserting process across multiple sheets

I'm in the process of creating a complicated excel spreadsheet which is where my knowledge runs thin. It's currently consisting of 17 sheets. I currently have 10 pages which require a daily entry of ...

**1**

vote

**3**answers

10k views

### Can't exit design mode because Control 'xxxx' can not be created

What is the cause of this error and how do I fix it?
This started occurring on a workbook of ours for reasons unexplained. I made a tiny change to the VBA code behind it, just plotting slightly ...

**2**

votes

**2**answers

3k views

### VBA to move specific data from one column to another

I've tried requesting help with this before but have received no helpful responses.
I need a Macro/VBA that moves any word in red from column A into column C as a list.
However if the same word is ...

**2**

votes

**1**answer

24 views

### Error using Count If

I have an error using countif to check if values are present in an array.
I have a list of values called "All Points". There is a subset of these called "Plotted Points", that have coordinates. I am ...

**0**

votes

**1**answer

11 views

### Copy rows on condition to another Worksheet

I have an Excel file with 1 Worksheet. In that Worksheet there is data in 1 column and 250,000 rows.
I want to select rows which contain a specific string say "workspace" in that 1 column. So for ...

**0**

votes

**1**answer

41 views

### Importing data to Excel does not calculate formulas

I have now read about 40 tips on this subject and it does not appear anybody has a solution other than "click inside the cell and hit enter".
I have to create many spreadsheets with thousands of ...

**5**

votes

**2**answers

7k views

### Export Office Excel table to csv using a macro

I'm using Excel Tables in Excel 2010. I would like to quickly export the contents of these tables to *.csv.
My current workflow:
1. Select table manually
2. Copy the contents into a new workbook
...

**0**

votes

**1**answer

1k views

### How do you format numbers in Excel for Indian Currency (Rupees)?

Currently the Excel default formatting is:
1,000,000
500,000
How do you format the number to use the comma separator (,) like this
10,00,00,00
50,00,00
This is is how Indian Currency (Rupees) ...

**2**

votes

**2**answers

3k views

### Link Excel spreadsheet into PowerPoint presentation

I need to create a weekly PowerPoint presentation for various levels of management, to keep them apprised of the status for several categories of action items my department tracks. During normal ...

**0**

votes

**2**answers

96 views

### Excel array functions — how to count non-blank cells over multiple worksheets?

I have an Excel workbook with numerous worksheets, some of them containing a numeric value in cell A1:
'DATA_1' 'DATA_2' 'DATA_3'
A A A ...

**1**

vote

**2**answers

1k views

### Show timestamp when cell is changed

I need to know how to show a timestamp in a cell in column D when a cell changes in that same row in column B. I edited this screenshot in paint to show what I mean more easily:
The image
I have a ...

**0**

votes

**1**answer

29 views

### How to navigate to cell by typing destination?

Suppose I'm at the cell A1 and I wish to move to the cell P234 simply by typing on the keyboard.
I know I can click on the box which displays the cell name and type the destination P234 there, but ...

**0**

votes

**1**answer

37 views

### Setting and starting autofilter in Excel

I have a spreadsheet and it links to another workbook. The issue is when the filter is on it does not change as new data is added; you have to refilter the data.
(Click image to enlarge)
I know ...

**3**

votes

**3**answers

267 views

### Remove duplicate entries in one cell

I have data imported from a literature database (.txt format) into Excel. Unfortunately, in most cases, the authors are listed double in one cell, e.g.:
Smith, Miller, Patty, Smith, Patty, Miller
...

**1**

vote

**0**answers

10 views

### Odd Excel/VBA behavior - Creating sheets that do not exist

Excel 2010 Professional Plus (32bit) seems to have created a new set of worksheets and renamed all the original worksheets in the VBA screen, e.g. Sheet10 becomes Sheet101, Sheet13 becomes Sheet131. ...

**0**

votes

**1**answer

29 views

### Excel If Function With More Condition with Match Function

i had a problem with if function with more condition and match function. May i had Solution?
Currently I try using this array formula but cannot get any result.
...

**0**

votes

**1**answer

22 views

### Excel: how to add random decimals to numbers with a macro

I have a list of gps coordinates for a map that we need to randomize a bit as we cannot provide the exact addresses. I would like to shorten the original coordinates (that is the easy part as I just ...

**0**

votes

**2**answers

18 views

### Automatic column width in Excel

In Word 2010, there is an "AutoFit" feature for table columns, that makes the column automatically be an appropriate width for its contents. How do I get the same in Excel?
I can double click on the ...

**0**

votes

**1**answer

29 views

### Count the numbers of matches between a row and a column in Excel

I have a data set in which I need to count the number of matches between any ID numbers in a column and equal ID numbers in a row. I have attached a data set example image and hopefully that will ...

**0**

votes

**2**answers

40 views

### Excel - For each unique ID, every time a particular column turns one, it needs to be cumulatively added

I have a big data set. What I want to happen is for each customer number occurrence, when the transaction type column has an entry CC or SO, it needs to be calculated as a donation. So for each ...

**0**

votes

**1**answer

14 views

### Error running macro after trying to run it from pesonal workbook

So I wrote a macro. The scenario of use is:
I open a fresh and new CSV file downloaded from somewhere
My macro runs and does some magic with the data
Since I don't want to copy-paste my macro to ...

**0**

votes

**1**answer

980 views

### Excel: formula to fill text data from sheet based on condition?

So, here's the situation. I have a workbook with several sheets. I've got one with a list of companies and their data (Tax ID, address, city, etc.) and another - working one. I have a cell with a ...

**1**

vote

**0**answers

68 views

### Hiding pivot table field using a button

I have a pivot table in Microsoft Excel 2010 with several row and column labels. For the sake of user friendliness I would like to have several movable, clickable buttons which each hides/shows one of ...

**1**

vote

**1**answer

30 views

### Concatenating multiple characters with different formats in excel

I need to create a large series of multiple machine numbers with the following character formatting: Machine Number(first 4 digits)_Date(last 6 digits) as provided in the sample image below:
One ...

**0**

votes

**1**answer

2k views

### Excel 2010-line graph not displaying data as desired

I will to plot a line graph of year vs. sales on excel 2010. However, the years are displaying on the y-axis wihile nothing but 1,2,3 etc is displaying on the x-axis.... Anybody might know what the ...

**3**

votes

**1**answer

3k 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). ...

**4**

votes

**2**answers

35k views

### How to display or view non-printing characters in Excel?

Is there an option in MS Excel 2010 that will display non-printing characters within a cell (e.g. spaces or the linebreak character introduced by pressing Alt-Enter)?

**0**

votes

**1**answer

25 views

### Convert a column B into a comma separated list , “ORDER BY” Colum A

trying start with VB in excel
just need understand how it works , this task can be done in SQL,
but I really want to know how can be easy done in excel
column A contains par numbers , column b models ...

**1**

vote

**2**answers

29 views

### Calculate the minimum starting from today (excel)

I am trying to get excel 2013 to display the minimum for a structured table but only from rows that are dated today or after.
The table is a standard structured table, and most of the formulas I have ...

**0**

votes

**0**answers

12 views

### Auto Update data from one column in Excel file A to another column in Excel file B

I have 2 excel files for example myemployee.xls and salary.xls.
In myemployee.xls, I have two columns: employees code and names like this and new employees will be entered here continously.
A ...

**0**

votes

**1**answer

24 views

### How to compare the Values in two different columns if the Values are same get the values

Column B has Values of customer Number (multiple times) till Row 1000 and column A has the sales orders information like below.
Column A Column B
ORDER1 KRISHNA
ORDER2 RAVI
...

**0**

votes

**3**answers

95 views

### Excel counta function fixed reach [duplicate]

I have a planning sheet in Microsoft Excel 2010 for my company. I have made a screenshot of the planning sheet which you can see below. In the column CAP the planner can see how much capacity that ...

**0**

votes

**2**answers

3k views

### Fatal error in excel “Errors where detected while saving filename”

I have some of excel files and I got an error while saving that says "Errors where detected while saving file name. Microsoft Excel may be able to save the file by removing or repairing some features. ...

**0**

votes

**0**answers

25 views

### How do I create a Range named by another cell

is it possible to name a data range based on the value of another cell?
for example, lets say A1 has "blue" in it, then range B1:B5 is named Blue (because that is in cell A1. but then i change the ...

**0**

votes

**1**answer

35 views

### How To Return the Three Letter Month Abbreviation of a Date in Excel 2010?

I've searched here and other site without being able to find a solution. I've been able to do this in the past but can't figure it out now. I have an Effective date in, lets just say cell B1. I want ...

**0**

votes

**1**answer

20 views

### Combining SUMIF and SUBTOTAL

I have looked at each of the other posts regarding combining these two functions, but I don't understand them enough to apply them to my specific task. I have to manually create an AR aging for a ...

**0**

votes

**0**answers

22 views

### How to make 2 Excel sheets read each other and combined into 1 excel sheet

I have 2 Excel Sheets with gas card numbers and date stamps on 1 and another with date stamps and driver names. I need to know if there is a way to have the first sheet read the second and combined ...

**0**

votes

**2**answers

151 views

### Select a table using mouse in Excel 2010

Normally I can select a table by placing the mouse cursor at the upper left corner. And the cursor changes shape to imply we can select the table by a click.
On one particular workbook this doesn't ...

**-3**

votes

**0**answers

23 views

### Excel worksheet coding needed

I need help changing this code
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim int_range As Range
Set int_range = Intersect(Target, Range("B:B"))
If Not (int_range Is Nothing) Then
...

**0**

votes

**1**answer

24 views

### Excel Formula COUNTIF Issue

This is what I have for my D2 cell:
=COUNTIF(B1:B50="yes",=SUM(A2)-1),IF(OR(C1:C50,"yes",=SUM(A2)+1))
Basically what I'm trying to accomplish is this.
I have =SUM(A2) in my E2 cell for it's ...

**1**

vote

**5**answers

9k views

### Excel linked data formula turns to #REF upon opening workbook

This has happened to me multiple times (but not always). It is very frustrating and I have no idea why it does this.
A.xls contains formula that links to B.xls Sheet1. I am working on A.xls. I decide ...

**0**

votes

**0**answers

25 views

### Select specific cells in Excel

I have an Excel 2010 spreadsheet with thousands of rows and columns. I want to select specific cells from it. Is there any way to select:
every 7th cell in a column
every 7th cell but restart the ...

**1**

vote

**2**answers

3k views

### Excel 2010 Autofilter does not filter

I have a sheet with 69 columns and 6600 rows called Raw Data. I also have a sheet called Filtered Data. I have a drop down menu on the Filtered Data sheet in cell B4. The list in the drop down menu ...

**2**

votes

**1**answer

476 views

### excel sql server error: Invalid object name

I access a stored procedure on a Microsoft SQL Server 2005 database within excel using
Select *
from [dbo].[fn_ph_by15minbyQueue] ('2013-09-01','2013-09-30','LocationCode')
in the data ...

**0**

votes

**2**answers

33 views

### Converting a flat list into table in excel

How would I go about automating the conversion of a very long list in a format like this:
Into a table like this:
I am using Microsoft Excel 2010 on Windows... because of the layout of my data ...

**1**

vote

**3**answers

4k views

### Multi-row headers and excel 2010 sort/filtering

I have a spreadsheet which uses 2 rows for header information and some of the columns have the 2 rows merged together as one cell. I a multiple columns merged together in the first row, but the second ...

**0**

votes

**0**answers

11 views

### How to reconcile various fields in excel from different worksheets

I ran into a problem in trying to reconcile some data.
(Worksheet A)
Date
Reference No.(1)
Reference No. (2)
Amount Name
(Worksheet B)
Date Reference No.(1) Reference No. (2) Reference .No (3) ...

**0**

votes

**1**answer

11 views

### conditional formatting to highlight the cell

I'm using Excel 2010 and would like to know if there's any way I can choose conditional formatting to highlight the cell from a table/list after a value has been entered.
For instance, when entering ...

**0**

votes

**0**answers

10 views

### How to combine multiple databases in excel into one strong and efficient database

I'm working in a highly reputed government company as a data entry clerk and my responsibility is to keep the contact information database updated by adding new contacts and making sure that all the ...