The 2010 version of Microsoft's spreadsheet application.

**-2**

votes

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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