The 2010 version of Microsoft's spreadsheet application.

**1**

vote

**1**answer

13 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

**1**answer

22 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

**0**answers

4 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

**1**answer

11 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

**2**answers

24 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

**1**answer

21 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

**1**answer

25 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

**1**answer

10 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

**1**answer

12 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

**1**answer

11 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

**1**answer

17 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

**1**answer

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

**1**answer

21 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

**1**answer

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

**2**answers

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

**0**answers

28 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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

32 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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

18 views

### Excel Issue- update from one excel [on hold]

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

**0**answers

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

**0**answers

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

**3**answers

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

**1**answer

31 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 ...

**-2**

votes

**0**answers

27 views

### How to Split two or more columns in Excel into multiple columns? [closed]

I have a list with two or more columns and I would like to split that into two or more multiple columns on a separate sheet.
An answer by Scott - http://superuser.com/users/150988/scott - only gives ...

**0**

votes

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

44 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

**1**answer

24 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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

90 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

**1**answer

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

**0**answers

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

**0**answers

24 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 ...