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

**0**

votes

**1**answer

156 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

147 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

2k 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

106 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

41 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

112 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

78 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

88 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

19k 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

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

**-1**

votes

**2**answers

51 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

206 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

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

**0**

votes

**2**answers

229 views

### MS EXCELL =SUM IF formula

I need to formula for the following
iF a1= 1 then d1 must = b1+c1
tried =sumif(a1,"1",b1:c1)
I only want cell d1 to calculate if cell a1 is '1'

**0**

votes

**1**answer

155 views

### How do I fix this VLOOKUP that returns last row value for date lookup?

I am running into what seems to be a very basic issue with Excel's VLOOKUP function (Mac Excel 2011). I've downloaded historical stock prices from Google Finance for Microsoft and then copied that ...

**-1**

votes

**1**answer

76 views

### The value given by the Excel NOW() function

I have an Excel sheet that does a some SUMIFS() over manually entered data, including some kind of test for entry date.
When I enter a new data line, I first type =NOW() in the cell then copy-paste ...

**1**

vote

**1**answer

1k views

### No Startup folder in Microsoft Office for Mac 2011

I'm trying to save a new default worksheet in Excel for Mac 2011. Instructions say to save it in the Startup folder at this location:
/Applications/Microsoft Office 2011/Office/Startup/Excel
There ...

**1**

vote

**0**answers

45 views

### Comparing two spreadsheets and add data from one if it meets both email address are correct

I want to compare two spreadsheets against using email address and if the email address matches then take information from a cell and add it the the 2nd sheet.
Example Sheet columns:
ID
First name
...

**0**

votes

**2**answers

3k views

### How do i change the date format to UK in Excel 2011

My Excel 2011 for Macbook will accept input of dates only in US format MM/DD/YY. I would like to enter dates in UK format DD/MM/YY.

**0**

votes

**0**answers

229 views

### how to perform operations between sheets in excel

My question is very easy and I'm sure there is already an answer somewhere but I don't know the correct keywords when searching for them.
So here is the question:
In column C of sheet2 I want to ...

**0**

votes

**2**answers

100 views

### IF Function on excel - i need to put a formula into one cell using to < < however it isnt working

I need to put in one cell that IF the value of H3 and F3 is lower that 25000 but higher than 0 it will equal 29.95, if false 0
the formula
=if(0

**0**

votes

**1**answer

1k views

### About the maximum number of arguments in Excel's STDEV function

According to Excel's Help Center you can only use the STDEV function for up to 255 arguments.
1 to 255 number arguments corresponding to a sample of a population.
However, when I take the STDEV ...

**0**

votes

**1**answer

196 views

### Excel - Counting unique values with multiple criterias

I have a large scale data set and I am looking for a way to count the number of unique values:
Day -ID, Location-ID, Truck-ID
1, 18, 1
1, 19, 1
...

**1**

vote

**0**answers

66 views

### Excel 2011 conditional formatting, problems w/ adding deleting rows [duplicate]

I have a standard form I use that requires an row to be highlighted one of 7 colors when a condition is met in a cell in that row. The form varies wildly in length. Currently, I am using conditional ...

**1**

vote

**3**answers

2k views

### Text function in Excel isn't formatting year

I've got a problem with the text function in Excel (2007).
It doesn't format the year, it just states yyyy instead of e.g. 2014.
If I have a cell with 23-7-2014 and use the formula ...

**0**

votes

**1**answer

58 views

### Using Mac Excel, How can I delete complicated duplicates?

I'm running Mac Office 2011 under Lion.
I have a spreadsheet with headers of Company, Name, Last Name, City, State, and Email. Some are duplicate entries but are missing the email. I would like to ...

**1**

vote

**0**answers

33 views

### Excel for Mac 2011 - Conditional Format - Look inside formula for sheet reference

I would like to use conditional formatting to locate all cells on a large sheet (Sheet 1) that have a reference to another sheet (Sheet 2) within a formula in a cell on Sheet 1. I was hoping I could ...

**0**

votes

**1**answer

194 views

### Edit current cell via keyboard?

In Excel for Macintosh 2011, when the cursor is in a particular cell of a spreadsheet and you wish for the focus to move to the edit line for that cell where the formula is displayed, is there a ...

**0**

votes

**0**answers

5k views

### How to change default font size in Microsoft Excel for Mac?

I'm using Microsoft Excel for Mac 2011 and by default, a new spreadsheet has a font size of 12 for cells. On a 4k screen resolution, font size 12 is a bit small, so I have selected the whole ...

**1**

vote

**4**answers

15k views

### How can I sort my data while keeping paired rows together?

How can I pair two rows on a spreadsheet, so that for each data entry I can sort the matrix but the pair of rows moves as a single list of data, retaining the structure of the two rows?
For example:
...

**1**

vote

**1**answer

119 views

### Is it possible to change or modify built-in VBA editor in Excel for Mac 2011

I am using the built-in VBA editor in Excel 2011 for Mac, but the built-in editor doesn't respond well to my scrolling gestures. I'm having too much trouble writing/finding code.
Is it possible to ...

**0**

votes

**1**answer

236 views

### Excel Chart Timeline

I have a CSV file that I have opened in Excel 2011 for Mac.
The CSV looked like this:
Timestamp | URL
01/Jan/2014:01:01:01 /path/to/something1
01/Jan/2014:01:01:05 ...

**0**

votes

**1**answer

303 views

### Search Excel price grid with variable values

WIDTH
DROP 1150 1550 1850 2160 2360 2750 3000 3480 3980 4450
1200 338 348 378 413 431 450 467 513 ...

**0**

votes

**2**answers

350 views

### VBA Excel 2011 for Mac: Create custom category for user defined function error

I created several functions i.e.: "cal_adval". I would like to add it to a new function category named "Custom Clearance"
I read the documentation, and wrote this macro:
Sub add_category()
...

**0**

votes

**1**answer

433 views

### Change border color of selected cell

When I select a cell in Excel for Mac 2011 it is shown with a blue border:
How can I change the color of this border?

**0**

votes

**2**answers

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

**0**

votes

**2**answers

15k views

### How can I summarize age ranges and counts in Excel?

I have a table with a long list of individuals, and their age. From this data, I was able to derive a list of all ages, and then count how many people were of each age. Here is some simple, sample ...

**1**

vote

**2**answers

276 views

### How can I create this column chart in Excel?

Well, I'm trying to create a column chart from this simple piece of data and I don't quite understand how the the chart tool is selecting the data and axises.
Here is the data:
...

**0**

votes

**0**answers

139 views

### Excel - Updating a .xlsb file when saving a .xlsx file

I work on Excel for Mac 2011.
Sometimes, for no apparent reason, I can't open one file I saved in .xlsx. I did some research and found it was a bug. The only workaround I found is to save the file ...

**0**

votes

**0**answers

720 views

### VBA not working in Excel for Mac 2011

I bought a Macbook Pro and Office 2011. Am trying to use an Excel file with VBA code and macros, which works on every other Windows PC I've tried. Unfortunately it doesn't on my Mac. Office 2011 is ...

**-1**

votes

**1**answer

58 views

### How do I adjust the width of a series in an Excel chart?

Here is a picture of my current chart:
I've tried to modify the scale to get the series' (the column) to be thicker. Ideally, I'd like the columns to be closer together too. I've double-clicked on ...

**-1**

votes

**1**answer

119 views

### How do I reference a cell in an Excel data table without using the cell coordinates?

I do a summation on the values of a set of cells in an Excel data table. The problem is when I sort the table, the values in those cells change (because the records get sorted) and this changes the ...

**0**

votes

**3**answers

46 views

### What can an Excel table do?

I don't really understand why I should use an Excel table. It seems all the functionality that a typical Excel worksheet provides is duplicated by an Excel table. The only difference I can see is that ...

**0**

votes

**0**answers

66 views

### Make Excel Row Height Stay Once Sorted [duplicate]

One column has variable length data that may be one row or maybe a bunch of rows deep. (Actually another column does as well, but it doesn't get more than 3 rows deep).
When I sort my spreadsheet, ...

**3**

votes

**1**answer

2k views

### direction right to left Excel 2011 on Mac

I am trying for a long time already and can't find a solution for MAC
I would like my excel worksheets to be Right To Left.
Using Excel 2011 on Mac.
How can I do it?

**1**

vote

**2**answers

37 views

### Convert numerical result to a letter in Excel for Mac 2011

I just wanted to know how to convert the result of a calculation into a simple YES or NO outcome. I.e. if the value is less than X then 'YES' you need to reorder, if the value is greater than X then ...

**0**

votes

**1**answer

789 views

### How to use Excel HYPERLINK function to link to an URL with query parameters?

*This is observed under OSX 10.8.5 with Office 2011 (mac).
The hyperlink function seems not working with url with query parameters, why?
HYPERLINK("http://mysite.com?foo=bar&x=y", "my link")
...

**0**

votes

**2**answers

67 views

### IF function only working if Value is TRUE and remitting a #NA if the Value is FALSE on Excel

Can anyone help me with the following formula? Basically it works when the condition is TRUE but gives me an error when the condition is FALSE. I would like the cell to remit the value "0" if the ...

**1**

vote

**1**answer

2k views

### Comparing two similar lists in excel on mac to find duplicates

I have 2 rather long lists of companies (a developing main list and several other lists which need to be compared to the main) I need to find duplicates (but also fuzzy duplicates) - e.g. "A company" ...