The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
1answer
7 views

Count unique values within specified variable date range

I'm attempting to create a report that includes a count of unique values from a table. I'm using Excel 2010. Normally this would be an easy matter of adding a column to the source data with a formula ...
0
votes
2answers
21 views

Needs VBA solution - Clear contents of 4 cells to left of cell with N/A Error

I have a table of data in which column L has a vlookup formula. In the rows where column L (i.e., the vlookup returns "#N/A"), I would like to clear the contents of the eight cells to the left ...
3
votes
1answer
26 views

Excel to count number of concurrent sessions based on start/end times

I have a massive set of data that I'm trying to work through. In Column A, I have a username, in Column B I have a session start date/time, in Column C I have the session end date/time. I am trying ...
-1
votes
0answers
14 views

How can a cell be displayed if another cell is marked?

I am a trainer for an organization, and we have a major conversion to a new core system coming up. We have been provided a massive spreadsheet listing all the training modules that each person must ...
0
votes
2answers
26 views

Check if a cell contains any of words from a dynamic list

I want to use a formula to populate the "RESULTS" cells. I need it to check if the adjacent "CHECKED CELL" contains any of the words listed in the "KEYWORDS" cells. Ideally, I would be able to add ...
0
votes
0answers
6 views

How to save .xls file to tab-delimited(.txt) and specify Shift-JIS encoding

What I want to do is save .xls file to tab delimited .txt file with specifying SHIFT-JIS encoding. I tried specifying encoding in web options however when I save to tab delimited still japanese ...
0
votes
0answers
10 views

Using if to compare name of a worksheet with worksheets in workbook

I have two files Main file and Result. Main file have multiple worksheet like delhi, moscow, paris, scotland and each one has same type of date and same heading ie.: S_No. , Vendor, VendorId, ...
0
votes
3answers
25 views

How to highlight where a number in another cell falls in a column? Bracket it with the next highest and next lowest?

This is probably an easy fix. I have one cell (Cell B8) with say the number 2000 in it. I have another column of 6 numbers (Cell A1 to A6) (Say 4000, 3050, 2100,2100, 1150, 200) that will change with ...
0
votes
1answer
35 views

How to make data shown on excel drop down list appear as numbers (shortcuts)?

Is it possible to have the data (choices) shown when clicking the drop down list to appear as numbers (or any text other than the actual text from validation data source)? Let's say the choices ...
0
votes
1answer
14 views

Excel playoff bracket

I've created a playoff bracket and want to setup a way to automatically move the team name to the next round (another cell) once 4 wins are achieved. I'm using Excel 2010. Example: Compare the value ...
0
votes
1answer
10 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
0answers
14 views

Most efficient function(s) to compare and extract rows from two reports?

I work for an international shipping company processing hundreds of containers each day. I generate a report (from an AS 11g servlet, FWIW) in the morning, work through it based on the 2 Modes of ...
0
votes
1answer
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
1answer
29 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
3answers
39 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, ...
0
votes
1answer
21 views

Cannot open Excel 2010 file

my Windows 2008 R2 file server broke down last week, and I had to re-install the server. Now several Excel files cannot open up. When trying to open the files I get the message that: The file you ...
-2
votes
0answers
28 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
1answer
9 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
0answers
22 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
1answer
31 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
0answers
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
0answers
10 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
0answers
7 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
1answer
19 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
0answers
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
1answer
41 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
0answers
14 views
+50

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
1answer
30 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
2answers
38 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
2answers
33 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
0answers
13 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
0answers
6 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
1answer
29 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
votes
1answer
12 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
0answers
22 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
1answer
37 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
2answers
75 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
1answer
23 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
1answer
23 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
0answers
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
1answer
14 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
1answer
64 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
1answer
32 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
1answer
22 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
1answer
32 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
1answer
16 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
1answer
23 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
0answers
8 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
0answers
14 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
0answers
19 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.