The 2010 version of Microsoft's spreadsheet application.

**2**

votes

**0**answers

6 views

### Hyperlinks on Excel 2010 - copying from orignal list to search index list

I've created a search index (using forumlas) from a list of products that have hyperlinks attached (created with Insert Hyperlink). The search index is created without the hyperlinks however.
Both ...

**1**

vote

**0**answers

5 views

### Linear date axis in pivot tables

How do I format a PivotChart so that the horizontal axis is displayed in linear time?
See the PivotTable below as well as the source data (both excerpts).
If it is in fact not possible to ...

**-1**

votes

**0**answers

10 views

### Excel time and date query

I have an excel sheet where in column A has dates and column B has time, i tried IF function but in vain.
I want if the column A has same date in row then column B should not have the same time in ...

**-1**

votes

**1**answer

33 views

### Formula issue Microsoft Excel

I need help urgently for a work problem.
So basically, the summation of opening stock and production give total stock.
While closing stock is ((opening stock+production)-sale)) and stock cover is ...

**-1**

votes

**0**answers

24 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 ...

**0**

votes

**0**answers

19 views

### Save worksheet as a seperate file [on hold]

I would like to know if there is an option in Excel 2010 where you can save a specific worksheet in an Excel file into another file, without having to open the destination file. Thus without having to ...

**1**

vote

**1**answer

20 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

15 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

27 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

**2**answers

29 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

34 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

**0**answers

30 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

**1**answer

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

**1**answer

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

**0**answers

17 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

**0**answers

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

**1**answer

37 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

**0**answers

19 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

**1**answer

40 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

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

**1**answer

36 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

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

**0**answers

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

**0**answers

36 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

**1**answer

41 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

74 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

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

45 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

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

**1**answer

17 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

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

**2**answers

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

**1**answer

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 ...

**1**

vote

**1**answer

44 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 ...

**-1**

votes

**2**answers

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

**0**answers

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

**2**answers

34 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

**2**answers

36 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

29 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

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

**1**answer

31 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

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

**1**answer

17 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

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

**0**answers

8 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 ...