The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

9 views

### New items in drop down validation menu aren't showing in Excel 2010

In Excel version 14.4.2, I have a drop down validation menu and I have added more cells with new menu items.
However, these new items are not showing on the drop down menu on all the cells of the ...

**1**

vote

**0**answers

21 views

### How to recover some missing data in Excel?

I have two versions of an Excel file, one from before I did a lot of work on it and one from after. The after-version, despite a lot of productive work, also includes the results of a catastrophic ...

**1**

vote

**1**answer

42 views

### Excel: Different background colors on condition

The problem
I have a Excel sheet that contains a status column.
Number Status Name
-------------------------------------
1 not implemented feature 1
2 completed ...

**1**

vote

**1**answer

29 views

### How can retrieve cell address that match criteria?

In column A are various products (A2:A100), in column B are different numbers (B2:B100).
In cell G2 is criteria from column A.
With the formula {=MAX(IF($A$2:$A$100=G2;$B$2:$B$100))}, I can find ...

**-1**

votes

**0**answers

39 views

### EXCEL: How do i work out how many bike riders/skateboarders where male/female? [on hold]

I have four columns in an excel document that can be grouped into two sections; one showing whether survey respondents were skateboarders or bike riders and the other showing whether they were male or ...

**1**

vote

**2**answers

17 views

### Apply VLOOKUP to multiple sheets and ignore blanks

I would like to do a VLOOKUP on multiple sheets (for which I am able to define a strict priority order) but where I want to ignore the answer when it is a blank. I have found this answer:
Apply ...

**0**

votes

**1**answer

19 views

### How to automatically delete rows that contain certain numbers in the ID column

I have a column of numbers in another workbook and I would like to use that set of numbers to delete rows in the main workbook. I will give an simplified example of what I'm talking about below. My ...

**1**

vote

**1**answer

23 views

### Unwanted space in URLS in Excel 2010

I have a list of 23000 URLs in an Excel sheet but these appear to have extra spaces in, therefore invalidating the urls.
I've tried a find and replace and excel doesn't recognise that there is an ...

**0**

votes

**1**answer

18 views

### My excell spreadsheet keeps turning 1/43 into a date.

I have tried to change it to "Gerneral" in the format bar but it changes right back to "Custom". How do I fix this? My intention is to not that this is 1 of 43 boxes not Jan-43

**0**

votes

**1**answer

31 views

### Lookup with multiple criteria and priority

I am working with different excel files which contain a lot of data from different people. I would like to do a lookup (I know how to use the LOOKUP function) but based on multiple criteria. Let me ...

**0**

votes

**0**answers

10 views

### How to link quickly to various pdf files in Excel

I have an excel database with hundreds of products. Each products is assigned a specific security PDF sheet in a folder.
Is there a way to optimize my linking routine?
My way:
Click insert - link - ...

**0**

votes

**2**answers

20 views

### Excel 2010 array formula cell selection

Suppose you have a workbook riddled with array formula.
In Excel 2007, if you select any cell (which is part of an array formula), then hit F2 to edit, you have to go ctrl+shift+enter to enter the ...

**0**

votes

**1**answer

23 views

### Microsoft Excel Custom Label Overlay on Line Graph

I have 2 tables identical.
One records the progression of projects as a percentage over dates until completion.
The other is a replica table but records the daily status of the projects on the ...

**-1**

votes

**0**answers

11 views

### Excel Query How to refer to the last value found in a cell that is somewhere above the current cell

I need help with a formula that can do the following in column W. (if you can see the image)
spreadsheet
ok I have 2 columns: column N records a "W" or "L", column W is recording the no of attempts ...

**0**

votes

**1**answer

23 views

### Excel Formula Issue Countif to Sumproduct

Having a nightmare at the moment with some formula's I've been asked to 'fix'. It would seem the users expected them to work with closed source spreadsheets but they don't. So they end up having to ...

**-1**

votes

**0**answers

21 views

### comparing 2 columns in excel and return the same result in a group

hi m new in excel function,
i have a problem like this. i have 2 lists of data
DATA I
NAME SCORE
----- -----
ANA 10
BUDI 20
TINA 30
DATA II
NAME SCORE
----- ...

**-1**

votes

**1**answer

22 views

### Excel formula: identifying highest weights

I need some help with the following assignment:
Task:
In the product Weight tab, you can see each product is weighted with a value per customer. Please create a Product Code for each customer based ...

**0**

votes

**1**answer

11 views

### Excel column entries modification

I have a big Excel file containing a column where I have entries of the type
A3F44
and I would like to transfrom them into
A3F4 - 4
in order to match them with the entries in another file. As ...

**0**

votes

**0**answers

14 views

### MS ergo 4000 keyboard work with excel

I'm using a Microsoft Natural Ergonomic 4000 keyboard with Microsoft Excel 2010. The keyboard's zoom button acts as the scroll function in Excel instead of the zoom function.
How do I change it so ...

**-2**

votes

**0**answers

10 views

### Excel Column Formatting

I am looking to Format a column of text in excel for example
A
ABC123
123DGF
ABC124
NMO445
B
Corp
Acct
Corp
HR
I want excel to notice the text entered in column A and then ...

**0**

votes

**0**answers

8 views

### Excel Command Button to change Cell Focus

I have a multi sheet workbook I use for staff rostering. Each sheet is for for a 6 month period (eg Sheet 1 is Jan-Jun 2014, Sheet 2 is Jul-Dec 2014) going back to 2010.
I have the dates along Row 3 ...

**0**

votes

**1**answer

19 views

### Excel 2010 Formula of 3 variables with 3 results

I haven't been able to figure out how to combine these logic & date formulas in 1 cell.
My parameters would be:
A2 will always have a manually entered date in it
B2 could have one of three ...

**0**

votes

**1**answer

9 views

### I want a shortcut in Excel to cells I have Hyperlinked

I've built a Series of Cells which wnen concateneted = HyperLink to a remote server. Excel Wk Sheet 2010 (File name changes Daily with date function or Date User inputs)
On the same Sheet I want to ...

**-4**

votes

**0**answers

20 views

### Convert from XML into tabular representation [closed]

I have data in the format like:
<name>
University of Maryland Medical Center
</name>
<name>
Bruce D Greenwald, MD
</name>
<name>
University of Maryland
...

**0**

votes

**1**answer

21 views

### Embedded IF(OR(IF) statement

I have made a formula that basically looks for a string of text inside a cell and if it finds it puts it in another cell. I needed to check three cells so I did three separate formulas (because I'm ...

**2**

votes

**1**answer

34 views

### Replace cell references with values without F9 using macro

This is an Excel macro question. Given a series of formulas such as the following:
= A1 + A2
= B2 + B2
etc., ...
I would like to replace each of these cell references with the values without ...

**1**

vote

**1**answer

18 views

### How do I copy an excel sheet embedded in an outlook e-mail into an excel worksheet?

I was sent an e-mail with some data from an excel sheet embedded in it. I want to extract that data to another Excel spreadsheet. When I try to copy and paste it, it insists on pasting it as an object ...

**0**

votes

**0**answers

16 views

### Multiple series plots with data in same column

I have data in excel in the following format:
Series ID: 1100 1100 1105 1105 1105 1108 1207 1207
Days X: 23 45 10 25 85 43 27 35
Value Y: 0.23 0.31 0.14 0.21 0.34 0.32 0.27 0.29
...

**0**

votes

**1**answer

10 views

### Number format in excel

How to keep number format as is in excel if the number length is more than 15.
I see that any number above lenght 15 is getting converted to scientific format and finding difficult to compare using ...

**1**

vote

**1**answer

32 views

### Finding Unique Values in 3 Columns

I have 3 columns in excel. I want to find unique values in the columns A, B and C.
So:
by looking in column A, I want to find the unique values that are not in B or C.
by looking in column B, I ...

**2**

votes

**2**answers

22 views

### dragging to populate cells in Excel

I am aware that you can fill the cells in Excel as a series by dragging the square in the bottom right corner.
for example typing "1" in Cell "A1" and dragging the box down to "A10" will give you a ...

**0**

votes

**0**answers

11 views

### Autosum in excel 2010 STILL NOT WORKING?

I have read through many posts and still cannot get a column to autosum in excel 2010 - as it just returns the answer as zero. I have set the calculation to automatic (well it was already set that way ...

**0**

votes

**0**answers

12 views

### Creating an Excel Search Box which Unhides a Row

I've never done VBA before and I'm pretty sure that's the only way to achieve what I need. I have a master password list which I don't want people to see when they are looking at my computer. ...

**0**

votes

**1**answer

35 views

### Why doesn't formula work on COPIED data?

I'm using countif formulas across two and three columns in an Excel 2010 spreadsheet. The formulas work perfectly on data that is ENTERED but not on data that is COPIED into the spreadsheet, even ...

**0**

votes

**0**answers

14 views

### Can I write a Macro to export data from Web?

I need to write a macro that can import data from the web (salesforce.com). Is it possible to pull data from the web through a macro? The data I will pull from salesforce.com, is a monthly task. Can a ...

**1**

vote

**0**answers

28 views

### Excel: Keeping references/links when transposing

I have a worksheet in where I have table (let's call it the summary table) with references to a another table (among others) which is 2x40 (rows x columns). I would like to tranpose this into a 40x2 ...

**0**

votes

**1**answer

7 views

### Inspect document doesn't show anything, Excel 2010

In my Excel 2010 workbook I wen through File > Info > Check for Issues > Inspect document. But as it's shown following, it doesn't show anything. Why?
Thanks in advance.

**0**

votes

**0**answers

24 views

### VBA Code to update data in closed excel files within a folder by clicking a button

I have a code which works really well that updates values of closed excel files in a workbook. What I want to do is alter the code so I can create a on my worksheet where I can make y changes I ...

**0**

votes

**1**answer

21 views

### Copy the content of one cell, and insert within 2 characters, in the middle of a text content from another cell (Excel)

I am trying to batch copy the content of the cells in column A, and insert it within the "><" of the text in the column B. The result should look like the output in column C. Here is an example:
I ...

**0**

votes

**1**answer

34 views

### Trying to get an alert if three seperate cells do not match

Hi I am trying to put 2 formulas together in one cell
The first is to give a sum, i.e. : =(D3+F3+H3+J3)-(C3+E3+G3+I3)
The second is to check the resulting number above against a number total in 2 ...

**0**

votes

**0**answers

25 views

### Return value from table using Multi-dependent drop-down list

I am trying to obtain the value of a column header (or topmost row value for a specific column) based on the selection of properties from 2 drop-down lists.
...

**0**

votes

**1**answer

9 views

### Filtering out (blank) within a PivotFiled from all pivottables in a workbook that have the same pivotfields

I have a bunch (14) of pivottables in two worksheets (7 in each worksheet).
I have a refresh button on the sheet that refreshes all pivottables using the following code:
Sub Refresh_Pivots()
Dim pt ...

**2**

votes

**0**answers

50 views

### IE9 not prompting to save downloaded CSV file, opens in Excel

I am accessing a website that generates CSV files when I click a "download" link. Instead of prompting to "save or open", IE 9 is going right ahead and trying to open the returned file in Excel. Since ...

**0**

votes

**1**answer

21 views

### Excel “if” formula [duplicate]

I have an "if" formula that I need to duplicate for many columns, preferably without typing each if statement. Formula is =if(k5>j5,0,j5-k5) I have columns j through cy to include in the formula ...

**0**

votes

**1**answer

11 views

### Graphing only data from certain dates

I have a database that is filled in by multiple people at different times - I would like to create a graph that shows a time series analysis of only the last quarter's data. I know how to set up a ...

**-1**

votes

**1**answer

16 views

### Excel searching column and copying the cell next to it

i need to find the value from column C in the row B, and copy the value from found result in column D. If it's possible with formula and to copy formula to all cells in column D ? without VB?
Thanks ...

**0**

votes

**2**answers

47 views

### Excel 2010 Conditional Formatting for a range based on “Less Than” and “OR”

How do I use conditional formatting on a range of values such that every third cell should be filled with a particular color if the value entered in that cell is lower than values in any of the three ...

**-2**

votes

**2**answers

30 views

### MS EXCEL 2010 formula

I have 2 columns in excel, each column includes a date in the following format: mm/dd/yyyy.
One is a start date, the other is an end date.
Sample data: March 26, 2013 | February 28, 2014
Can ...

**0**

votes

**1**answer

9 views

### Cell to relate to information depending on infrmation in another cell

I hope you can understand what I mean. I have tried to draw below to help explain.
I need column d to have the information in column a1 and column h to have the information in a2- Keeping it in the ...

**0**

votes

**1**answer

24 views

### When Excel files can be opened in browser?

In open dialog box (of an Excel 2010 file) in path File > open, there is a drop-down list for Open button. One of them is, open in browser. When Excel files can be opened in browser (Web browser, ...