The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

-2
votes
0answers
31 views

Excel Sort multiple rows at once

How do I sort all the cells of each row in a worksheet? I have 3 columns: Option 1 > Option 2 & Option 3; Not all rows (60+) are sorted A, B, C I can sort each row but due to the number of ...
1
vote
1answer
25 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
22 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
42 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
3answers
35 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
47 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
1answer
18 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
39 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
41 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 ...
1
vote
1answer
60 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 ...
3
votes
1answer
67 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
14 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
78 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
17 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
23 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
vote
1answer
66 views

Excel convert 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
49 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
129 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
26 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
50 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
18 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
42 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
35 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
24 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
61 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
22 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
24 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
48 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
36 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
36 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 ...
1
vote
1answer
62 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 ...
0
votes
2answers
39 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 ...
2
votes
1answer
46 views

Excel 2010: Create named range without a sheet reference in the formula

In Name Manager I created a named range with this reference: =COUNTIF($A$4:A4, Tbl_InventoryMain[Barcode]) Excel automatically inserts the current sheet name prior to the $A$4:A4. I need this to ...
0
votes
2answers
41 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
19 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
44 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
15 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
20 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
37 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
12 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
15 views

Counting in Excel until a special integer comes up [closed]

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
70 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
28 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
56 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 ...
1
vote
1answer
61 views

VBA; Fill down last line of an array to match the length of an adjacent column

So for an early stab at VBA I'm writing a macro: I'm pasting in a set of data that increases in numbers of rows each month; data is well organised with no blank values/columns I have formulae in ...
0
votes
1answer
30 views

I am trying to reference a merged cell on one worksheet and have it copy over into the next sheet

So basically my workbook has four individual sheets. I want to reference the text in the sheet labeled Overall Assessment and it is E81:L86 (merged cells). I want to put it in my sheet labeled Summary ...
0
votes
0answers
31 views

How to convert a range to a comma delimited list of the range's values in Excel

I have a column in Excel that has page numbers listed in it. These can be a single number, eg., page 1. Or a list of numbers separated by commas, eg., pages 1,5,8. Or it can be a range, eg., pages ...
0
votes
1answer
99 views

How do you format numbers in Excel for Indian Currency (Rupees)?

Currently the Excel default formatting is: 1,000,000 500,000 How do you format the number to use the comma separator (,) like this 10,00,00,00 50,00,00 This is is how Indian Currency (Rupees) ...
-1
votes
1answer
46 views

Counting a percent of a number [ as time in minutes ]

I am trying to create a excel calculator, that will count time needed to complete a certain case. This is quite basic match but I might be wrong in my attempt. Lets start with this. We have a fixed ...
0
votes
1answer
9 views

Excel hiding columns based on certain crtieria

What if i have a cell that is a drop down list and based on the choice of this list ex contains the word "Marketing", hide some columns? Thank you in advance