# Questions tagged [microsoft-excel-2011]

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

**0**

votes

**2**answers

19 views

### Summing values based on column and row titles

Currently using MS Excel for Mac 2011. I have been trying with no luck to make a formula that sums all values in an array that have a particular column title and row title. Row titles are unique, but ...

**0**

votes

**0**answers

189 views

### Custom Cell Format - Microsoft Excel for Mac 2011

I applied a custom format to cells. The custom was adding parentheses to text. The text looked like 2010-01. After adding the custom format it looked like (2010-01). I have a worksheet with a ...

**0**

votes

**0**answers

209 views

### How to show number labels on the minor divisions of the Y axis in Excel

How do I show number labels on the minor division of the Y axis in Excel 2011? For example, between 1,000 and 10,000 on the chart below, can I add labels like 3000, 7000, 8000 to the axis?

**0**

votes

**1**answer

220 views

### Using INDEX and MATCH, IF and AND to return the column title of a cell Excel 2011 Mac

[enter image description here][1]I have a data set consisting of columns representing 0.1 metre increments, and for each column I have a numerical value. These numerical values decrease as the ...

**0**

votes

**0**answers

54 views

### Automatically format currency based on the currency in another cell

Cell A1 can be any currency
I want Excel to automatically format the currency of cell B1 to match the currency of cell A1.
I assume this involves conditional formatting but I don't know how to write ...

**0**

votes

**1**answer

1k views

### Excel: Combine multiple rows but keep column data?

I have an Excel spreadsheet (Excel 2011 for Mac) with 1175 rows containing species names (431 names total) and 72 columns (A:BT) of months from October 2011 to August 2017. Each row only has one cell ...

**0**

votes

**1**answer

211 views

### Need to Delete Blank Row including All Data in the Row - Excel 2011 for Mac

I have an Excel spreadsheet of email addresses with first and last names. Some of the names do not have an email address and it's blank so I want to delete the blank fields along with the first and ...

**0**

votes

**0**answers

195 views

### Dividing a number by the sum of a range of cells

I'm trying to spread a transport cost over the number of units that were delivered (that's the back story).
My question is: how do I write a formula in F3 that divides E3 (£40.00) by the sum of C3 ...

**0**

votes

**1**answer

207 views

### Excel: What's causes an option to appear twice in a drop-down menu?

I am working on a budget and I have a drop down menu for the items. I have one category called Food but when I type in Food, it appears that there are 2 options
I can only select one of them and not ...

**0**

votes

**1**answer

239 views

### Create custom hyperlinks in Excel

I am looking for a formula to automatically create custom hyperlinks into an excel spreadsheet, based on contents of another cell
I have a list of books where I can get the image from an url database....

**1**

vote

**1**answer

14k views

### How do I automatically sort a table in Excel every time one of its values is updated?

I'm keeping the results from a season of the baseball board game Strat-O-Matic in an Excel spreadsheet (Excel 2011 for Mac). The sheet has the league schedule and league standings. I've already set it ...

**1**

vote

**1**answer

37 views

### Match two columns, and bring along values in the corresponding columns - Microsoft Excel for Mac 2011 v. 14.4.1

I need to match two columns (B and C) and move down the values (C and D) inserting an empty line where there's no match.
into this
Is there a formula that can do this?

**1**

vote

**0**answers

267 views

### Office Excel 2011 for Mac : when exporting an excel sheet to csv, around 25000 empty csv lines get added

so when saving as windows csv and press save i get the actual data:
1,1,2,
then i get around 25'000 lines:
,,,
,,,
,,,
,,,
,,,
,,,
....
when i do the same with libre office i get only the data, no ...

**0**

votes

**1**answer

582 views

### How to do conditional formatting with date comparison on Excel 2011

Please forgive me since I don't know where to start with this problem.
I have an Excel sheet with multiple columns. Two of the columns are dates in the format of "MM/DD/YYYY HH:MM:SS", column A and ...

**0**

votes

**1**answer

281 views

### Excel 2011, VLOOKUP across sheets & List validation

Im trying to create a dropdown list on a sheet, that looks up a matched value in another sheet. In the picture below is of a sheet called PricesforCSV. Here I want the circled value in column B to be ...