Stack Overflow
Stack Overflow

Questions tagged [excel-2011]

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

151 questions
2
votes
4 answers

Is it possible to count the number of unique characters within a cell?

Software used: Excel Mac 2011 I have a column of cells containing alphanumeric strings, and I'm looking to count the number of unique characters that appear in each cell. I'd like to have it function as pictured below: Because of the data I'm…
Valark
  • 43
  • 1
  • 4
2
votes
1 answer

Dynamic charts from pivot

I have a data set that I am using as an input to a pivot table. I have transformed that data set into a table, so that every-time I add something to the data set, the pivot gets updated automatically. I have also added a line of code, so that…
Broly
  • 799
  • 3
  • 16
2
votes
1 answer

How can I make a custom fill handle pattern?

I have a column A3:A71 I wish to populate with values =COUNTIF(B3:B71,B3) Where the second argument is incremented with every cell. Obviously I don't want to copy this function every time, so I was hoping that fill handle would help me. However…
user2565010
  • 1,876
  • 4
  • 23
  • 37
2
votes
3 answers

Wildcard condition with * for SUMIFS formula on a column with number values

I have a huge excel sheet that looks like this: ╔══════╦══════╦═════╗ ║ A ║ B ║ C ║ ╠══════╬══════╬═════╣ ║ Jack ║ 2001 ║ 1,5 ║ ║ Jack ║ 2002 ║ 2,0 ║ ║ Jack ║ 2003 ║ 1,0 ║ ║ Jack ║ 3001 ║ 3,5 ║ ║ Jack ║ 3002 ║ 4,0 ║ ║ Jack ║ 3003 ║ 1,0 ║ ║…
leifericf
  • 2,324
  • 3
  • 26
  • 37
2
votes
2 answers

Filtering a PivotTable by Boolean

The source data for my Excel PivotTable looks like the following (this is a simplification): id name score 1 john 15 2 james 2 3 pat 14 4 jake 12 ... I have a PivotTable that uses this as a data source. Now, what I want to do is have the…
Kurt Spindler
  • 1,311
  • 1
  • 14
  • 22
2
votes
3 answers

Load contents of CSV file to array without opening file

I have a requirement to collate over 6000 csv files into a single csv document. The current VBA process is: 1. Open individual CSV data file 2. Load contents of file to array based on number of rows 3. Close individual CSV file 4. Process array In…
Benny Muller
  • 21
  • 1
  • 1
  • 2
2
votes
1 answer

Display Co-Ordinates

Cell A1 has top left coord of box, A2 has bottom right coord of box, how do I get A3 to display all the coords of the box in csv format? Ex: Cell A1 = (24,20) Cell A2 = (26,19) How to get this?: Cell A3 =…
Daniel
  • 59
  • 1
  • 7
2
votes
0 answers

Excel web query output control

Excel for Mac 2011 Version 14.2.4 (120824) Mac OS X 10.6.8 This web query file WEB 1 http://finance.yahoo.com/d/quotes.csv?s=SGOL&f=sn Returns this text into a spreadsheet cell. SGOL,"ETFS Physical Swi" What I would like to know is how to get the…
Beast Of Bodmin
  • 91
  • 1
  • 7
1
vote
1 answer

Selectively merge Excel rows and delete original rows

I have a Microsoft Excel spreadsheet (Mac 2011). Some rows have data in columns A, C, D, E, F, and G. I will call these rows PARENT rows. Other rows have data only in column B. I will call them CHILD rows. Each CHILD row is actually a subset of…
Spartanblogger
  • 271
  • 1
  • 3
  • 9
1
vote
2 answers

Excel 2011 (Mac) vba: text encoding fails when importing text files as QueryTables

I need to import text files to Excel sheets. The text files come both from Macs and PCs and contain characters from various languages. For Excel 2004 (PC) I have successfully used vba code like below for converting Mac-coded text to…
rolf
  • 51
  • 1
  • 6
1
vote
1 answer

VLOOKUP not working in excel for MAC 2011

I have a problem when using VLOOKUP in excel for MAC 2011. I am looking up for a value two column in different sheet, Column A is the one I want to check, Column B is the reference. =VLOOKUP(A1, Sheet2!$A$1:$B$1000,2,0) Some of boxes in Column A get…
pill45
  • 599
  • 3
  • 8
  • 23
1
vote
1 answer

Excel 2011 vba: How to loop rows of a column and multiply all rows by a single value?

I just wanted to get 2 columns (imagine they will host values such as numbers for x and y coordinates) and divide ALL values (aka rows) from column (let's say) A(for x) by a certain value in the column C. And I'd like to do the same for column B…
victorwestmann
  • 173
  • 1
  • 12
1
vote
1 answer

Prevent inclusion of sheet names when adding a name for range of cells with vba

I'm working with some data on Excel 2011 for Mac (version 14.3.1) that I need to graph and add more data later on. To do that, I'm using names for ranges as it is explained here. Basically, create Name ranges with the formula…
Antonio Nó Rodríguez
  • 53
  • 6
1
vote
0 answers

VBA compile error: Method or data member not found with a Button on Mac

I have a vba script working on Windows (office 2007) that i use now on my Mac (Office 2011). Everything works fine on Windows but i have a trouble with a button that doesn't run. When running, i have a Method or data member not found error and the…
manu
  • 49
  • 7
1
vote
1 answer

Run-time error '5' upon CSV import (Excel 2011, Mac)

I have been crawling the site for solutions to my problem. I use Excel 2011 for Mac OS X 10.10.5. My situation is this: I have a bunch of CSV files that i need to import into Excel for further statistical analysis. Here is an example of one of my…
emilhoeck
  • 11
  • 2
1 2
3
…
10 11