0
votes
2answers
25 views

How can I summarize age ranges and counts in Excel?

I have a table with a long list of individuals, and their age. From this data, I was able to derive a list of all ages, and then count how many people were of each age. Here is some simple, sample ...
1
vote
2answers
36 views

How can I create this column chart in Excel?

Well, I'm trying to create a column chart from this simple piece of data and I don't quite understand how the the chart tool is selecting the data and axises. Here is the data: ...
0
votes
0answers
13 views

Excel - Updating a .xlsb file when saving a .xlsx file

I work on Excel for Mac 2011. Sometimes, for no apparent reason, I can't open one file I saved in .xlsx. I did some research and found it was a bug. The only workaround I found is to save the file ...
-1
votes
1answer
28 views

How do I adjust the width of a series in an Excel chart?

Here is a picture of my current chart: I've tried to modify the scale to get the series' (the column) to be thicker. Ideally, I'd like the columns to be closer together too. I've double-clicked on ...
-1
votes
1answer
35 views

How do I reference a cell in an Excel data table without using the cell coordinates?

I do a summation on the values of a set of cells in an Excel data table. The problem is when I sort the table, the values in those cells change (because the records get sorted) and this changes the ...
0
votes
3answers
36 views

What can an Excel table do?

I don't really understand why I should use an Excel table. It seems all the functionality that a typical Excel worksheet provides is duplicated by an Excel table. The only difference I can see is that ...
0
votes
0answers
65 views

Make Excel Row Height Stay Once Sorted [duplicate]

One column has variable length data that may be one row or maybe a bunch of rows deep. (Actually another column does as well, but it doesn't get more than 3 rows deep). When I sort my spreadsheet, ...
1
vote
2answers
18 views

Convert numerical result to a letter in Excel for Mac 2011

I just wanted to know how to convert the result of a calculation into a simple YES or NO outcome. I.e. if the value is less than X then 'YES' you need to reorder, if the value is greater than X then ...
0
votes
1answer
56 views

Sum the number of hours in Excel

I want to sum the total hours I was worked in a project. For each day, I have: Starting Time B1: 09:30:00 am Ending Time C1: 17:00:00 pm Total Hours D1: =C1-B1 (06:30) I want to sum the values ...
0
votes
1answer
96 views

How to use Excel HYPERLINK function to link to an URL with query parameters?

*This is observed under OSX 10.8.5 with Office 2011 (mac). The hyperlink function seems not working with url with query parameters, why? HYPERLINK("http://mysite.com?foo=bar&x=y", "my link") ...
0
votes
2answers
31 views

EXCEL: IF function only working if Value is TRUE and remitting a #NA if the Value is FALSE: Apple Mac Air - Microsoft Office 2011

Can anyone help me with the following formula? Basically it works when the condition is TRUE but gives me an error when the condition is FALSE. I would like the cell to remit the value "0" if the ...
0
votes
1answer
118 views

Comparing two similar lists in excel on mac to find duplicates

I have 2 rather long lists of companies (a developing main list and several other lists which need to be compared to the main) I need to find duplicates (but also fuzzy duplicates) - e.g. "A company" ...
0
votes
0answers
50 views

How to keep track of manual entries each day?

I am trying to keep track of manual entries but do not know the correct method of doing this. Should it be done using vba or by using formulas? I have spreadsheet you can view so you can see what I am ...
0
votes
1answer
794 views

Tie stock quote value to cell in Excel 2011 Mac

I've been working on a mock stock portfolio in Excel, and I've been looking for ways to automatically update the data, eg. stock price and P/E ratio. I have tried using a web query to MSN Money, but ...
2
votes
1answer
44 views

Excel opens all files in directory

Excel 2011 is behaving strange. When I open a file, Excel responds by opening all (.xlsx and .csv) files in the directory! I'm running OS X Mavericks. Tried several ways of opening: double click, ...
-1
votes
1answer
29 views

using date ranges and numbers

I have a spreadsheet that uses both dates and numbers. For example I have a job that takes 4 hours to complete and needs to be done on 10/11/13. I have several jobs that end on this date but the time ...
0
votes
0answers
11 views

Change focus in Excel to formula bar via keyboard using Excel 2011 in Mac [duplicate]

I want to ask the same question as this one but for Microsoft Excel 2011 in Mac. The issue is that in Excel 2011 for Mac there is no Tools -> Options.
2
votes
1answer
743 views

How to copy and paste without overwriting in Excel

I'm trying to copy a block of cells, but instead of shifting down the rest of the rows, it overwrites them How do we copy and paste a set of cells and shift the rest so nothing is lost?
0
votes
1answer
33 views

How do I seed another data table's records with category information in another Excel data table?

I have a data table, of which one of the columns is 'Categories'. It is a basic text column, but it has a finite set of strings (e.g. 'Utilities', 'Home', 'Medical', etc.) I would like to ...
0
votes
1answer
54 views

How to inspect which values were used in calculation in Microsoft Excel?

In cases where I have complicated formulas like =HLOOKUP(ROUNDDOWN((D$165-1)/12,0)+1,$D$24:$M$25,2)*D$2 Is there a good way to see which values ended up being used in the calculation? In this ...
0
votes
2answers
66 views

Mac OS 10.8.4 and Excel

I am trying to delete everything after the "," on each cell in a column of email addresses. For example: jonsmith@hotmail.com,2013-08-06 13:27:53,bounced sallyfield@google.com,2013-02-06 ...
0
votes
1answer
179 views

Linking to Other Excel Sheets Greyed Out (Excel 2011 Mac)

I just got a file from my colleague which has some broken links. They were broken because the path to the cells pointed directly to a file on her computer. She sent over those files, and now I have to ...
0
votes
1answer
187 views

Print multiple worksheets to a single physical page

If I have three worksheets in a workbook, how can I print them on the same physical page? On Excel for Mac 2011, doing "Print What" "Entire Workbook" gives me three different pages, even if in ...
3
votes
4answers
3k views

How can I quickly determine if an Excel spreadsheet contains any formulas or is just “static” text?

I've inherited an Excel spreadsheet with many sheets, all full of text and numbers. As far as I can tell, this is all hardcoded, static text. After a quick look, I can't see any formulas or anything ...
0
votes
0answers
91 views

Save custom macro toolbar modifications in Excel 2011 for Mac

I produced several custom macros in Windows, modified the XML so that a custom Ribbon Tab was visible in the 2013 version of Windows, and everything was wonderful. I'm now trying to produce ...
0
votes
2answers
44 views

Manually populate a Pivot Table

This is really a stupid question because I am supposed to know the answer. I have a data file that looks like this: Tech || Workdate || Fail || Manual Joe || 2013-05-23 || 6 || 1 Joe ...
0
votes
0answers
60 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
84 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 ...
1
vote
0answers
557 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 ...
0
votes
3answers
246 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 ...
1
vote
0answers
179 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 ...
1
vote
1answer
3k 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 ...
0
votes
1answer
146 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
182 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 ...
1
vote
3answers
2k 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
5k 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 ...
2
votes
1answer
536 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
1k 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
80 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
1k 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
325 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 ...
0
votes
4answers
2k 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 ...
1
vote
0answers
152 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
509 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 ...
1
vote
1answer
116 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
970 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
1answer
2k 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
311 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
264 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 ...
1
vote
2answers
176 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?