Stack Overflow
Stack Overflow

Questions tagged [excel-2011]

Excel 2011 refers to the spreadsheet editor included in Microsoft Office for Mac 2011.

151 questions
0
votes
2 answers

UI for creating a custom tab in ribbons for an add in for Excel for Mac

Is there any other simple way apart from using the Custom UI Editor as mentioned here? I've tried this method. It works fine for Excel on Windows but simply does not load anything on a Mac.
sharky
  • 327
  • 4
  • 13
0
votes
1 answer

How to make a Cosd Function with VBA for Excel?

I need to make a function that finds Cosine in Degrees. I am on Mac-OS Excel 2011 Function cosd(d) deg = (d * 3.14159265358979) / 180 cosd = WorksheetFunction.Cos(deg) End Function It still does not work.
Waleed
  • 59
  • 1
  • 1
  • 8
0
votes
2 answers

Goal Seek Macro with moving Goal and Seek variables

I have a Goal Seek Macro: Sub GOALSEEK() Range("K25").GOALSEEK Goal:=0, ChangingCell:=Range("K10") End Sub That works for 2015Q4, cell K25 at 0%. I want to adapt the macro for moving Goal and Seek variables. The moving Goal will be stored in…
emehex
  • 9,874
  • 10
  • 54
  • 100
0
votes
1 answer

Format a column automatically to convert whatever is entered to all capitals

One of the columns in my Excel spreadsheet is just three letter codes that all need to be in capital letters. So I don't have to worry about making sure each time I enter one of the codes that I have Caps Lock on, how can I make Excel…
Elemenop
  • 11
  • 4
0
votes
1 answer

excel 2011 mac VBA open file - error 75

I am just starting out with VBA on Excel 2011 for MAC. I have run the code below on Windows without a hitch, but get error 75 on mac. Any help much appreciated: Sub cr_acc() Dim rdata() As String, idxData As Long Open "\Volumes\SMALL…
burovik
  • 5
  • 4
0
votes
2 answers

Text calendar date to Julian date in excel

I have a column of yymmdd dates formatted as text (ex: 970623) I'm trying to convert into Julian date in Excel 2011. I've tried converting to excel-formatted date, but it throws me back into the 1950s with all of my dates. I also found a suggestion…
Mo Correll
  • 57
  • 1
  • 8
0
votes
1 answer

Set Pass/fail based on 10 answers from each of many individuals

I'm trying to output a Pass/Fail indicator for each student. A new student is on every row and their 10 answers are logged from Column E to N. I want to match their answers with the 10 correct answers in Column S to AB, count them, and then have…
Nyhan
  • 111
  • 2
  • 2
  • 12
0
votes
2 answers

Conditional format cells based on match in another sheet

I have 2 excel sheets (Using Microsoft excel 2011 for mac, but tried the same on excel 2010 as well) sheet1(Column D) foo bar sheet2 abc cde foo sfd sdf dgf bar I have applied 3 different rules using conditional format: 1. If any of the data in…
Jill448
  • 1,745
  • 10
  • 37
  • 62
0
votes
1 answer

Is there a way to prefill the autocomplete entries in Excel for Mac 2011

I have a table with plant details. Abbreviation, genus, species, common name etc. This table is my reference table. I have an inventory table where I can type in the code, where they are, how many, how big, etc. It also fills in the common name…
Sherwood Botsford
  • 1,889
  • 5
  • 20
  • 35
0
votes
4 answers

Match text from two different workbooks, return value from different column

I have never been so frustrated with Excel in my life. I'm coming up against two major deadlines at work, and the only way to get the right info to the right people involves solving the problem below. I have two workbooks with different metrics for…
elle.cache.money
  • 1
  • 1
  • 1
  • 4
0
votes
0 answers

Large CSV tabbed delimited text files will not open in Excel 2011 or OO on Mac

We have a tool in our C++ codebase that will output EEG float values into Tabbed delimited text. If we have, for example, 256 channels and 550000 samples, we output a CSV Tabbed test file that should open in Excel with 256 columns and 550000 rows.…
Miek
  • 1,127
  • 4
  • 20
  • 35
0
votes
1 answer

Remove current cell's value from active autofilter in same column

I have a big Excel sheet containing +100k rows and have an autofilter on one column of text values with category numbers and descriptions. There are thousands of different values in column F, so updating the autofilter is very impractical via using…
Etienne678
  • 444
  • 4
  • 12
0
votes
3 answers

Problems with converting text to date (YYYY-MM-DD) in Excel (Mac)

I have been able to convert this date to YYYY-MM-DD HH:mm but not anymore. What can I do to convert this date. Sep 15, 2014 9:30:32 AM You need to know that I'm using Swedish keyboard, date and region. Example: Order # Purchased On 100026881 Sep…
argit
  • 3
  • 1
  • 3
0
votes
1 answer

Excel VBA does not compile - MD5 hash function

Right now trying to implement a VBA module in Excel 2011 for Mac I found through the interwebs. The following module fails on the third line where you see As String: Option Explicit Public Function MD5Hash( _ ByVal strText As String) _ As…
crockpotveggies
  • 12,682
  • 12
  • 70
  • 140
0
votes
0 answers

Create multiple copies of xlsx file with different file names on Mac Excel

I have a .xlsx file that contains 4 sheets filled with data and formulas etc. I need to duplicate that .xlsx file 1000 times and save each file with a different name. I have another .xlsx file containing the list of 1000 names that I would like…
Cole
  • 1
  • 3
1 2 3
…
10 11