The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

2 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

6 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

**0**answers

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

**0**

votes

**1**answer

16 views

### How to do up a excel hair chart?

[![enter image description here][1]][1]
Hello there,
Not sure whether this is workable?
i'm trying to do up a chart (on excel), the chart that i have in mind is somewhat similar to the attached ...

**0**

votes

**0**answers

6 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

3 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

8 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

**1**answer

17 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

14 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? [on hold]

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

17 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

18 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

6 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

18 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

282 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

28 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

37 views

### excel extracting data and concatenating fields? [on hold]

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

31 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

16 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

30 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

27 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

34 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

48 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

86 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

22 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

**1**answer

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

**0**

votes

**1**answer

20 views

### EXCEL: Dynamic list and count of instances

I have a live datasource from a web page and in one of the columns it has an account code.
In my excel spreadsheet I'm looking at building a list of the account codes in one column and then in the ...

**1**

vote

**3**answers

47 views

### Excel Formula to Calculate Percentage on Different Sheet

I am trying to calculate the percentage of completed items from a a list.
Let's say:
#of Visit Place Comment
-------- ----- -----
355 A abc
345 B ...

**0**

votes

**1**answer

25 views

### CSV Input for Merged Columns in Microsoft Excel

I am using Excel 2010 (v14.0) on Windows 7.
I would like to have a header, and subheader, where columns are merged in the header but separated in the subheader and data. I know how to merge columns ...

**0**

votes

**0**answers

5 views

### Drag and drop .xla file onto MS Excel 2010

I have a .xla file that I need to drag and drop onto an MS Excel 2010 file, how do I do this? I have saved on desktop, highlighted it and dragged to a normal/new ms excel 2010 but fails and gives an ...

**-1**

votes

**0**answers

6 views

### Drag and Drop a .xla file onto an an excel 2010 (xls,xls) file

I have been sent a .xla file that I need to open a normal excel file, drag and drop the .xla file onto it for a specific upload into a payment system, but has failed. I gives me an error 'Office has ...

**2**

votes

**2**answers

32 views

### How to create a data series for exponential decrease diagram

I want to create a pricing model this way:
If you need this product for 50 people, you should pay 2500 (units) per person.
.
.
.
.
If you need this product for 10,000 people, you should pay 300 ...

**1**

vote

**1**answer

17 views

### Excel 2010 - Vertical alignment of text simply not working

I have a long, multiple line-break-separated (Alt+Enter) text in a cell, and I would like to set its height to a specific number, but still see the most recent note I made (going from top to bottom), ...

**1**

vote

**1**answer

35 views

### vba macro - find first blank column from specific row range

Most of the solutions I have googled were either about finding the first blank column or first blank row, but I specifically need to find the first blank column in a range of rows.
What I need is to ...

**0**

votes

**1**answer

32 views

### Concatenate two columns, look for duplicates copy single row to new worksheet

I have an Excel or CSV file with 5,000 rows and 20 columns.
I want to concatenate Column 6 and Column 8, look for duplicates and then copy only one of the duplicates into WorkSheet2.
For Example:
...

**1**

vote

**1**answer

32 views

### Filtering data in Excel using multiples of a number

I want to filter my data to only include values that are multiples of 12. So it should include 12,24,36, etc.
Is there a way to use the filter function so this can be done?