The 2011 version of Microsoft's spreadsheet application for Mac.

**0**

votes

**0**answers

27 views

### Why doesn't Excel auto-adjust formula when a row is moved?

I have a simple spreadsheet with just one formula, which auto-increments the number in the first column, going from cell A6 down. So the value in A6 is hard-coded 1, then A7 contains the formula ...

**0**

votes

**1**answer

11 views

### Can Powerpoint update two Excel objects that are from the same Excel file?

I've been reading through the forums and haven't come across a definite answer for my query. I have a PPT presentation that includes 2 different worksheets from the same Excel file, pasted as Excel ...

**1**

vote

**1**answer

44 views

### How can I use a macro to group and average the values in an Excel column?

I'm new here and I've been struggling with macro writing. I was wondering if anyone could help me out with making/explaining a macro that could be used in my data set.
I have an Excel file that looks ...

**0**

votes

**0**answers

31 views

### How do I setup Excel to chart a budget with multiple currencies and categories?

I am using MacOS X and Excel for Office Mac 2011 version 14.2.4.
I have three separate currencies: Chinese yuan (¥), US dollars ($), Thai baht (฿). Each currency has its own table with the following ...

**0**

votes

**0**answers

37 views

### Separating concatenated name, address, and phone number

I imported company names, addresses, and phone numbers into a cell. Due to the different number of characters, I cannot separate the fields of information with text to columns; for example:
ABC ...

**0**

votes

**1**answer

16 views

### Getting the name of a named cell in MS Excel 2011

I am using a formula in Excel, which involves cell names.
The formula is
=MIN(name1,name2,name3)
name1 is the smallest, but it shows name1's value. I want it to show the text "Name1". How do I do ...

**2**

votes

**1**answer

95 views

### Replace method generates application-defined or object-defined error in Excel for Mac

I'm having trouble with this on the latest version of Excel for Mac.
Here's the macro:
Sub Run()
'
' Run Macro
'
'
Sheets("Data").Select
Cells.Select
Range("BK1").Activate
...

**0**

votes

**1**answer

15 views

### Sorting using Subtotals and Data Subtotals

In sorting using Subtotals via Data Subtotals, is there a way I can get all lines of info to come down NOT just the ones I'm totaling?
The only way I have remedied it is copying it down from the Page ...

**1**

vote

**1**answer

21 views

### How do I use Excel 2011 Personal Macro Workbook?

I realized I asked about excel 2010, but that only covers Windows OS. How can I use the Personal Macro Workbook in Excel 2011 on OSX?

**0**

votes

**0**answers

35 views

### sum rows and columns depending on two values

I got the following table in Excel (Microsoft Excel 2011 for Mac).
It is basically for controlling issues. It shows a number of persons (employees) that are assigned to specific work-packages that ...

**1**

vote

**1**answer

111 views

### How to close an excel file using terminal or python

I am using XlsxWriter to create an Excel file using a Python script.
When I re-run the script to update the file with new information, which I need to do often, I have to manually close the Excel ...

**0**

votes

**0**answers

75 views

### OS X 10.9.5 and Microsoft Office 2011 corrupt table formatting troubleshoot

My task was to take three columns of data – "item #", "description", and "quick ship" (each column contains lots and lots of data...) from Excel and move that into information into a table in Word so ...

**1**

vote

**0**answers

87 views

### EXCEL 2011 - Inventory with Matrix and Vlookup

I am creating an inventory matrix, which has on the first column a list of all the items in the inventory, and on the first row a list of the dates for when the inventory gets renewed. Basically, not ...

**1**

vote

**2**answers

41 views

### How do I use IF in MS Excel-Mac 2011 for 3 variables?

When I type A, B or 0 in one cell, I want to see in other two cells (separately) to show
2,1 if I type A
1,2 if I type B
0,0 if I type 0
Can someone help me how to do this?
I currently only have ...

**1**

vote

**1**answer

56 views

### How do I match cells in one worksheet to another and print a result?

Not new to excel, but new to formulas. I have to say this is killing me.
So what I am trying to do is take strings in one column, check if any of them are in another column of a separate worksheet, ...

**0**

votes

**0**answers

33 views

### Regroup rows based on a column value

I have the following data:
Last Name | First Name | Division
Doe | Jane | A
Doe | John | B
Does | Michael | B
So, every user is assigned to a group. Now what I would ...

**0**

votes

**1**answer

37 views

### Error in importing the numbers in scientific notation

I am importing(copy-paste) values into Excel from R Console which are in scientific notation (1.920943e-10, 7.580894e-05). Excel is not treating them as numbers instead text. How to resolve this ?
...

**0**

votes

**0**answers

43 views

### All Data Option Filter Validation

I am creating a dashboard that has five inputs that filters my data by the custom data validation combination. My dashboard updates correctly based on the custom combinations, but I am unable to add a ...

**0**

votes

**0**answers

77 views

### Update Table based on Range start value and end value

I have a set of data that uses a primary key of month of the year by numerical value, e.x. Month 1, Month 3. I am trying to update my table and its values from the raw data set based on a user entered ...

**1**

vote

**1**answer

24 views

### Get rid of PivotTable help on Excel for Mac

Every time I start up Excel For Mac 2011 and build a Pivot Table, Excel feels it's needed to remind me in a modal what Pivot Tables do ("PivotTables summarize data and reveal patterns and trends").
...

**0**

votes

**1**answer

20 views

### I want to take two columns of cells (not the whole columns) and copy them and sort them into different cells

My Table:
I want to copy the names and scores from the desirability score area into the "Most to least desired rooms area but place them in descending order. How do I do this? Edit: I want the ...

**1**

vote

**1**answer

1k views

### How to make a concentric pie chart in Excel?

I'd like to make a chart (preferably on its own sheet) that is a combination of a regular pie and a doughnut. The regular pie sits in the middle and the doughnut surrounds it.
I have seen those ...

**1**

vote

**1**answer

536 views

### Remove duplicate rows, and keep newest row based on date column

I have a huge list of data in excel (250.000+ rows) in the following format:
Number Value1 Date Value2
40325 1 21/01/11 18.10 2
65485 3 22/01/11 16.47 2
40325 9 ...

**0**

votes

**2**answers

98 views

### Is there a way in Excel to have a formula stretch its row extent to include adjacent inserted rows?

In Microsoft Excel 2011 for Mac OS X, I have several columns of numerical figures and a final row at the bottom that shows a maximum value for each column. My data set is ordered, such that most ...

**1**

vote

**1**answer

38 views

### How to create stacked chart

I go nuts at Excel. So here's my problem: I have a table where the Y-values are projects that we are working on in that year on the x-values are project related properties. On of those properties is ...

**0**

votes

**1**answer

940 views

### Excel 2011 for Mac/ Pivot table / tabular layout how to “fill down?”

I've got a great pivot table in tabular layout, but how do I "fill down" values in column A?
A10 should also read "Alpaha Police"
A15:A18 should also read "Atkinson Co Sheriff"

**1**

vote

**2**answers

87 views

### How to recover the overridden file on my MacBook Pro?

I have Windows excel on my MacBook Pro. I accidentally saved one Excel file overtop another excel file. Is there anyway to recover the earlier file (the one I just saved over)?

**2**

votes

**1**answer

129 views

### How to disable moving down on Enter key in Excel 2011 for Mac?

When entering data in a cell and pressing enter, the cursor moves down one step. How do I disable this?

**0**

votes

**0**answers

62 views

### Group dates as MM-YYYY on Pivot Table

I'm using Excel 2011 for Mac. I have a sheet with dates that I have grouped into a Pivot table.
The data spans across months of 2013 and 2014. I want to chart the trends over a month of a year, but ...

**0**

votes

**0**answers

110 views

### Reconciling Inventory Spreadsheet with Updated Sheet

I have a workbook where one sheet (A) is an old inventory list. On another sheet (B) in the workbook, someone copied several of the columns from sheet A. Then they went around and updated the ...

**2**

votes

**0**answers

98 views

### Changing language of functions in Excel 2011 for Mac

I use Office 2011 for mac, with Norwegian language. I don't mind menus and such being Norwegian, but for some reason, the names of functions have been translated from English to Norwegian, and that is ...

**0**

votes

**1**answer

147 views

### How to sort sheet by groups of three rows without changing internal arrangement of groups

I created an Excel file showing a list of golfers and their scores on 18 holes.
I want to sort by the Net Total, while preserving the rest of the formatting. When I try to sort the usual way, I ...

**0**

votes

**1**answer

290 views

### Excel 2011 - make a cell display another cells value if its adjacent cell is equal to a 4th cell

For example, if the value in I31 equals a value in column A (lets say A5) I want to display B5 (so same row) in a new cell (say I32). How can I do this?

**1**

vote

**1**answer

1k views

### Find first number greater than x and return another value in that row

I have created an investment spreadsheet. In one column I have the ending balance each year. In another column I have the years.
A B
2000 500K
2001 450K
2003 1.2M
2004 1.5M
How can I display ...

**2**

votes

**2**answers

101 views

### Average of Count of Cells for Day of Week in MS Excel

I'm looking to do an average of rows per week day. And so far, I haven't been able to figure it out. I'm using Excel 2011 for Mac.
Here's a sample screenshot:
Here's the screenshot of the ...

**0**

votes

**1**answer

91 views

### In Excel 2011 the “date” function doesn't show the 4 digit year - can anyone explain why this happens

When I use the following, I get:
MsgBox(date) - 01/04/
?date in the immediate window, the same - 01/04/
?year(date) - 2015
?now - 01/04/ 07:18:19
I'm confused. My Macbook Pro is set to English and ...

**0**

votes

**0**answers

86 views

### Pairing Numbers in Excel

I have a list of congressman (and some of them repeat) and I’m looking for something that will fill in the matching distract number in the corresponding cell, so I can eliminate the risk of the human ...

**0**

votes

**3**answers

972 views

### Display excel grid lines in front of a chart?

I have an area chart in Excel for Mac 2011 that I'd like to display grid lines in front of. Is there a way to do this? I know I could make the chart semi-transparent and show the grid lines through, ...

**1**

vote

**0**answers

70 views

### Select all cells with certain fill color

Is it somehow possible to select all cells with a certain fill color in Excel for Mac?
On a PC it's possible through find/replace but that option isn't there in Excel 2011 for Mac.

**1**

vote

**2**answers

33 views

### How to replicate efficient pasting from delimited text behavior in Excel?

Sometimes when I paste space delimited values from a text file into excel it automatically separates them into the correct columns. Other times I have to use the "Text to Columns" tool. I haven't ...

**-1**

votes

**1**answer

84 views

### Excel 2011 for Mac - formula property dropdown list missing

Basically missing the dropdown properties list on Excel 2011 for Mac. How do I enable/show it?
I've already:
ticked the "show function ScreenTips option" under Excel Preferences > View > ...

**0**

votes

**1**answer

52 views

### How to add up Column B based on whether Column A is a duplicate value?

I have two columns, one with names and the other filled with '1'. Column A has many duplicates in it - this is intended - what I need is a formula to add the 1s in Column B if the corresponding values ...

**1**

vote

**2**answers

65 views

### Is there a way to reference an external excel file depending on a cell's value?

I am trying to make a template for a document that will be updated every week, and I was wondering if there was a way to insert some values automatically depending on the value of a cell.
To explain, ...

**0**

votes

**1**answer

7k views

### How do you plot time on the X axis in excel?

I need to plot the decay of my phone's battery against time over night. My starting time is 23:17:47 and my ending one is 07:05:49. I don't have any issue in changing the time format in the current ...

**1**

vote

**3**answers

56 views

### Excel, IFs and Dates

I have a household budget, it is split into fixed and variable expenses. I would like to include the fixed expenses only during/after the month they are incurred.
Not a problem using the following ...

**-1**

votes

**2**answers

40 views

### In MS Excel, what function should I use?

I have an original table:
Class 1 Class 2 Class 3 Class 4 Class 5
Ram Shyam Madhu Peter Xavier
Micheal Cynthia Helen Rama Hema
Peters Veronica Amy Sydney ...

**0**

votes

**0**answers

37 views

### Can Excel automatically create an x-axis range?

I'm doing a basic financial analysis with Excel. The gist of it is I have an input parameter (discount rate) plus a bunch of static data that gets fed into the =NPV(rate, x1...x_i) function. I would ...

**-1**

votes

**2**answers

46 views

### Trying to use SEARCH function in Excel

I'm trying to do something on Excel which is a little bit over my head and was wondering if anyone out there can help:
I'm trying to search through a table (specifically one column) for several ...

**0**

votes

**1**answer

124 views

### How to correct floating point round-off error in Microsoft Excel for Macintosh 2011?

I'm using Microsoft Excel for Macintosh 2011 and have a spreadsheet of start and stop time spent on activities with some time differences between start and stop times that are converted into total ...

**0**

votes

**1**answer

95 views

### Excel 2011 on OSX always opens on same monitor

I am running OSX and I have 3 monitors. In Mission Control, I have all 3 monitors to be their own Space. So each monitor has a toolbar at the top. Only one monitor has my dock on it (obviously). I ...