The 2010 version of Microsoft's spreadsheet application.

**1**

vote

**1**answer

73 views

### Split a Data column into automatic groups based on value ranges

I have a column that contains the final output data that I am interested in processing, the data in this column gives results that fall into groups that are very close in value. Once I sort them in ...

**1**

vote

**2**answers

97 views

### Formula to conditionally format a cell if the cell value (text) is not in row above

I need a formula to format a cell if the value of the cell is not in the row above.
I have to compare 100 rows of 10 columns sorted by date with the column above it.
Column A has the date and ...

**-1**

votes

**1**answer

25 views

### Which formula should I use to place a user ID in one column based on a name in another column? [closed]

Edited to reformat: I have 530 rows of employees in a spreadsheet, each has their manager listed in column H. There are 15 managers. In Column I, I need to assign an auditor to review each employee. ...

**0**

votes

**1**answer

62 views

### Excel Conditional Formatting: 3 color scale scoring fuzzy matched data for Windows [duplicate]

This question is posted as a spinoff from here - the post cited is about Mac where as this is about Windows:
Conditional Formatting: 3 color scale showing text relevance in Excel for Mac
Is ...

**-1**

votes

**1**answer

37 views

### How to split up above single cell Address value into multiple cell value through macro

How to split up the below single cell value into multiple cell value through macro ?
So, this...
A1 = MISS FirstName LastName***95*SPECIAL ROAD**LONDON SW92**SW929AB
...should split as below,
B1 ...

**0**

votes

**3**answers

161 views

### Conditional Formatting: 3 color scale showing text relevance in Excel for Mac

Is there a way to use conditional formatting in the following manner in Excel? (For those who are curious, I am using Excel 2010 for Mac)
I want Cell B2 to be green when A2 says "John likes green ...

**0**

votes

**1**answer

100 views

### Excel formula to sum all entries in a row if value of adjacent cell is equal to third cell [duplicate]

I need to build a formula that will sum the numbers in a series of cells only if the value of an adjacent cell is equal to the value of a third cell.
The latter two values are text.
In plain ...

**1**

vote

**2**answers

105 views

### excel 2010 - highlight cells used in any formula

I will need to sum long column of values dividing them to some groups. And I do not want to miss some row. So I need to highlight all cells that I have already used in some formula (e.g.=D1+D2).
...

**0**

votes

**2**answers

89 views

### Split single column data into multiple columns based on leap year in Excel 2013

I have about 100 files of MS Excel which consist of weather data.
I need the data on yearly basis but the file has a single column with data of about 140 years and manually copy-paste is very time ...

**0**

votes

**1**answer

31 views

### Microsoft excel 2010- How to have 2 sheets printed on one page in landscape mode

I have an excel worksheet which has nearly 200 columns but only 15 rows. Using page break I managed to have the whole printing area in two PAGES.
Now, I need to have both these PAGES on one ...

**0**

votes

**0**answers

9 views

### Excel 2010 Y-Axis Labels between Ticks

Is there a way to arrange the y-axis labels in between the ticks as opposed to at the same level?

**0**

votes

**1**answer

57 views

### SUMIF with multiple match criteria in Excel

I'm trying to create a formula so that if in cell E2 it says "Market", "Limit", or "Stop" it adds the numbers in cells L2 and M2.
=SUMIF(E2, "Market" "Limit" "Stop", L2+M2)
These expressions are ...

**0**

votes

**0**answers

26 views

### Formula in partially visible merged cell not updating

That was a strange behaviour I encountered. Formulae within merged cells in excel which are also partially visible do not update even if automatic update of formula is enabled or F9 is pressed ...

**2**

votes

**0**answers

53 views

### Inserting Excel file as an image in email using Outlook 2010

Yesterday at work, I was sent an email from a co-worker containing an embedded Excel 2010 object. I have Outlook 2010, as does the sender. Instead of being able to work in the Excel object or make ...

**0**

votes

**0**answers

10 views

### Updating advanced table filtering when criteria value entered

I have a table of data in Microsoft 2010. I am referencing this table in another sheet using =MY_TABLE_NAME and =MY_TABLE_NAME[#Header]. I don't think the fact that I am working on a reference of this ...

**0**

votes

**0**answers

15 views

### Offset referenced table in excel 2010 [duplicate]

I have a table of data in excel 2010. What I want to do is show a copy of this table in another sheet, only with its values "shifted down" by a number of rows. I can reference the table in another ...

**0**

votes

**2**answers

63 views

### Nneed to calculate average of NON sequential multiple cells & I want to exclude values = 0 or Empty Cell with AVERAGEIF

Nneed to calculate average of NON sequential multiple cells and I want to exclude values = 0 or Empty Cell with AVERAGEIFS.
There is a mistake in my formula but I can't find a way to have it since ...

**-3**

votes

**1**answer

48 views

### Is there a way to disable jumping on cell border double click in MS Excel? [closed]

I'm going crazy over the jumping "feature" when double clicking a cell border in Microsoft Excel. Is there a way to disable it?

**0**

votes

**1**answer

66 views

### Cannot change column width or add separate data labels in date specific bar chart

I have three bar charts of prices, with the x-axis set to the corresponding dates of those prices were received.
I need to show data labels from a separate column. I've tried the trick of adding a ...

**0**

votes

**1**answer

66 views

### VBA Code De-bugging in 2010 excel

Looking for some help in debugging some old VBA/Macro code to work in the newer version of MS Excel 2010. The macro in question is the "Material Rollup" function.
The purpose of the macro is after ...

**0**

votes

**1**answer

101 views

### Make Excel open some hyperlinks with non-default browser

A bunch of our network/server/storage hardware uses web interfaces for their administrative portals. I'm currently using an Excel 2010 worksheet to keep track of each device. I have one column set ...

**-2**

votes

**3**answers

59 views

### How to decrease the number of sheets in a workbook [closed]

In a new Microsoft Excel workbook (2010) I have three sheets by default. Suppose that I suddenly press the Insert worksheet button next to the Sheet3, so the forth sheet will become added to the list ...

**0**

votes

**0**answers

19 views

### Excel scatter plot with labels [duplicate]

I need to make an excel scatter plot.
Col A = Names
Col B = X axis
Col C = Y Axis
Doing a scatterplot on B,C makes the right chart.
However, how do I add little labels to each point with the ...

**1**

vote

**2**answers

31 views

### How do I find matching data in Excel?

I am trying to find some files listed in a big Excel workbook.
On Sheet 1 I have the list of all the files with full path.
C:\A\B\01.xlsx
C:\A\C\02.xls
C:\A\D\03.zip
C:\A\E\04.jpg
...

**1**

vote

**1**answer

28 views

### VBA change Script on multiple tables

Via this forum I found a way to refresh autofilters in a table automatically after the data in a excel worksheet has changed, using this VBA script:
Private Sub Worksheet_Change(ByVal Target As ...

**0**

votes

**1**answer

20 views

### Formula that looks at value in a cell and depending on what the value is

I'm using Excel 2010
I have a number in cell A1.
In Cell B1 i need a formula that says if the number in cell A1 is 25 then put 'account1', if the number in cell A1 is 58 then put 'account2', if the ...

**1**

vote

**1**answer

61 views

### Excel - Change cell colour based on a date in the comment or mixed in with text

I am using excel 2010 and I am trying to set up a rule that will change the colour of a cell based on a date within that cell.
For example the cell may contain Site meeting - 11.05.14
I would like ...

**0**

votes

**0**answers

25 views

### How to plot excel chart with multiple series from single data source

How do I plot the following multiple series information on a single chart:
DateTime SeriesName Duration
2014-05-02_10:21:21 X 2013.006
2014-05-02_10:21:22 Y ...

**0**

votes

**3**answers

52 views

### Reformat data through macro excel 2010?

I am trying to create a macro that allows me to change the data I received from a client into data I can import into a system. The data I receive is in the format:
How Can I do this through VBA ...

**1**

vote

**3**answers

130 views

### How to get excel to auto-outline hierarchy into groups?

So I have a bunch of data in an excel spreadsheet that looks something like this:
Level Hierarchy Name
0 1 Sam
1 1.1 Bill
2 1.1.1 George
...

**1**

vote

**2**answers

127 views

### How to get charts to automatically update with new data added?

If I were to have data in excel just like the table below, and then make line charts with that data. All is well and good until I have to come back around and add rounds 11, 12, and 13 to the data. ...

**0**

votes

**1**answer

24 views

### Excel 2010 Countif Formula

I'm trying to make a spreadsheet to display stock orders. I am including both executed and unexecuted orders, but I'm trying to display how many orders did or did not execute using Countif. My orders ...

**1**

vote

**1**answer

81 views

### TEXT() function not padding as expected in Excel 2010

I have an Excel worksheet that has three pages:
"Eingaben" / Input - the user types in some data
"Export" - the data is formatted and padded for PRN file Export
"Konstante" - contains some constant ...

**0**

votes

**1**answer

35 views

### Matching grades to names in separate sheets

I'm having some trouble with an excel formula. What I have in sheet A is a list of student names in (Fname LName) format, and then I have the same list of students in a separate sheet along with exam ...

**0**

votes

**1**answer

67 views

### Excel formula for tracking tasks and workload on two tabs

I created a spreadsheet at work to track all of the classes taught for us during the year. It helps us with scheduling and it helps us plan our budget for part time instructor payments. We have full ...

**1**

vote

**1**answer

37 views

### Data Validation arrow hidden from freeze panes?

I've been searching with no luck about my issue of the data validation drop-down arrow being hidden by freeze panes.
I have read multiple forum posts about Excel 97 having this as a bug, but fixed in ...

**1**

vote

**2**answers

36 views

### Excel Spreadsheets vs Dual Monitor [duplicate]

I am working with two separate spreadsheets and i have dual monitors. I'm using MS Office 2010. How can I get one SS to open on the primary monitor and the second SS to display on the secondary ...

**1**

vote

**3**answers

64 views

### Can I calculate a date using a date plus 53 days, minus any Sundays

Is there a formula tha I can place in Cell L3 that results in a date by comparing the date in cell E7, adding 53 total days to that date, excluding any Sundays within that period. The resulting date ...

**0**

votes

**0**answers

31 views

### Excel 2010 has recently started to divide my numbers by 100

If I type in 100 it is changed to 1. this happens when the cell is formatted as General, as well as when it is formatted as a number. Have I accidentally changed a setting somewhere?

**2**

votes

**1**answer

54 views

### I want to cross reference postcodes from two sheets and record the amount of matchs

I’ve recently started working for a charity helping with their IT. I’m trying to update one of their spread sheets (Excel 2010).
I have 2 lists of postcodes, both lists are in separate columns in ...

**0**

votes

**2**answers

50 views

### Creating a formula that queries data in Column B based on a selection from Column A in Microsoft Excel

I am reasonably familiar with Excel formulas but I need to construct a more complex query and am not having much success at the moment.
I have simplified what I am trying to achieve for the purpose ...

**1**

vote

**1**answer

44 views

### Automatically sorting a range of cells after one cell within the range has been modified?

I have a number of named vertical ranges on a spreadsheet, containing lists of names. New names are usually manually added at the very end of each list. Obviously, this means that unless manually ...

**0**

votes

**2**answers

39 views

### Excel Count number of cells based on three dependent selects [duplicate]

I am looking to count the number of cells based on three dependent select statements. each select corresponds to a column.
For example,
Select nth-Day (Column A)
Select Issue Type (Column B)
...

**1**

vote

**1**answer

71 views

### Why do I get HEX2BIN() error for long (but valid) strings?

In Excel 2010, the formula =hex2bin("111",10) gives the right answer of 0100010001. According to the function help, the arguments should be at most 40 bits (10 hex digits). However, the following ...

**1**

vote

**2**answers

86 views

### Excel SUM function for whole column?

How can I sum the whole column without freeze head?
I have a situation: I need to SUM each column, but the total rows in each column will keep changing. users are keep adding data in each columns, ...

**0**

votes

**4**answers

17 views

### How to refer to cells in other sheets

I have a workbook contains several sheets. And i'm trying to use cell value that present in other sheet . How do i refer or use cell value in other sheet.

**-4**

votes

**2**answers

85 views

### Custom Data Validation in Excel 2010 [closed]

I'm trying to make error messages appear when someone tries to enter the wrong data type in a certain cell with data validation in Excel 2010. Is there a feature or some sort of formula I can use?
...

**0**

votes

**1**answer

89 views

### Excel date time find max / min and max min timespan

I have data time data in excel in the format "04/18/2014 17:09:09". I would like to use MAX and MIN on a range of such dates to get max, min and time span between min-max.
I tried using custom format ...

**0**

votes

**1**answer

41 views

### Excel formatting not working for some cells when trying to do center alignment

I have an excel file that has been exported from a SQL Server Reporting Services report. The cells in the first column are a list of store numbers and should all be center aligned but for some reason ...

**-1**

votes

**1**answer

48 views

### how to copy data from on cell to diferrent cell using command button

for example the first thing i put in cell b1 has "='Ex-post'!C172"which has value "1" and c1 has "=OFFSET('Ex-post'!$B$4,MATCH($H$1,'Ex-post'!$B$5:$B$542, 0),4)" in which the value is 2300 and i want ...