Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [microsoft-excel-2011]

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

0
votes
0answers
128 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
0answers
144 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
1answer
158 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
0answers
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
1answer
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
1answer
148 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
0answers
132 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
1answer
144 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
1answer
161 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
1answer
13k 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
1answer
36 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
0answers
200 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
1answer
508 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
1answer
216 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 ...
0
votes
1answer
821 views

Excel - Sorting within a Sort

I have an excel spreadsheet of my todos. Each row in the spreadsheet is a todo and each column gives an attribute of that todo (for example, the priority of the todo). I also have three columns that ...

15 30 50 per page