The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

2
votes
2answers
27 views

Filtering Data Excel Data from Survey to Obtain E-mails

Over the summer we conducted a survey for a number of students to indicate their interest in a number of clubs. The way the responses were scanned in gave us a column for each club and a '1' in each ...
-3
votes
1answer
25 views

Entering every Monday Tuesday and Friday as a date

Hi I need to enter the date of every monday, tuesday and thursday on top of a sheet to use as a register, I have looked at the one below and this works for two days, could you please help me to extend ...
0
votes
0answers
5 views

Handling exported reports from BI portal in Excel 2010 causing performance issues?

So, I'm going to try to describe this the best I can. Multiple uses at my office will often export large reports from the BI system of the SAP web portal. These files can be as large as 25-50mb, ...
1
vote
1answer
13 views

Chart Series name referencing cell address Excel 2010 VBA

I am using Excel 2010. I have a XY scatter chart built and formatted the way I like. I reuse this chart many times, so I just copy and paste the chart into a new worksheet containing the new data ...
0
votes
2answers
25 views

EXCEL VLOOKUP returning #NA when IF condition specifies “ ”

=IF(VLOOKUP(D4,'[05.14_Wave 5 Priority 14 (Big+Cranberry) Specifications.xlsx]Big'!$B:$B,1,FALSE),"Project BIG",IF(VLOOKUP(D4,'[05.14_Wave 5 Priority 14 (Big+Cranberry) ...
-2
votes
1answer
23 views

Excel 2010 - possible to apply a function to an entire column?

In Excel 2010, is it possible to apply a function (not a formula) to an entire column (without dragging the plus symbol all the way to the bottom)?
1
vote
1answer
26 views

Create a formula to find difference between values in regularly spaced rows

Lets say I have 100 rows in column A. That would be 100 cells with a value in each. I only want the value of the difference between every 5 cells. For example, in the first cell, A5-A1, then next cell ...
0
votes
1answer
11 views

Transpose list of dates based on both ID and Category in Excel or Access 2010

I've got a very long list of three columns: ID, category and Date. The ID field is repeated for each different date, with a category of 1 to 3 assigned. I really need to get these into a form I can ...
0
votes
1answer
13 views

If/Then (# to Text) With Multiple Number Ranges

I am using Excel and trying to create a formula. Part of the formula works, the next doesn't. I'll explain. Column P is "BPM" (Beats Per Minute) and will have a numeric value, which will be entered ...
0
votes
1answer
12 views

Change pivot table layout into “more columns”

When I create a pivot table in excel 2010 my table looks like that: Any suggestions how to get this extra colume filled up with the names within a pivot table? Or do I need to use power pivot? How ...
-1
votes
1answer
19 views

Modifying Column Charts in Excel

I was wondering if someone might be able to help me figure out how to create a particular chart in excel. The rows are businesses and the columns are what percentage of people in area A and B that use ...
1
vote
1answer
14 views

How to properly highlight alternating rows after Filtering / Sorting?

I have this Excel sheet with about 2,000 rows of data : I've applied a handful of Filters on Comparison Result & Extension, then added a few Sorting parameters for all of the columns. If I ...
1
vote
1answer
23 views

How can I use if function in excel to count unique numbers which are not greater than given time duration

I'd like to ask something. I have bunch of transaction data containing date, time, ID like this: DATE //TIME //ID 7/6/2015 //9:30:22 //0266731550 7/6/2015 // 9:33:19 // ...
0
votes
1answer
23 views

Excel 2010 Macro to Find & Replace

I have multiple work sheets in one work book. The work sheets i'm concerned with are WD, Hit, Sam, Sea, and Max. Each page uses the same exact template, so everything should match up... Here's the ...
2
votes
2answers
49 views

How to do up a excel hair chart?

I'm trying to do up a chart (on excel), the chart that I have in mind is somewhat similar to the attached picture. Data: X-axis: dates (weekly data) Y-axis: interest rates Doing this, I can ...
1
vote
0answers
29 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 ...
0
votes
0answers
4 views

Either/or input options based on other cells

I am doing a tournament bracket on a spreadsheet. When guessing the winner of a game, I would like the "winner" cell to present only the binary option to the user, who has only to click on one of the ...
0
votes
0answers
9 views

Conditional formatting in Excel 2010 - Highlight a whole row in which a cell value falls between a specific day range

I need the whole row highlighted in yellow if the value entered in a cell (in Column C) falls between the 6th and 19th of any month or year, or in blue if it's between the 20th and the 5th. Thank you ...
2
votes
2answers
27 views

Excel: Calculate IF column based on another IF column

I am trying to use Excel to create a scorecard for different companies to use. The product I create needs to be a finished product - when a company representative fills out certain information on ...
1
vote
1answer
11 views

Inserting formula through VBA in “A1” reference style

I insert this formula through VBA, Cells(1, 1).FormulaR1C1 = "=LEFT(A2;5)" But the formula which gets inserted ends up with apostrophes. =LEFT('A2';5) This works perfectly with the R1C1 ...
0
votes
1answer
15 views

Keep history of changes on an excel table to another sheet

I am trying to create a dashboard in excel 2010 for my department that will be as much automated as possible. So, I have a table, with data that will be updated in each cell every month or week. Now ...
-2
votes
2answers
28 views

How to find a cell with same special character twice? [closed]

I have a list A1:A4000 want to sort or find cells having special character '@' two times in one cell.
0
votes
1answer
33 views

Excel Formula with conditions

This feels like it should be simple but my head is hurting now and I'm struggling. I need to add a condition to an existing sheet which already contains formulas and references to other sheets. ...
0
votes
0answers
19 views

How to disable 'This workbooks contains one or more links that cannot be updated' popup on open

When opening a sheet I get this popup, how to suppress it completely on sheet basis, not machine basis? I never want to see it no matter whats the status of the links.
0
votes
0answers
11 views

Copy Blank Count

i want to copy the blank color count under Color column from "5-Jul-15" sheet and "6-Jul-15" sheet to ABC sheet under "5-Jul-15" and "6-Jul-15" column (i.e. C13 and E13) respectively. It should ...
0
votes
1answer
19 views

Microsoft Excel: Merge two sheets and dedup

I have a pretty simple question and google can't seem to return what I'm looking for. Essentially I have two sheets in one workbook, both contain the exact same columns. The primary key (and first ...
0
votes
0answers
7 views

Pivot Table loses Custom Sort Order when saved

I have a Pivot Table in Excel 2010 on which I have sorted one column with a Custom List: Jan-2008 Feb-2008 [..] Nov-2025 Dec-2025 This works fine until I save the workbook. When I re-open the ...
0
votes
0answers
18 views

Excel Issue- update from one excel [closed]

I would like to update an excel based on values from other excel. Issue I have two sheets in a work book. Master, Updator. In updater I update some values. Updator Data ( two columns) CR ...
0
votes
0answers
19 views

Is this possible to generate excel combo box based on cell value?

As you can see, Cell C2 got 1,2,3,4. I assume this is a student id. So, I would like to generate a combo box in Cell B8, using Cell C2's data, separated by ,. So, in this case, the combo box should ...
-2
votes
0answers
12 views

How to populate values in rows based on column labels?

I have the following query : My input table is ![enter image description here][1] ![enter image description here][2] ![enter image description here][3] Basically I want to locate value for numbers ...
3
votes
3answers
283 views

How do I keep a running Subtotal/Sum in Excel?

I know this is probably a super simple question, but I have no clue how to word it in Google so I could find out on my own. I have a spreadsheet in Excel that's basically a shopping list: ...
0
votes
1answer
32 views

How can I get an average of times in Excel?

I Have a column of cells in excel of format hh:mm (The day is NOT included) like: 19:08 19:08 19:40 20:10 1:45 (Any Times before 12:00 noon are considered NEXT DAY) one (or more of these) is after ...
0
votes
1answer
28 views

Count appearances of two cells in a 5x100 matrix

I have two cells that I want to compare against a 5 columns by 100 rows matrix where they can appear. I have tried this but doesn't work: ...
-1
votes
1answer
38 views

excel extracting data and concatenating fields? [closed]

I have a large excel sheet which I want to extract some certain fields. Here is an example: Column 1 has a list of countries: Country: USA | UK | India | GER Column 2 has a list of route IDs: ...
2
votes
1answer
33 views

Copy/Paste Several Excel Columns

Suppose I have an Excel file with columns A,B,C,D, and E. I need to copy and paste columns A,B, and E into a text editor. However whenever I paste the data, I end up getting columns C and D. I ...
0
votes
1answer
19 views

Format an Excel cell from VB 6.0 with an amount to two decimal places

When using vb 6.0 to make a cell, we cannot force the amount to be shown with 2 places after the decimal if the number does not have end in 1-9. For example 59.12 shows up correctly but if we try ...
0
votes
1answer
23 views

Excel 2010, how to summarize counts based on month listed by row

If I have a set of data with a month listed for each row and want to sum various column counts by month listed, how do I do that? For example, I have 10 rows of data, with two rows being "June" and 8 ...
0
votes
1answer
26 views

True and False 2 sheets

I have to input a value in column I in sheet 1 from excel and in the column "D" from sheet 2 it needs to appear true or false. If there's any value in I than it should be true in "D" otherwise ...
0
votes
1answer
45 views

Excel Formula - Match

Can someone recommend a way to write a formula that will achieve the following. I can achieve these things individually but stringing together seems to be difficult. I have a list of orders with ...
0
votes
1answer
26 views

In excel how could I generate a row of data from another sheet?

In excel I have a sheet named "sales", and another one named "factor". In factor I have some fields for factor ID, customer name, product code, quantities and price. I want when I add this data to ...
1
vote
1answer
21 views

Excel - pivot date values with max function

I am trying to pivot date values in a pivot table in MS Excel. I am getting incorrect date values. I do not want "Grand Total" as they do not apply for dates. Is it possible to do such pivots in ...
0
votes
1answer
31 views

filter excel list by formula instead of values

If I have a column in excel, with the following formulas, would it be possible to filter it? In this case, the values are all 7, but could I filter by the explicit formula? =2+7 =3+4 =2+7 7 =1+6 7 ...
0
votes
1answer
29 views

Elapsed time between two timestamps

I'm having real trouble converting two timestamps into elapsed time in seconds for example: 07/16/2015 14:01:42:140 07/16/2015 14:01:52:563 I have tried multiple functions and the classic (A3-A2) ...
1
vote
0answers
40 views

Insert Hyperlink in word to an excel file that will open read-only when clicked?

To manually open an excel file as read-only I usually use excel /r "filename" on the command line, or just click file, open, open as read only from excel. If I insert a hyperlink to an excel file in ...
1
vote
1answer
51 views

Sorting by different currency symbols in Excel 2010

The Accounting Department enters receipts of money in different currencies ($, shekels, & Australian pounds). Is it possible to sort a column containing mixed currencies by currency type if the ...
2
votes
1answer
93 views

Is it possible to reference two cells in Excel to find a third cell?

I have a spreadsheet that has a decent amount of data on it. I need to return some of that data to certain cells. The data that I need to return is always near a cell with "Attached Components" in it. ...
0
votes
1answer
19 views

Excel highligting

I have been searching for the answer on my own, problem is that I cannot find one similar to my issue. I have 2 columns of data "C" and "D". I am trying to set it up so that if "C" is a greater number ...
1
vote
0answers
37 views

Enter the Date (and Other) Values [closed]

Excel interprets following inputs as a date values: July 15, Jul 15, Jul. 15, 7-15, 7/15. Similarly, Excel accepts time values in several formats: 14:00, 2 pm, 2 p, 2:00 pm. What are all valid input ...
1
vote
0answers
25 views

Excel lookup value not on same row

What i`m looking for is that the data will be filled automatically from data table by lookup value in not same row. See the picture or xls example https://dropmefiles.com/BDlHe 1st table lookup ...
1
vote
1answer
23 views

Point location of excel data connection to a new directory for multiple files

I have a spreadsheet that has data connections to multiple delimited text files, which are periodically updated. When they update, I refresh in excel, the whole spreadsheet updates, and I feel like a ...