The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
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
0answers
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
1answer
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
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
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
2answers
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
1answer
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
0answers
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
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
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
0answers
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
0answers
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
0answers
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
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
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
1answer
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
0answers
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
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
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
1answer
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
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
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
1answer
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
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
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
1answer
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
0answers
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
1answer
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
1answer
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
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
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
1answer
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
1answer
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
3answers
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
1answer
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
0answers
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
2answers
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 ...