The microsoft-excel-2011 tag has no wiki summary.
3
votes
2answers
2k 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 ...
2
votes
1answer
1k 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 | ...
2
votes
2answers
273 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
1answer
447 views
Locating Autorecover files Excel 2011 doesn't find
When Excel 2011 crashes, it often does not automatically re-open the latest version from the auto-recover files. Instead Excel may bring up the last user saved version that may not have the latest ...
2
votes
1answer
205 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
496 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:
2
votes
0answers
261 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 ...
2
votes
2answers
4k 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
1answer
97 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 ...
1
vote
1answer
253 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 ...
1
vote
1answer
650 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
2answers
87 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?
1
vote
1answer
741 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
1answer
2k 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
0answers
75 views
Keyboard Shortcut to Fit Column Width to Text in Mac Excel?
I know this on a PC. It is Alt+O,C,A, as explained in this question.
Can someone tell me please what the keyboard shortcut is to fit the column width to the width of the text in Excel on a Mac?
I'm ...
1
vote
1answer
61 views
Copying an absolute reference in Excel
I am trying to copy an absolute cell reference from one sheet to another. The nature of the second sheet means that the formula will move from cell to cell depending on where it is placed. Is there a ...
1
vote
1answer
221 views
Create a form as a worksheet in Excel that adds records to another worksheet
I am trying to create a form in Excel for vehicle requests. What I want to happen is to create one worksheet that is a recreation of the current paper form, but have a clickable button that will ...
1
vote
1answer
544 views
Office 2011, Mac OS Lion, Excel creates temporary file on Windows server 2008, SMB share how to stop?
I have an issue with Mac's and a windows SMB share, when using Excel 2011.
If I open an excel document from the windows share it will create a "Ghost file" starting with ~$ then the full filename e.g ...
1
vote
1answer
147 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 ...
1
vote
0answers
70 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
127 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
2answers
2k 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 ...
1
vote
3answers
259 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
4answers
131 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 ...
0
votes
1answer
379 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
3answers
108 views
Excel - Sum First Value Of Non-Unique Adjacent Column
I have a table:
ColA | ColB
1 1
2 1
2 1
3 1
4 1
5 1
I would like to sum ColB only once where ColA = 2.
Essentially, I would like to sum the values ...
0
votes
1answer
58 views
HLOOKUP Return Greatest Value
I have some columns A, B, C, D, E, F, G with some values in the rows below 2, 3, 4. I don't know if HLOOKUP is the correct answer for what I am trying to do but I want to have a function that looks at ...
0
votes
1answer
90 views
Why does my conditional SUM not work?
I am Using Excel 2011 for Mac and am having a hard time figuring out a way to return some data that I need.
I have a sheet with a table, column D is "Type" and column H has numbers. I want one cell ...
0
votes
1answer
626 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 ...
0
votes
2answers
1k 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
3k 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
0answers
21 views
Is it possible to use alt-XYZ shortcuts on Excel on OS X?
I don't want to know the equivalents -- I want to use the same commands. I'm switching between windows at work and a mac at home.
0
votes
1answer
30 views
Prevent Excel from converting text to columns
When I'm using Excel to parse multiple documents, and I need to control the import (Text, not General, on column import settings being the most notable example), how can I prevent Excel from ...
0
votes
0answers
25 views
How to connect Excel for Mac 2011 to an XMLA data source?
I have an XMLA datasource (implemented using Mondrian) that I would like to connect to from Excel for Mac 2011. I would like to be able to use Excel to interactively explore the OLAP cube. Is this ...
0
votes
0answers
50 views
Find out which cells got updated in Excel [closed]
I have an Excel spreadsheet that calculates some relative dates. At one point I put in some TODAY() formulae in various cells to update the dates automatically. Some other cells that refer to this ...
0
votes
0answers
61 views
Finding duplicate rows in excel gets partial matches, need only full matches
I'm using Excel 2011 for mac, trying to highlight rows that are full duplicates. Using the conditional formatting options is highlighting partial matches, I only want it to highlight the row if all ...
0
votes
1answer
25 views
Office for Mac 2011 - unable to insert cells properly in Excel
I am unable to insert cells in a spreadsheet the way I want to.
When I try to insert two cells, the action automatically defaults to inserting a row instead of shifting cells down or right.
How do I ...
0
votes
0answers
27 views
Updates to existing Mac excel 2011 file lost - can the changes be recovered?
I worked on an Mac Excel 2011 document yesterday. Its a file I work on regularly and when I modify it I overwrite it with the same name - thus overwriting the old version of the file.
Today I open up ...
0
votes
0answers
72 views
What is the best way to create charts of “database-style” tables and data in Excel?
I'm a biologist and I frequently have to do analysis on relatively large (for Excel) datasets. Usually a few charts are needed to display the data, but creating them seems to require laying out out ...
0
votes
0answers
50 views
Pasting values in Excel 2011 results in “#VALUE!” error
I have a PowerBook with OS X Lion.
When I export numerical data from third party apps (as .csv files) into Excel for Mac 2011, I can not execute even the simplest mathematical operations on it… even ...
0
votes
0answers
114 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 ...
0
votes
1answer
136 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 ...
0
votes
1answer
329 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 ...
