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
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

Questions tagged [microsoft-excel-2011]

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

2
votes
1answer
10k 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
496 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 pivottable:...
0
votes
1answer
412 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
0answers
544 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 ...
2
votes
3answers
9k 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
0answers
214 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
2answers
70 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
1answer
201 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
1answer
257 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
2answers
129 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
1answer
55k 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
3answers
359 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
2answers
45 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
2answers
61 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
1answer
668 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 ...

15 30 50 per page