Questions tagged [microsoft-excel-2011]
The 2011 version of Microsoft's spreadsheet application for OSX.
173
questions
1
vote
1
answer
2k
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
[email protected] 866 data data1
[email protected] 960 data data1
[email protected] 976 data data1
[email protected] ...
- 2,497
1
vote
0
answers
455
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 ...
- 2,497
1
vote
2
answers
191
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,689
1
vote
1
answer
340
views
Is it possible to change or modify built-in VBA editor in Excel for Mac 2011
I am using the built-in VBA editor in Excel 2011 for Mac, but the built-in editor doesn't respond well to my scrolling gestures. I'm having too much trouble writing/finding code.
Is it possible to ...
- 2,497
1
vote
0
answers
71
views
Excel for Mac 2011 move column 2 in sheet 1 to column 1 in sheet 2
I would like to move column 2 into column 1 for each successive sheet, one sheet per week, automatically. Is that possible? I do it with this formula ='1st week'!D2 and manually changing '1st week' to ...
- 3,649
-1
votes
1
answer
223
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 > ...
- 49.6k
1
vote
2
answers
346
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, ...
CommunityBot
- 1
1
vote
1
answer
65k
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 ...
- 27.5k
1
vote
3
answers
825
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 ...
- 5,086
-1
votes
2
answers
50
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 ...
- 21.7k
-1
votes
2
answers
70
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 ...
- 22.8k
0
votes
2
answers
92
views
IF function only working if Value is TRUE and remitting a #NA if the Value is FALSE on Excel
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 ...
- 61.8k
0
votes
2
answers
337
views
MS EXCELL =SUM IF formula
I need to formula for the following
iF a1= 1 then d1 must = b1+c1
tried =sumif(a1,"1",b1:c1)
I only want cell d1 to calculate if cell a1 is '1'
- 1,119
0
votes
1
answer
4k
views
How do I fix this VLOOKUP that returns last row value for date lookup?
I am running into what seems to be a very basic issue with Excel's VLOOKUP function (Mac Excel 2011). I've downloaded historical stock prices from Google Finance for Microsoft and then copied that ...
- 22.8k
1
vote
0
answers
78
views
Excel 2011 conditional formatting, problems w/ adding deleting rows [duplicate]
I have a standard form I use that requires an row to be highlighted one of 7 colors when a condition is met in a cell in that row. The form varies wildly in length. Currently, I am using conditional ...
- 87.5k
-1
votes
1
answer
404
views
The value given by the Excel NOW() function
I have an Excel sheet that does a some SUMIFS() over manually entered data, including some kind of test for entry date.
When I enter a new data line, I first type =NOW() in the cell then copy-paste ...
- 260
3
votes
3
answers
75k
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 ...
CommunityBot
- 1
1
vote
0
answers
101
views
Comparing two spreadsheets and add data from one if it meets both email address are correct
I want to compare two spreadsheets against using email address and if the email address matches then take information from a cell and add it the the 2nd sheet.
Example Sheet columns:
ID
First name
...
- 57k
0
votes
0
answers
1k
views
how to perform operations between sheets in excel
My question is very easy and I'm sure there is already an answer somewhere but I don't know the correct keywords when searching for them.
So here is the question:
In column C of sheet2 I want to ...
- 183
0
votes
1
answer
3k
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:
...
- 1,816
0
votes
2
answers
156
views
IF Function on excel - i need to put a formula into one cell using to < < however it isnt working
I need to put in one cell that IF the value of H3 and F3 is lower that 25000 but higher than 0 it will equal 29.95, if false 0
the formula
=if(0
- 603
0
votes
1
answer
5k
views
About the maximum number of arguments in Excel's STDEV function
According to Excel's Help Center you can only use the STDEV function for up to 255 arguments.
1 to 255 number arguments corresponding to a sample of a population.
However, when I take the STDEV of ...
- 11k
0
votes
1
answer
267
views
Excel - Counting unique values with multiple criterias
I have a large scale data set and I am looking for a way to count the number of unique values:
Day -ID, Location-ID, Truck-ID
1, 18, 1
1, 19, 1
...
- 25.4k
0
votes
1
answer
186
views
Using Mac Excel, How can I delete complicated duplicates?
I'm running Mac Office 2011 under Lion.
I have a spreadsheet with headers of Company, Name, Last Name, City, State, and Email. Some are duplicate entries but are missing the email. I would like to ...
- 116
1
vote
0
answers
48
views
Excel for Mac 2011 - Conditional Format - Look inside formula for sheet reference
I would like to use conditional formatting to locate all cells on a large sheet (Sheet 1) that have a reference to another sheet (Sheet 2) within a formula in a cell on Sheet 1. I was hoping I could ...
- 11
0
votes
1
answer
768
views
Edit current cell via keyboard?
In Excel for Macintosh 2011, when the cursor is in a particular cell of a spreadsheet and you wish for the focus to move to the edit line for that cell where the formula is displayed, is there a ...
- 6,263
0
votes
0
answers
8k
views
How to change default font size in Microsoft Excel for Mac?
I'm using Microsoft Excel for Mac 2011 and by default, a new spreadsheet has a font size of 12 for cells. On a 4k screen resolution, font size 12 is a bit small, so I have selected the whole ...
- 7,918
0
votes
1
answer
831
views
Search Excel price grid with variable values
WIDTH
DROP 1150 1550 1850 2160 2360 2750 3000 3480 3980 4450
1200 338 348 378 413 431 450 467 513 549 579
1500 ...
- 4,062
0
votes
1
answer
805
views
Excel Chart Timeline
I have a CSV file that I have opened in Excel 2011 for Mac.
The CSV looked like this:
Timestamp | URL
01/Jan/2014:01:01:01 /path/to/something1
01/Jan/2014:01:01:05 /path/to/...
- 22.8k
0
votes
1
answer
1k
views
Change border color of selected cell
When I select a cell in Excel for Mac 2011 it is shown with a blue border:
How can I change the color of this border?
- 21.7k
1
vote
0
answers
655
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 ...
CommunityBot
- 1
0
votes
2
answers
10k
views
Nneed to calculate average of NON sequential multiple cells & I want to exclude values = 0 or Empty Cell with AVERAGEIF
Nneed to calculate average of NON sequential multiple cells and I want to exclude values = 0 or Empty Cell with AVERAGEIFS.
There is a mistake in my formula but I can't find a way to have it since ...
- 2,430
0
votes
2
answers
68k
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 ...
- 12.7k
1
vote
2
answers
498
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:
http://imgur.com/...
- 2,430
0
votes
0
answers
438
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,007
0
votes
0
answers
1k
views
VBA not working in Excel for Mac 2011
I bought a Macbook Pro and Office 2011. Am trying to use an Excel file with VBA code and macros, which works on every other Windows PC I've tried. Unfortunately it doesn't on my Mac. Office 2011 is up-...
user3412304
-1
votes
1
answer
1k
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 ...
- 2,379
0
votes
3
answers
70
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 ...
- 368
-1
votes
1
answer
641
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 ...
- 2,379
1
vote
2
answers
48
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 ...
- 12.7k
0
votes
1
answer
2k
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")
...
- 3,450
0
votes
1
answer
49
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 ...
- 11
0
votes
1
answer
1k
views
How to set a shortcut to "Customize Keyboard..." in Excel Mac 2011
I would like to set a shortcut to "Customize Keyboard..." in Excel Mac 2011 so I could open the "Customize Keyboard" menu via a simple shortcut.
Apparently we can't do do it via Excel because there ...
- 228k
0
votes
0
answers
22
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.
CommunityBot
- 1
0
votes
1
answer
195
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 ...
CommunityBot
- 1
0
votes
1
answer
2k
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 case, ...
CommunityBot
- 1
5
votes
1
answer
2k
views
How to change default size of the comment boxes
It's incredibly frustrating to resize the box every time I put a comment. Anybody know the shortcut, or can provide a clue so I can script this?
- 27.3k
1
vote
1
answer
945
views
Insert blank row into excel
I've been using this Excel program as a data base with this particular information for 5 years, inserting rows for alphabetical arranging on a regular basis. Now all of a sudden, can't do it. This ...
- 3,086
0
votes
2
answers
120
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:
[email protected],2013-08-06 13:27:53,bounced
[email protected],2013-02-06 13:05:47,...
- 333
0
votes
1
answer
1k
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 "...
- 22.8k