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

learn more… | top users | synonyms (1)

0
votes
1answer
26 views

Auto refresh Excel worksheet after changed by external application?

I have a question similar to this one but I'm just using an Excel file, no CSV involved: Open a .csv file in Excel and have it update whenever .csv file changes I have an Excel file that I ...
-1
votes
1answer
44 views

How to use non-contiguous range arguments in Excel's XIRR?

The XIRR requires range arguments. I would like to know how I can somehow use 'split' ranges which are in different locations. Perhaps the picture explains it better. What do I enter in F7, if I want ...
2
votes
0answers
14 views

Excel for Mac alters document names after saving

I have a 2012 non-Retina MacBook Pro with Excel 2011 for Mac version 14.6.3. Every time I save a document using the Save As command and save as a PDF document, Excel alters the name I entered as the ...
0
votes
0answers
19 views

How do I create a macro in Excel for Mac? [duplicate]

I have found this thread on this topic How to get the list of sheet names of ms-excel? But I have no idea how to create the macro people are talking about. I will be grateful for your help on how to ...
0
votes
2answers
21 views

How to find the number of rows that have date time fields between 5 and 6 PM

I have a phone log that I want to report some data off of. All of the solutions out there that I have looked up seem to assume I only have a time value and that they don't include an actual date. I ...
2
votes
1answer
42 views

Bitwise Operations Missing? (Excel for Mac 2011)

According to the relevant Microsoft Support page on the BITAND function, I should have access to it, as I am running Excel for Mac 2011 (with the latest updates installed): "APPLIES TO: Excel 2016, ...
0
votes
1answer
18 views

Uncrowding a scatter plot when most points lie near lower end of X-axis

Given an Excel scatter plot thus: where the bulk of the points lie at the lower end of the X-axis, how can the lower end be made to look less crowded (without removing data points), while ...
0
votes
0answers
33 views

Using SUMPRODUCT to total column range X if meets numerical criteria in range Y

I am seating people for an event. There are 16 tables (column E). People may come alone, with spouse and/or guests (total for each in column I). I want a way to get a table count as I work through ...
0
votes
0answers
18 views

Predefined chart styles in Excel available to other users?

I need to set up a MS Excel document with custom chart styles. As far as I understand the style of an existing, customised chart can be saved as a predefined chart style. I then need this style to be ...
1
vote
1answer
113 views

MINVERSE only returns a single number

For the life of me, I can not get the MINVERSE function on Excel 2011 on my Apple Macbook to work. I entered the function into a matrix. I type =MINVERSE(A1:C3), the location of my matrix to be ...
0
votes
1answer
30 views

Concatenating datas from different sheets

I have an Excel workbook with 2 sheets. Sheet #1 contains 2 columns, names and points. | A | B | |-----------|----| | John Doe | 65 | | Jolly Doe | 45 | | Hello Doe | 50 | Sheet #2 ...
0
votes
1answer
33 views

How to get the difference between 2 cells

I have an Excel file like below. The value in column C should be the difference between A and B (A is always longer, B is always A substring). If both values in A and B are same, C will be empty. ...
0
votes
1answer
40 views

Merge two sheets on two columns into a new sheet in Excel?

I'm using Excel 2011 on OSX. I have Sheet1 that looks like this: pupil_id date test_score 1 2015/10/01 98 2 2015/10/01 83 And I have Sheet2 that looks ...
0
votes
0answers
38 views

Group different values with same name field in Excel

I'm having troubles with the following document. Is there a way to group different values with the same name field?
0
votes
1answer
70 views

Excel formula disappears when saving as .xls

I have a long formula in one of my cells. It is: =IF(K11=1,MATCH(C66,valv1,-1),IF(K11=2,MATCH(C66,valv2,-1),IF(K11=3,MATCH(C66,valv3,-1),IF(K11=4,MATCH(C66,valv4,-1),IF(K11=5,MATCH(C66,valv5,-1),IF(...
1
vote
1answer
32 views

Can you autofill numbers going upward?

I know how to autofill numbers going downward. But I'm curious if you can autofill numbers going upward? I'm using Excel 2011 on MacOS X (El Capitan). It may sound counter-intuitive, but my boss ...
0
votes
2answers
92 views

Hide a Control Box in Excel

I have some radio buttons in Excel (2011 Mac), and they are grouped by a Group Box. I want to make the Group Box invisible. I searched on the internet and found that I could do that with VBA by ...
1
vote
0answers
61 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 =A6+...
0
votes
1answer
15 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
1answer
268 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
0answers
116 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
0answers
50 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
1answer
25 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
1answer
231 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
1answer
18 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
1answer
78 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
0answers
53 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 ...
2
votes
1answer
347 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
0answers
123 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
0answers
161 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
2answers
79 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
1answer
89 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
1answer
41 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
0answers
127 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
1answer
45 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
1answer
22 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 ...
2
votes
1answer
4k 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
1answer
6k 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
2answers
248 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
1answer
70 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
2answers
3k 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
2answers
224 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
1answer
803 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
0answers
179 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
0answers
148 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
1answer
298 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
1answer
795 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?
2
votes
1answer
5k 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
2answers
161 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
1answer
173 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 ...