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

learn more… | top users | synonyms (1)

2
votes
2answers
10k views

Excel: formula to display answer only if ALL cells in a formula have a value

I have a scenario where I don't want excel to use a blank cell as a zero value. I only want the cell to display the result if all the cells in the formula have a value entered. For example: ...
2
votes
3answers
5k views

Formula to move data from every third row to a column?

I have an excel sheet (mac, Excel 2011) that contains names (1st row), job titles (2nd row), and company/institution (3rd row) in one big column. I am trying to separate them into three different ...
0
votes
1answer
1k views

Merging rows in an Excel document with the same email and preserving merged row data

I have an excel sheet of around 50,000 records of something like this: email product info moreinfo a@a.com 866 data data1 b@b.com 960 data data1 c@c.com 976 data data1 c@c.com ...
0
votes
1answer
21k views

Excel chart with year-to-year comparison

Given this data: Date Year Month Usage (Kw-h) Cost/Month 02/19/08 2008 2 501 59.13 03/18/08 2008 3 404 48.49 04/16/08 2008 4 387 45.67 05/22/08 2008 5 319 ...
1
vote
0answers
279 views

Excel 2011 Conditional Formatting: compatibility issues

I would like to create a workbook in Excel 2011 for Mac that is fully usable in Excel 2003 (on Windows XP, Compatibility Pack installed). The purpose is a semi-automatic calendar, where one enters ...
1
vote
1answer
678 views

Mac Excel 2011: find Items in one column that are not in another column

Hi this is a repeat of the question: Excel: Find Items in one column that are not in another column I have two columns in excel, and I want to find (preferably highlight) the items that are in ...
2
votes
2answers
2k views

How to get the list of sheet names of ms-excel?

I have an excel file which has a lot of sheets. How could I get a list of sheet names of ms-excel? (PS: The office is mac version.)
2
votes
1answer
3k views

Using Mac Excel, how can I delete partial duplicate rows?

I'm running Mac Office 2011 under Lion. I have a sheet of many thousands of rows of data, with a good 40 or 50 columns. One column is email address. If any two rows have a duplicate email address, ...
1
vote
0answers
84 views

Excel Sheet Link [closed]

I'm doing a dissertation of 17000 words, and I have a huge file of more than 400 pages in excel So how I can put all the excel work in one link in words or another program.
1
vote
1answer
2k views

How to create excel line charts with irregular scales

I am trying to create a line graph, The vertical axis is an irregular scale - 1,1c,1b,1a,2,2c,2b,2a and so on. Here is the data in chart format I am having trouble representing this data in the ...
1
vote
1answer
500 views

Show date format in Excel as the OS default

Is there a way in Excel (2007 and up) to set the date format of a column to the date format of the OS locales. The data entered in this column is a date (imported from a database date field). For ...
1
vote
6answers
10k views

duplicating a row in excel

i have a large financial spreadsheet with a ton of formulae. i'd like to duplicate a row such that it retains the same formula and coordinates as the source row (basically duplicate a summary row and ...
2
votes
0answers
228 views

How to setup a CSV web datasource

In Excel, I can import a CSV from the web as text by simply pasting in the URL as a file name, but when I ask Excel to update, it has stripped the URL and tries to find a file on the local hard drive ...
1
vote
1answer
781 views

Excel for Mac - unable to create my own macros

I have a macro (made for Excel - Windows), which url encode strings - i.e. space becomes %20. When I open the *.xlsm on a Mac with Excel installed(Office for Mac 2011), it does not work. No errors - ...
2
votes
1answer
1k views

Turn off (or increase size threshold) for clipboard warning in MS-Excel

This question asks how to programmatically turn off the "there is a large amount of information in the clipboard" warning" that MS-Excel pops up whenever you try to close an Excel file and the ...
0
votes
1answer
274 views

Excel Different line graph loaded on each selection

I have been adding a lot of absence/presence data into an MS Excel 2011 for Mac sheet. On the days students are present they get points, on days they are absent they get zero. If student was there, ...
0
votes
1answer
637 views

Excel 2011 for Mac VLOOKUP Date Issue

I'm fairly proficient in using vlookups, but I'm having an issue vlooking up dates between two different spreadsheets. =VLOOKUP(B6,'[example.xlsx]Sheet1'!$B$1:$AA$260, 19, FALSE) My formula is ...
0
votes
1answer
972 views

X axis on Time-Based data

I have a series of 24 hr. data, taken about once per hour. I wish to plot the values against time. On day 1 the 10:00 data was taken at 10:10, on day 2 the data was taken at 9:58. I do not want both ...
0
votes
1answer
171 views

(Combine 3 columns into one in excel 2011 for mac) plus change formula into usable number

If I set up the following, from a previous Applemac - from a “Superuser“ - excel solution. (Combine 3 columns into one in excel 2011 for mac) I enter column D to use the formula ...
1
vote
1answer
131 views

Error message when trying to retrieve a value from a range using VLOOKUP

I've got an excel spreadsheet where I would normally use a VLOOKUP. In this case I need to find the ID of the record when comparing email addresses, so the email address is the unique id here. For ...
2
votes
1answer
2k views

How come I can only forecast a trendline 5 periods backwards, while I can forecast it 1000+ forward?

It doesn't make any sense. I can do it in Excel 2010 on Windows, but not Excel 2011 on OS X. Workbook I used: http://cl.ly/Ewfe Screenie:
1
vote
2answers
4k views

Set Zoom Default to 125% Excel 2011 on OS X

I don't like smal fonts. Therefore I would like to have a default zoom level of 125% for all spread sheets in Excel 2011 on OS X Lion. Is there a way to tell Excel to open all spread sheets with a ...
2
votes
1answer
3k views

How to return first non-blank cell and if it's already a value before it, return the third non-blank and so on?

How to make a function which would return the first non-blank cell value but if it's defined in the left cells next to it, it would jump 2 cells and look for the next value. Table: 1 | 2 | 3 | 4 | ...
1
vote
1answer
3k views

Alternating Row Colour with Conditional Formatting in Excel 2011 for Mac?

Does anyone know how to create a formula that causes the row colour to alternate when using conditional formatting?
1
vote
1answer
375 views

Highlight Excel spreadsheet cells every three days

I use Excel 2011 on OS X to track down my tasks list. Now I would like to add a date cell to some tasks so that every three days these tasks get highlighted. My question is if there is any way so ...
2
votes
0answers
266 views

Can I disable Excel's warning when saving CSV files? [duplicate]

Possible Duplicate: Excel: Is there a registry setting to suppress the warning messages when saving spreadsheets in CSV format? Excel always says ...may contain features that are not ...
3
votes
2answers
7k views

How can I process million rows of data in Excel?

I understand that Excel can only process 65,536 rows of data. If I'm trying to analyze 7 million rows of data (say, plot a histogram distribution of 7 million values), is there any workaround? Can I ...
1
vote
2answers
781 views

Linking a cell to a tab within an Excel workbook

I'm using Microsoft Excel 2011. One of my workbooks contains a tab. I want that tab to open when I click a link. The link should be in a cell in the same workbook. How can I create such a link?
4
votes
2answers
17k views

Excel data into PowerPoint slides

I have already found some helpful sites but I'm still unable to do what I want. My Excel file contains few columns and multiple rows. All the data from one row would be in one slide but data from ...
1
vote
2answers
5k views

Opening a file for output/input in Microsoft Visual Basic on Mac OS X

I am working in Excel for Mac 2011 and my goal is to create a simple macro that writes particular cells to a file. This is generally a simple task, but VB chooses not to accept a file path. For ...
0
votes
1answer
1k views

Excel: Filter Pivot Table from Another Sheet / Duplicate Filters Across Sheets

I am working with Excel for Mac 2011. I have several different pivot tables that each organize data for graphing on a summary sheet. Every pivot table should be filtered the same way. Questions: ...
2
votes
5answers
8k views

How can I get Excel 2011 to stop opening my Personal Macro Workbook?

Ever since I created a couple of macros in Excel for Mac 2011, the Personal Macro Workbook opens every time I open Excel. How do I keep that from happening? I have since deleted the macros, but I ...
0
votes
1answer
1k views

How can I sort by word/token in Excel 2011

Is it possible to sort a spreadsheet based on if a word is contained in cells within a column? Like if I take the "title" column and sort, keeping the rows connected, to bring all the rows with a ...