The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**1**answer

17 views

### Dropdown + Autofill

I have a address list(name, street,city,telnumber)
On another sheet I have a form, where I can choose the name from an dropdown list. Now I want to get street,city, telnumber for this name. Is this ...

**0**

votes

**1**answer

13 views

### Excel odd @ formula in table

I have an Excel workbook from ancient times. A table with header and rows of data are recorded in it. I insert a new column next to an existing one and start typing in an if formula in the first row.
...

**2**

votes

**1**answer

35 views

### Excel - keyboard shortcut to double click on format painter

Double clicking on Format Painter has the effect of allowing you to click a few times and apply the same format in all those places.
Alt-H-FP has the same effect as a single click on format painter.
...

**4**

votes

**3**answers

47 views

### Keep Specific Columns From Repeating in Excel

There is a report that I pull from our ERP system that lists order detail information. It will list the order number, customer code, customer name, order date, order status, order total, product code, ...

**-2**

votes

**0**answers

31 views

### tallying with different criteria

An example:
Apple Worm Black
Apple Worm Black Sour
Apple Black
Orange Sweet
Orange Sweet
(5 rows and 4 separate columns)
How do I create a formula to tally all the Red apples with a worm or ...

**0**

votes

**1**answer

10 views

### Can you change the type of an object in EXCEL

I created a rectangle object with text inside an EXCEL document and formatted it a lot, if I want to suddenly change it to circular (oblique) type, is there a way to do this in EXCEL?
Right now, I ...

**0**

votes

**0**answers

35 views

### Excel, macro move one row down and then delete the row

I'm trying to clean up duplicate rows. My data is in a table with filters applied. I have tried using the Excel feature to remove duplicates, but get the following error.
Cannot complete ...

**0**

votes

**1**answer

38 views

### Multiple Formulas in one Cell for hotel

I am trying to create a housekeeping spreadsheet where when a room number is entered into a cell a 0 or 1 (0 is for studio and 1 is for a 1 bedroom) is automatically populated in another cell. I have ...

**2**

votes

**0**answers

17 views

### How to return results of SQL query to Excel sheet with VBA function [duplicate]

I'm trying to create a VBA function in Excel to affect dynamic value from Access to Excel sheet. This is my code.
Public Function SQL(DB As String, Query As String)
Dim conn As ADODB.Connection
...

**0**

votes

**0**answers

13 views

### Strange behaviour of pivot table - entry masked

I've a very strange issue in Excel 2010 pivot table. One entry of my data gets replaced to " " (space) in pivot table. "GR45ZF1402010" is not visible as you see below, if I change just one character ...

**0**

votes

**0**answers

9 views

### When moving data in Excel, how do I get data validation from destination

I have a workbook with three sheets, Active, Finished, and Tables. Tables contains auxiliary Tables for data validation.
At some point a row in Active will be moved to the Finished sheet. Both those ...

**0**

votes

**1**answer

25 views

### MS Excel - Cumulative sum of a column based on “id values” in another column?

I have been trying to figure out how to make a formula that calculates cumulative sums of rows in a column based on their id values in another column but still haven't found any solution for it. I try ...

**0**

votes

**0**answers

19 views

### How to determine or highlight cells their values will Sum a particular given number?

If the sheet contains a column of values, and I would like to determine or highlight the cells that their values will sum a particular given number (value):
For Example:
If the column contains these ...

**1**

vote

**1**answer

45 views

### How can I replace forbidden characters in a file names before saving in VBA?

This will be very simple for somebody who knows VBA better than me. I used a code original provided by user Nixda on this forum to split excel worksheet into multiple CSV files based on column value ...

**0**

votes

**1**answer

67 views

### Hotkey to open filter drop down menu in merged cell in Excel 2010

I use Excel 2010 and use Alt+Down arrow to open filter drop down menus.
Sometimes my header contains vertically merged cells (e.g. autofilters are in the second row and in some columns cells in rows ...

**0**

votes

**1**answer

36 views

### SUMIFS w/ multiple Criteria

Base on the Emp ID and the Pay End date I'm looking to sum up the Total Earnings and if it is equal to or higher than the WC Cap in the exposure column I'd like to return the WC Cap value. If it's ...

**0**

votes

**2**answers

45 views

### How to give worksheet tab a color if range of cells contains text

I have tried code that I've found on SE, and elsewhere but they aren't working as I think they can. I'll list them below. I'm almost certain this is an easy question.
What I'm trying to do: If in any ...

**1**

vote

**2**answers

35 views

### How to list all possible solutions for missing digit?

In Excel, I want to add 2 numbers with missing digits and would like a list of all possible solutions.
For example: Given 5.x1 + 2.y1 = 7.32, what are the possible combinations of x and y?
In this ...

**1**

vote

**0**answers

16 views

### Deleted record keeps reappearing in data file using MS Word 10 merge/Excel 10 spreadsheet

I am unable to remove one particular record from my data file. I remove it from the excel spreadsheet, but when I try to merge it is back--even after I have changed the file name after removing the ...

**0**

votes

**0**answers

10 views

### Task descriptions from Excel to Outlook 2010

After creating in Excel the appropriate column headers for the export to Outlook, the name "description" exports the data into an Outlook calendar item, but does not do so into an Outlook task item. ...

**0**

votes

**1**answer

32 views

### Plotting 3000 data vs date in excel [closed]

I have 3000 data which are registration numbers and every reg.number corresponds to a date. Some dates have several registration numbers. It looks like this:
Date - - - - - - Registration number
...

**1**

vote

**1**answer

17 views

### Leave a pmt cell blank until data is entered

I am making a spreadsheet with the pmt function. I want the cell with the pmt to remain blank until interest rate, time, and pv is entered.
I have the pmt formula: =PMT(C2/12,C3,C4) And I do not want ...

**0**

votes

**0**answers

28 views

### Mysterious “Reference not valid”

Error dialog: Reference not valid
I have a big sheet with 30+ pivot tables made from the same 3 named tables.
Every time i run refresh all I get the Reference Not Valid-error.
I have no idea which ...

**-2**

votes

**1**answer

41 views

### Is there a way in Excel 2010 to have a formula in one cell and show in a different cell? [duplicate]

I want the formula to be in one cell, and the result in another cell. I do not want the answer to populate the cell that contains the formula.

**1**

vote

**2**answers

79 views

### How to convert a number for a salary amount, to a specific, 9 digit, format in Excel

If I enter a salary dollar amount as 34512.15, I'd like to have a formula return this amount in a specific format as follows:
M(HT)(TT)(TH)HTOCC
M=Millions
(HT)=Hundred Thousands
(TT)=Ten Thousands
...

**0**

votes

**1**answer

27 views

### Count items in comma separated list in single cell

Is there a formula that will count the number of items in a cell, each separated by a comma?
For example:
CELL A1 = "Dell, Apple, Samsung, Acer"
Formula would return 4.

**-1**

votes

**1**answer

27 views

### Why doesn´t Excel function change cells for calcuation

I have the following function:
=SUMIF('Pivot'!$A$5:$A$51;'Projects Overview'!E4;'Pivot'!$B$5:$B$51)
I need it to automatically change $B$5:$B$51 to $C$5:$C$51, $D$5:$D$51, etc. when dragging the ...

**-1**

votes

**0**answers

20 views

### Deleting columns from Excel [duplicate]

You responded to a question on How to delete specific columns from all excel workbooks in a particular folder.
When I tried to use it, an error said that "Title" was undefined.
Thanks for your help. ...

**0**

votes

**1**answer

16 views

### count the number of sequential duplicates in excel but start back at 1 if there are more than 3 sequential duplicates

I have a spreadsheet displaying hardware equipment in sector level. For instance:
023008_SHELBY
023008_SHELBY
023008_SHELBY
023009_SWAN_29TH_ST
023009_SWAN_29TH_ST
023009_SWAN_29TH_ST
...

**0**

votes

**1**answer

70 views

### How to use Index and Match formulas for multiple criteria

I have a spreadsheet that contains Olympic information, with the following fields in columns:
A) Athlete, B) Age, C) Country, D) Year, E) Closing Ceremony Date, F) Sport G) Gold Medals.
I want ...

**0**

votes

**1**answer

39 views

### How can I make a Scattered chart in excel where the dots are different colors?

I have the following info:
Question | Importance | Percentage
1 | 2 | 15%
2 | 1 | 98%
3 | 1 | 35%
4 | 3 | 22%
5 ...

**2**

votes

**1**answer

23 views

### Horizontal array constant definition issue

I can't understand where I fail (except following MS-original help :-D) in attempt to enter horizontal array constant (C+S+E seq) per MS guidance accessible either from Excel 2007 or 2010 help, or at ...

**1**

vote

**1**answer

33 views

### In Excel, How can I add values in a specific column if I have a checkbox type spreadsheet?

The Excel sheet is linear with column B being the distance walked each day. Across are a column for each participant. As they join the walking group each day, I'd like to keep a count on total ...

**0**

votes

**1**answer

17 views

### minimized workbook has no restore button

When I minimize work books they do not have a restore (or maximize) button, just the close button. Makes it hard to restore them! Any ideas? is there a registry setting that is messed up that makes ...

**0**

votes

**1**answer

32 views

### Find column number in excel based on header names using formula

I have a table in excel with the following 2 header row layout:
A B C D E F G H I
1 qtr01, qtr02, qtr03, qtr04, qtr01, qtr02, qtr03, qtr04, qtr01
2 2013, ...

**0**

votes

**0**answers

9 views

### Identify duplicate numbers within the “month” range of cells

Below is how I set up my month tracking dates on left column and each date certain numbers are tracked if identified in the data. I am trying to identify if there are any numbers repeated within a ...

**0**

votes

**0**answers

15 views

### Cannot use Buttons with VBA in 2003 but can use buttons from same sheet in 2010 Excel

I have excel 2003 and 2010 installed on our computers. I reinstalled both, did a system restore. I manually uninstalled all updates from the past month (this started happening 1-1.5 weeks ago) I am ...

**1**

vote

**0**answers

21 views

### How do I incorporate IFERROR into this formula?

I need to know how to include an IFERROR statement in this formula in Excel 2007.
=VLOOKUP($E3,HSA!$E$3:$G$20,2,FALSE)*$D3
I want the formula to return a 0 instead of an #N/A.

**0**

votes

**1**answer

28 views

### How to display/hide data validation input message in Excel 2010?

I've applied input messages to the cells:
For example if a cell is clicked then a message is displayed mentioning the cell. The problem is once the message is displayed, it does not hide unless ...

**1**

vote

**2**answers

30 views

### How do I compare two list of data that contains a certain number in Excell?

How do I compare two lists of columns that contains a certain number? Please look at my example below:
Column 1 Column 2
-------------------
300 Room 305
301 Room 306
302 Room ...

**0**

votes

**1**answer

18 views

### Changing Scientific Format in HTML File to General or Text Format

When I run a query in PeopleSoft I have the option of opening it as a run to HTML file (which results in a .csv file) or as run to an Excel file.
The issue is that when it is opened in HTML certain ...

**0**

votes

**1**answer

17 views

### How can I create multiple spreadsheets using the value of a column?

I have a workbook (Req_PO_Log_V2.xls) that has all of the expenditures for our repair and maintenance funds from our current FY. The lay out is as follows:
| Date | Req Number | Acct | Vendor # | ...

**0**

votes

**0**answers

8 views

### updating cell values based on entries in identical sheets

i have a work book, with a design sheet and three identical data sheets- having the same template.
i want the value in sheet A1 of the design(master sheet) to change whenever the value of the cells A1 ...

**0**

votes

**2**answers

74 views

### IF Statement with VLOOKUP

I'm trying to get a value from the ADD Taxable which is column 10 in the Check (sheet). I only want the value from column 10 if the Earn Type on Timecard (Sheet) has BONUS in it. I'm using the TC Ref ...

**0**

votes

**2**answers

41 views

### Why is Microsoft Excel 2010 Showing a file open by another user when it isn't? [closed]

I am trying to open a file which tell me that it is open by another user and offers as read only. However, no-one is accessing the file.
Yes, the file is available to more than one user but IS NOT ...

**1**

vote

**1**answer

30 views

### Make short key for searching filter in Excel 2010

Can one help me to make a short key for the following procedure in Excel 2010 (ALT+DownArrow then E) . this used to go directly to search box in filter excel like shown in photo
and if some know ...

**0**

votes

**0**answers

15 views

### Excel documents are opening as maximized

I reinstalled win8.1, Excel 2010 and now, every time I open a document, my workspace getting maximized.
For example: When I open one worksheet... even if it appears in small window on big workspace, ...

**0**

votes

**0**answers

11 views

### Excel - Indexing non-financial data

I have an index of Bates stamped (numerically stamped, similar to page numbers) documents in Excel. There may be a series of 50 or more documents that are related, and I am looking for a way to ...

**0**

votes

**0**answers

64 views

### Excel: Create a Collapsible Master-Detail View From Another Sheet?

I'm designing an excel template for importing data (into another DBMS).
The problem is, the data will be separated (normalized) into several tables in my DBMS (master-detail model).
Let's say I have ...

**-1**

votes

**1**answer

50 views

### Can I split a spreadsheet into multiple files based on a Row in Excel 2013?

I have a spreadsheet in excel 2013 which have multiple column and rows. I need to send some columns to different people separate files. Please anyone can help me in this. Please try to use macros, or ...