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

Snow Leopard Automator: Trying to create a workflow for converting Excel Files

I was trying to learn the automator functions for Snow Leopard. I googled around how to use automator to create a workflow for exporting Excel documents to CSV files. I got some hits with demonstrations showing this procedure on Leopard. However,…
banditKing
  • 9,405
  • 28
  • 100
  • 157
0
votes
2 answers

Excel Place All Dates in a Range in Cells

I don't know if this is the right place to ask this, but I saw others asking Excel Questions here. How can I get Excel to put all the Months and Years between two date ranges. Like for example my date range is March 2004 - December 2008, so Excel…
henryaaron
  • 6,042
  • 20
  • 61
  • 80
0
votes
2 answers

Cross Compatibility of Millisecond Timer Resolution in Excel VBA

I would like to get fractional timer resolution in an Excel VBA project that has to be compatible with Windows Excel 2007 and Mac OS Excel 2011. Ive found a method in windows utilizing sleep from kernel32.dll and a method on Mac OS using…
Hari Seldon
  • 1,060
  • 2
  • 13
  • 27
0
votes
1 answer

Workbook.SaveAs() to different folder in Office 2011 for Mac

How to save xls to another folder? When I use "/" in save path it replaces then with ":". When I try to use "\" it saves the file with "\" in file name.
elerium115
  • 21
  • 3
0
votes
1 answer

Want up and down arrow in TextBox to change ListBox selection

Using Microsoft Excel 2011 on macOS Mojave, I have a UserForm with a TextBox (named NameEntry), a ListBox (named NameList), and two CommandButtons. When the TextBox has focus, I want the up and down arrow keys to act as if the ListBox has focus,…
blm
  • 2,379
  • 2
  • 20
  • 24
0
votes
1 answer

Runtime Error 1004 for Excel 2016 for Mac Macro (used to work on Excel 2011 for Mac)

So I've tried looking around the net and forums for solving this but since I can't seem to understand this at all, I need a bit of advice. I have a Macro that I used to run on Excel 2011 on Mac that I do not have anymore. When I try to run this on…
Shoujiki
  • 1
  • 2
0
votes
2 answers

How to create Excel list with data that excludes certain types of combinations

I have two lists with the same set of data (e.g. A, B, C, D), and I want to be able to create a list of combinations that exclude the same data twice (e.g. A/A, B/B, etc) and reversed sets (i.e. A/B means I don't want B/A) I'm using Excel for Mac…
Adrian Fridge
  • 7
  • 3
0
votes
1 answer

Create a keyboard shortcut in excel to insert specific symbol - Mac Excel 2011

Trying to figure out how to create a keyboard shortcut to insert the delta symbol (δ). Cannot find any documentation to create a shortcut for a symbol based on a google search.
spencerchad
  • 155
  • 1
  • 2
  • 8
0
votes
1 answer

Problems creating hyperlinks on Excel Mac with xlsx r package

I am trying to create an Excel File with r which should include hyperlinks to a website. Everything works fine and can be tested on Windows, but on my Mac it somehow fails... I get the message that Unable to open "LINK". Cannot locate the internet…
drmariod
  • 11,106
  • 16
  • 64
  • 110
0
votes
1 answer

Trying to bring in an image with VBE for Excel

Hi I am trying to bring an image and a text file on the same row as a matched string in a cell an example would be 070.txt & 070.jpg. matching up with R17-8976-070. I seem to be able to bring in the text file alright but when I run the code for this…
Paul-Walker
  • 1
  • 3
0
votes
1 answer

How to select first number within a cell for the "criteria1" of SUMIFS in Excel?

I'm using SUMIFS(), and I want the criteria1 to be the first number of a series of comma separated numbers within a cell. For example, A1=1111, 1112 SUMIFS(B:B, C:C, A1) So basically, the formula should add all the cells in B:B that are adjacent…
Devil07
  • 141
  • 1
  • 8
0
votes
1 answer

Is there a quick way for excel to identify and remove duplicate series from a cell such as this?

Is there a built in function, or a simple UDF that can identify the pattern in the information below and remove the duplicates? Assume the following is all within a single excel cell: 80154, 80299, 80299, 82055, 82145, 82205, 82520, 82570, 83840,…
Devil07
  • 141
  • 1
  • 8
0
votes
1 answer

Why is this UDF inconsistently adding numbers properly?

I can't figure out why this UDF is not adding numbers consistently. I color coded the output for illustrative purposes. It adds everything accurately, but for some reason it doesn't want to add the 4 numbers which should equal 64, but instead it…
Devil07
  • 141
  • 1
  • 8
0
votes
0 answers

Excel 2011 - How can I change this VBA UDF to output numbers out to do decimal places (hundredths place)?

I'm trying to manipulate this UDF so the output shows the decimal values out to the hundredths place. Notice that the sum in cell G2 should read 30.50 (or 30.5) but its dropping the decimals. I've tried function CDbl and CCur, but doesn't seem to…
Devil07
  • 141
  • 1
  • 8
0
votes
1 answer

Excel 2011 - How to change output of textJoin from value of cell, to the cell name, so I can put it in Sum() to add those values

I'm using the textJoin UDF listed below to combine values from various rows into a single cell; it displays each value. However, I want to know if I can manipulate the output of this UDF so that instead of simply displaying the values I can add the…
Devil07
  • 141
  • 1
  • 8
1 2 3
…
10 11