The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
10 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
0answers
22 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
1answer
45 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
1answer
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
0answers
40 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
2answers
18 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
1answer
20 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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
23 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
1answer
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
0answers
15 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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
0answers
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
0answers
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
1answer
36 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
0answers
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
0answers
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
1answer
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
0answers
25 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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
53 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
1answer
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
1answer
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
1answer
17 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
2answers
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
2answers
31 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
1answer
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
1answer
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, ...