The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

1
vote
1answer
17 views

After pasting data, how do you navigate cell contents with keyboard arrow keys in MS Excel?

Using MS Excel 2010 I can copy ASCII plain text from a separate text document and paste the text into a cell (I first enter cell edit mode before pasting with Ctrl+V or Shift+Ins). After pasting, ...
0
votes
1answer
14 views

How to transpose two cells data at a time from 2 cells to multiple rows

I have Excel data in the below format: Excel Std Row: A B C D E F G H I J 1st Row Data: 1 1 2 2 4 4 5 5 6 6 Now I need output as below: A B ...
1
vote
1answer
26 views

Copying cells to another sheet and inserting rows for the copied cells

I am trying to create a sub that copies information from one form (which has four cells) to another sheet. When it copies the information it also creates a new row. Each form has a maximum of ten ...
1
vote
2answers
28 views

Need to count the amount of times -1 appears above a certain cell

I have the following Excel Spreadsheet - Hy Newcastle 042216 -1 Not Matched 1000 Hy Newcastle 042216 6461735 Khanyile;Florence Success 1000 Hy Newcastle ...
0
votes
1answer
31 views

How to use INDIRECT with a SUMIF formula for a date range

I'm trying to get a SUMIFS formula to dynamically work with multiple tabs in an excel workbook. I have numerous tabs in this workbook, each that contains client data I update daily. In the example ...
-2
votes
0answers
26 views

How to track changes in Excel 2010 like Word?

I have a workbook with a tab for each of 12 product lines. Each month the execs for that line make changes to their worksheet(s), depending on new products, different financials, comments or notes, ...
2
votes
1answer
16 views

Excel grab address to start y values series

I have the string $F$50 created by the CONCATENATE function. I also have a scatter plot where the selected data is like this: =SERIES(,data!$A$4:$A$404,data!$F$4:$F$404,1) I want to replace $F$4 in ...
1
vote
1answer
24 views

Is there a way to configure Currency or Accounting dropdown in Number Ribbon?

Is there any way to configure the list of currencies showed in the Ribbon (see screen shot)? My most used currency, $, is not available in the default list and I can't found out how to modify this ...
0
votes
0answers
15 views

Excel 2010 VBA Freezing panes when scrolling down (multiple headers)

I have a large spreadsheet with multiple headers in different rows, and I want to be able to freeze different headers while scrolling down and freeze pane. For example, A B ...
0
votes
0answers
18 views

Copy Top 10 from one workbook to other [on hold]

I have excel workbook as "Report June 21 - June 27" and each containing "ATT" sheet as first sheet. Report June 21 - June 27.xlsm I want to take the Top 10 in B, Q and R column by sorting Q5 by ...
1
vote
1answer
33 views

Excel: Write a 1 or 0 value if condition is met

Sorry if this has already been posted, but I just started today playing with Excel macros and I need a hand. I have a data column with values and I would like that if the conditions were met, the ...
-1
votes
0answers
17 views

excel 2010 VBA insert column headers [on hold]

I have a piece of VBA code (Excel 2010) that generates tables with 5 columns x 6 rows. There is an option to input the number of tables to be generated, as required e.g. 1 or 6 or 10 etc. basically ...
3
votes
1answer
39 views

Can this 5-attribute 2D risk map be built in excel?

So there is this risk map (or heat map otherwise) below (*): What is interesting is that in the a 2D image there the following attributes are mapped: Attribute -------- Drawing component 1. ...
0
votes
0answers
10 views

Using Hlookup to populate a worksheet from a data sheet

I am trying to develop a worksheet that requires a list of equipment based on an area header. I would like to be able to pull the separate lists based on this area header. Here is sample data I am ...
1
vote
1answer
27 views

Excel 2010 error message when opening .xlsm files

I'm trying to open a .xlsm file in Excel 2010 when I receive the error: "There was a problem sending the command to the program" Once Excel is open, I am able to open the file, but if Excel is ...
0
votes
0answers
15 views

Prevent my excel file from been opened in an older version of excel

As the title says, I would like to prevent my excel 2010 Pro Plus spreadsheet from been opened by someone using an older version of office. I created a spreadsheet that my colleagues and I update ...
0
votes
0answers
21 views

Is there a way of 'detaching' a column from the rest for the purposes resizing the cells in it?

Here's an example Excel spreadsheet. Basically what it is an chart for time organisation, and I use the left most column for storing some notes (back log items etc). Now I need to to keep the ...
-1
votes
0answers
29 views

Excel range to html? Excel 2010

Looking to take a range of A1:I26 on sheet "Desc" and convert it to html. That html then show in Cell H2 on sheet "-Listings-" The cells in range A1:I26 has a graph with formatting i want kept (I.E. ...
0
votes
1answer
40 views

Is there a way to exclude keywords in a VLOOKUP formula?

I have 3 sheets in Excel. In the 1st one there is a column with hotel names and another one with ID. I want to get that ID from the ID column on the 2nd sheet where I have the names as well. The ...
0
votes
2answers
67 views

How can I compare two columns and if match return a value?

How Can I compare the entries on TAB: SUMMARY SLS, column B with SUMMARY P&S, column B and bring back a "X" if a match is found in the cell with the formula? SUMMARY SLS and SUMMARY P&S are ...
0
votes
1answer
21 views

Find cell address for MAX+IF function based on category

I have a large set of data, which has been divided into 9 categories using numbers 1-9. The data is not sorted by category, but the categories are defined in a column as data. Using MAX+IF, I have a ...
4
votes
3answers
47 views

How do I force Excel to always type purple text?

I'm making changes to a large Excel worksheet, and every change I make needs to be in purple text. Right now, I'm typing the change and then clicking purple text. Is there a way to force Excel to ...
0
votes
0answers
10 views

Why does outlook 2010 contact avantlink.com during splash screen startup?

The "contacting ......" message takes forever and finally allows outlook to run. I blocked the site via host file and now it either tried to make contact and stops to allow outlook to run, or a second ...
1
vote
1answer
38 views

If statement that returns original function if false (similar to iferror, or substitute)

If I use IFERROR as opposed to IF(ISERROR I can save typing the condition twice. i.e. =IFERROR(Long lookup,"not found") is much preferable to =IF(ISERROR(long_lookup),"not found",long_lookup) ...
-1
votes
1answer
26 views

BOM comparison sheet

I have been working on Comparison sheet, where i need to compare Base BOM1 with other BOMS. I added formula & prepared the attached sheet & I am able to highlight the mismatch values. But i ...
0
votes
2answers
19 views

How to sum with two variables involving date range

I get raw data much similar to the example below that has thousands of rows. What I need to be able to do is sum the values in column C (Or column D) based on the value in column A within the date ...
0
votes
2answers
43 views

Populate missing entries from one sheet to another

I have two Sheets in Excel. For this example, Sheet 1 and Sheet 2. Sheet 1: 100 records with Name, Location, Gender Sheet 2: 100 records with Name, Location, Age The sources of the data are not ...
0
votes
0answers
19 views

Search for ID column in all worksheets and then search within those columns

I have multiple workbooks with multiple sheets on each. I am looking for a way to return the value under the column ID#, like to search all the sheets in the workbook. The header ID# might be in a ...
0
votes
1answer
16 views

Copy/paste changing date format in excel 2010

I want to copy/paste a spreadsheet that my employee has created into the main spreadsheet residing on my computer. When I do so, the date column in the employee spreadsheet changes to a random 6 ...
0
votes
2answers
45 views

Excel help - extract info from middle of cell

Is it possible to take the words 'each', 'Any 2 for', 'kg', etc... out of these cells and put them into another cell... leaving only the $x.xx price so it can be sorted. Examples for above are: 1) ...
0
votes
2answers
30 views

Compare 2 different columns in 2 different Excel Files

This is a bit different than the others. I'm trying to compare 2 different inventory sheets, comparing serial numbers of equipment from 2 different reports. I have File A which has 4 worksheets in ...
0
votes
1answer
32 views

Is there a way to update automatically a worksheet based on a link which provided a file for download

I have created a web app which allows the user to download a csv file just by copying the link into a browser. Afterwards the user can open this file with excel. Because the csv file might change ...
-3
votes
1answer
46 views

Calculate date difference and color a cell depending on the value with Excel [closed]

I am creating a spreadsheet where I will keep track of the number of days a particular equipment has been borrowed. So far I have the starting dates (when the equipment was borrowed). What I'm ...
1
vote
1answer
43 views

Excel macro to format cells based on value and group with blank rows below

I'm trying to create an excel macro to format some data that is exported from another program. Here is an example of the data layout: ID Code SubCodes 1 A1 1 1 ...
-2
votes
0answers
22 views

Multiple Function [closed]

I need a similarity function. But I need Column A, row 1 to be an assigned number (i.e. 11013) which is then spread among many worksheets where A2,A3, A4 usually show differing results dependent on ...
-1
votes
2answers
43 views

Combine data from multiple rows into single row [closed]

I've got a raw data dump of user profiles on a server. One column has the user and the other has the group. For each separate group a user belongs to, there is a separate row. I want to have all the ...
0
votes
0answers
10 views

hrs to be taken with vlookup and add the existing date with time [closed]

I was trying many of the formulas to check the total time taken. In sheet 1 I have a date and time ID date 456 6/15/15 23:00 123 6/15/15 2:00 and in sheet 2 I have got numbers ID taken 678 ...
0
votes
2answers
32 views

Make formula depend on key word entered in another cell

I would like to know how to get a set of cells to auto generate a specific date when another cell has been entered with one of four specific key words. (Key words: AFAM, AFCM, MSM, MSM/FW) Ex. If ...
0
votes
1answer
26 views

Excel 2010: Use name manager without a sheet reference in a formula

I insert this formula into name manager: =COUNTIF($A$4:A4, Tbl_InventoryMain[Barcode]) Excel automatically inserts the sheet name prior to the $A$4:A4. I need this to just stay $A$4:A4, in order ...
0
votes
2answers
28 views

VBA Ambiguous name detected error

I am trying to use VBA programming for Excel. What is happening is when I try to run this program I get this error and I do not under stand what it means?
1
vote
1answer
15 views

Excel - precise positioning for printing

I have some data created in Excel 2010. I planned to use Excel as printing software but I need to print over already printed paper with precisely designated places on these paper form (instead ...
1
vote
1answer
29 views

Excel - can you change the line colour of a Freeze panel divider?

I've been doing a stylistic overhaul of some daily checksheets we use for cross-checking data. The first three rows have been set as a Frozen pane so they remain at the top as you scroll, but ideally ...
0
votes
1answer
14 views

COUNTIF/COUNT Function help required to count the filtered data for the subsequent columns

I am using a normal COUNTIF Function to know the count of "Box 9" I have placed this in one cell "I12" and i am using the formula. I am filtering the data with the column J. 1) ...
0
votes
1answer
16 views

Excel 2010 Array (CSE) Formula: How to remove a part of contiguous (adjacent) range

I would really appreciate help on the following question: Is there a way to write a formula that removes a segment from a contiguous range? For example, say there is a formula ...
-1
votes
1answer
35 views

Excel formula to Show (1,0) for specific ranges

The problem I am having is I only want to look at Order number(Column A) if they have more than 4 value. When they have 4 values I want to only look at the last 4 values in that order. In column D I ...
0
votes
0answers
7 views

comparing columns where one column has merged cells

I have two columns with the same data and want to check that the order is the same - one column has the data in single cell and in other column the values are merged across 2 cells - any idea how i ...
0
votes
1answer
13 views

Counting in Excel until a special integer comes up [on hold]

I am trying to get column C to say what column D says (I have typed the value in column D). The problem I am having is that I can not find a way to tell Excel to stop counting when it comes across the ...
0
votes
2answers
41 views

(Excel) Plotting data series and a subset of that series on one chart

I have a data series associated with text labels. I'm trying to fit a line to the second half of my data. I read that in order to do so I have to make a second data series consisting of the subset of ...
0
votes
1answer
23 views

Search through an email to find and highlight text

I'm working with Excel trying to automate the sending of some emails. Right now, the code creates an email based on the cells next to the button clicked, forwards the email to the listed in a cell, ...
0
votes
1answer
40 views

How do I Reference all non-blank cells after row A6 for a Formula

I want to use the following formula: INDEX(A6:A94,MODE(MATCH(A6:A94,A6:A94,0))) Except the exact number of rows is ambiguous (imported using VBA). How can I reference all non-blank cells starting ...