The 2010 version of Microsoft's spreadsheet application.

**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

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

**1**

vote

**1**answer

15 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

13 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

31 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

281 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:
...

**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

43 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

29 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

26 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

32 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

85 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

33 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

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

**0**

votes

**1**answer

34 views

### Creating yearly averages from monthly data in Excel

My ultimate goal is to graph yearly averages of my data. I have monthly data, and I would only like to return the average for each 12 month period.
PERIOD MONTHLY YEARLY AVERAGE
1 10
...

**1**

vote

**1**answer

66 views

### Auto-populate values based on multiple dependencies in Excel

I have three columns with information filled in already. The value in Column C is dependent on two identifiers from Columns A & B (i.e., George is always the seller of Apples in America, but Sarah ...

**1**

vote

**1**answer

7 views

### Excel Tab with Record Macro

I cannot find Record Macro in Excel 2010. I thought I remember it being in a hidden taskbar tab. I cannot find the setting in Excel Options. Maybe it's a registry hack.
Where is the setting to ...

**4**

votes

**0**answers

30 views

### Use functions like Countif, Countblank etc. to refer to discontiguous ranges.

Is there a way to use array formulas or some other feature to essentially have an excel function that means.
=Countblank({A1,A4:A6,A112:127,B29:B38}) etc.
Essentially, I want to refer to multiple ...

**1**

vote

**0**answers

17 views

### Is there a way to use cell references instead of structured table references?

I have a table, on the outside of which is a column of formulas referencing cells within the table. When creating the formula, clicking on the table cells or using the arrow keys to move to the ...

**1**

vote

**2**answers

41 views

### How to get the count of the most frequent matching columns?

Need some help figuring out how to do this in Excel.
I have a long list of names split up into 2 columns - the first and the last name. I'd like to figure out what are the 5 most popular full names ...