The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

1
vote
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
3answers
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
1answer
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
2answers
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
2answers
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
3answers
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
0answers
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
3answers
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
3answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
3answers
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
0answers
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
1answer
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
2answers
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
1answer
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
2answers
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
1answer
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
2answers
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
4answers
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
2answers
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
1answer
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
1answer
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
1answer
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 ...