**2**

votes

**1**answer

63 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, ...

**0**

votes

**1**answer

110 views

### Excel 2010 - Show cell contents - wrong number appearance

I was trying to create a simple function in Excel VBA editor. When I click on a cell within the certain range, I want to copy its value into another cell I have set.
Private Sub ...

**0**

votes

**0**answers

35 views

### Dynamic HTML Anchors in MSExcel that become functional when saved as HTML

MWe post a daily schedule from Excel into HTML and upload to a web site. It lists the schedules for over a hundred staff. I want to add formulas that would automatically insert HTML anchors based on ...

**0**

votes

**2**answers

58 views

### having cell show a paticular number if the answer in the formula in the cell is a certain number

so I don't know if it's possible but I want to have a cell show a particular percentage in the formula I put in the cell comes up with a particular answer. for example, if I put in the formula =6/3 ...

**1**

vote

**2**answers

55 views

### How to use the outcome of a formula as the value for Vlookup or another IF formula

Ok I will try to explain my issue effectively. I am making a GPA sheet in which the value out of 100 is computer in to a GPA value and then in to a letter.
In cell N5 i have the value of all their ...

**1**

vote

**1**answer

76 views

### Moving Data from One Column into Six Columns

I have an Excel sheet that has six columns that are currently all combined into one column. I need to separate them out but the issue is the first column is words that sometimes are one word and ...

**0**

votes

**1**answer

53 views

### Multiple if functions

I have problem I'm hoping someone could help me with.
I have five different text values in 5 cells. I am trying to combine these values into one cell with a comma in between each. However the trick ...

**0**

votes

**1**answer

68 views

### Excel: resize chart sheet

I can create a chart sheet in Microsoft Excel 2010. I wish to resize the chart so that the proportions fill my wide screen. I right-click the chart and select Format Chart Area. Then I select the Size ...

**1**

vote

**0**answers

70 views

### Select split rows in Excel and have them print on the same page

I'd like to select several rows in Excel from one sheet, that may not be next to each other and when they are printed using the "Print Selection Only" option, show up on the same page, instead of one ...

**0**

votes

**0**answers

58 views

### Summarizing data in Excel

I'm working on rolling-up a series of charts. I'd like an easy way to summarize by category.
The original looks like the sample below but by week for the entire year.
I want to know all of the AD ...

**7**

votes

**2**answers

266 views

### Formula for finding 'near perfect' matches [duplicate]

I have a list of +-8000 items which is the result after applying numerous techniques to remove duplicates (the list started at over 10000 items).
I now have the following issue -
Example
1. Jack ...

**1**

vote

**1**answer

549 views

### How to make Excel formula work in all regions

I need to make a workbook operate in several regions that is heavy on Excel formulae.
I use the UK regional settings so the following Excel formula works fine using comma delimiter is normal for me.
...

**4**

votes

**1**answer

273 views

### ms excel find and replace @ symbol results in broken formula

I'm trying to search and replace in excel, the column is formatted as 'Text'.
Find: [@
replace with: @
Whenever this finds a match at the start of a cell i.e the cell contents start with [@
and ...

**1**

vote

**1**answer

154 views

### How can I connect to an InterBase database using Excel?

There is an InterBase database that I'd like to connect to using Excel. I have the database name, address, and login info. IB, as I understand it, is a form of SQL.
Using the SQL connect mode under ...

**1**

vote

**2**answers

95 views

### How to link a cell from one spreadsheet to another, dependent on the details in another cell.

I have a workbook with two sheets in.
To simplify:
On the first sheet I have a unique reference number in column A and a product description in column D. This sheet is "the master"
On the second ...

**2**

votes

**1**answer

405 views

### Use Excel Color Scale Formatting with Text

I use Excel sheets to track the status of tasks through a set of discrete statuses. I'd like to be able to format these automatically, with the start being red, the end being green and progressing ...

**0**

votes

**2**answers

52 views

### Pasting from several rows into a single row every 6th cell

I need to copy every 6 cells down horizontal to a new column
So that D3/E3/F3/G3/H3/I3 goes to J2/K2/L2/M2/N2/O2
And that D4/E4/F4/G4/H4/I4 goes to P2/Q2/R2/S2/T2/U2
And so on for sets of 20 rows
...

**1**

vote

**2**answers

54 views

### Need to create a padded, 100-character string in Excel

In Excel, I need a 100-character string so my data will upload to a database.
For example, if A1 has the text "workshop", I need Excel to show the word workshop followed by 92 spaces. If I have the ...

**2**

votes

**1**answer

9k views

### Concatenating Variables within Powershell

I'm trying to concatenate two variables within Powershell to form a complete file path and file name to save a text file.
I have two variables
$Log_path and
$Log_name
I'm trying to join the two ...

**0**

votes

**1**answer

231 views

### How to select all ActiveX objects in an area using a mouse in Excel?

Because of this problem with ActiveX objects changing size, I am not grouping my ActiveX objects in my Excel worksheet. Grouping them causes my solution hack to not work which is quite annoying.
...

**0**

votes

**1**answer

42 views

### Excel graph showing customer representation based on size of different businesses

I would like to represent in a graph the percentage of A, B and C customers in each business unit, taking into account the size of the BU (on the X axis).
Sales % A % B % C
...

**0**

votes

**0**answers

240 views

### Select Perspectives when creating a pivot table from a Power Pivot model

I've created a Power Pivot data model, and set up a number of perspectives. I know these can be used to filter the available fields when the data is accessed through other systems, but is there a way ...

**0**

votes

**0**answers

205 views

### Hiding a column from a pivot table without removing it from the chart

I have a pivot table with two columns: number of users who visited a website (impressions) and number of users who registered on the site (regs). The rows are for dates.
I want to visualize the ...

**0**

votes

**1**answer

37 views

### Adding the date/time (DD/MM/YY HH:MM) information dynamically at the end of ZIP file

I want to add the current date/time (DD/MM/YY HH:MM) information dynamically at the end of ZIP file when backing daily via IBM cognos export. Then How can I export CSV formatted them using script?
...

**1**

vote

**1**answer

524 views

### Can I output results of a MySQL query to a csv file via Putty?

I've typed the following code to output the csv file , but it shows an error
mysql> SELECT *INFO OUTFILE 'd:/student.csv' FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY ...

**0**

votes

**0**answers

18 views

### Need to find duplicate names in a column

Need to find duplicate names in a column but the name have been added with differnet formats.
Some names have been added "first name then last name " and others have been added "last name, first ...

**3**

votes

**1**answer

3k views

### How to change Excel Pivot table “Report Filter”s values cell formatting

My Excel is in Finnish, but don't let that bother you...
First Report Filter "Kupi" has only number values in my source table, for example 643203, 3533, 253244, etc. How ever in Pivot's "Report ...

**3**

votes

**0**answers

595 views

### Excel 2010 crashes: Excel.exe 0xc0000005 when trying to highlight from pivot table

One of our users uses pivot tables a lot. She often called me about Excel crashing from time to time without being able to reproduce the problem. Today we have found a way to reproduce the crash every ...

**1**

vote

**0**answers

24 views

### Microsoft Excel 2010 subtraction results in wrong answer [duplicate]

This issue does not care if you format the cells to numeric or not, but formatting them to numeric with 4 or more decimal places helps you see the issue without having to look at the Formula Bar.
...

**-1**

votes

**1**answer

136 views

### Excel 2010 VBA on-start macro execution - Error

I have been trying to create a macro to be executed every time I open the document. I tried to use the Open event, but it does not seem to be working. The code is below:
Private Sub Workbook_Open()
...

**0**

votes

**1**answer

78 views

### Are spreadsheet programs inherently unsuitable for “one row=one case” data?

Often when I'm working with large data sets, I structure the data in a way where every row equals one specific case. For example, in a psychological experiment, I input the data so that all data ...

**0**

votes

**1**answer

463 views

### Excel 2010 VBA - Make variable hold value after file is closed

Just like the title suggests, I am looking for a way to make a variable hold its value even after the Excel 2010 file containing the VBA code is closed, and retrieve it with its last value, the next ...

**0**

votes

**0**answers

26 views

### Need macro to delete rows by comparing multiple colomns

Below is the data
Workstation - Application
ABC - Adobe 10
ABC - Adobe 9
ABC - Windows 10
ABC - Windows 7
PQR - Adobe 9
PQR - Adobe 8
PQR - Windows 10
PQR - Windows 7
PQR - IE 8
...

**2**

votes

**1**answer

251 views

### Excel: Files without extension created

I don't know what happend, but I have an Excel file (test.xls) which is saved with random(?) name and without extension X times a day..
What does it mean? Is it created when the Excel fails? Sould ...

**0**

votes

**0**answers

72 views

### Excel or OpenOffice Table Summary: how to reconstruct a table from another, with “missing” values

I have a table of values (partial) with 3 columns: month (from 1 to 12), code and value. E.g.,
MONTH | CODE | VALUE
1 | aaa | 111
1 | bbb | 222
1 | ccc | 333
2 | aaa | 1111
2 ...

**0**

votes

**1**answer

672 views

### Shared Excel WorkBook is locked by another user

I’ve been trying everything; this is the last chance I have.
I moved folders and files from an old Windows Server 2003 File Server to a new FS (Win Server 2008 R2) with DFS and ABE enabled.
Now, a ...

**0**

votes

**0**answers

56 views

### Macro to manage sport ranking and calendar?

I need to write a macro (or a different easy way) to manage ranking and calendar for curling tournament.
The event will follow the Shenkel system
first match determined by general draw
after that ...

**0**

votes

**1**answer

44 views

### Highlight a row if one of four values is met

My spreadsheet can be up to 300+ rows per month, 12 Sheets one for each month.
I would like to highlight the entire row when it matches any of the four main accts out of 100. For example acct. 12345, ...

**0**

votes

**0**answers

274 views

### Microsoft Office 2013: buttons/icons/text disappear

A few days ago I opened my Microsoft office programs and discovered that they are missing the editing icons at the top, some of them will appear if you scroll over them, but not all. Also, in ...

**1**

vote

**0**answers

38 views

### How can I move columns based on the column header title to another workbook?

I have to average grades based on each objective for a new report card we have to complete this year. Column one has students names, each additional column will have the objective associated with the ...

**0**

votes

**1**answer

144 views

### Grouping and sorting rows in Excel based on single column

I have a list of families I need to sort by last name in column A. You can see that each child in the family has its own row. The problem is that when you apply sort by column A descending, it does ...

**1**

vote

**2**answers

44 views

### Excel Conditional Summing

I want to create a formula so that I can keep track of how many feet get out of a drill bit. The data will be arranged in this way:
I want to show results of the total footage drilled by:
Any ...

**1**

vote

**2**answers

234 views

### Excel - Best way to programmatically insert cell data

My spreadsheet has the following format:
(empty)
(empty)
(empty)
(empty)
(empty)
(data)
(empty)
(empty)
(data)
(empty)
(empty)
(empty)
(data)
What is the best way to insert data into the empty ...

**2**

votes

**1**answer

875 views

### VBA to move specific data from one column to another

I've tried requesting help with this before but have received no helpful responses.
I need a Macro/VBA that moves any word in red from column A into column C as a list.
However if the same word is ...

**0**

votes

**1**answer

98 views

### Check if sub string in cell match with other string from range of cells

I have a range of cells with these string values:
A1: text1
A2: text2
A3: text3
And a column with these other string values:
B1: text1 text2 sampletext
B2: text2 text3 sampletext
B3: text3 ...

**0**

votes

**1**answer

123 views

### Excel fails to open Python-generated CSV files

I have many Python scripts that output CSV files. It is occasionally convenient to open these files in Excel. After installing OS X Mavericks, Excel no longer opens these files properly: Excel doesn't ...

**2**

votes

**1**answer

114 views

### Excel VLOOKUP using results from a formula as the lookup value

I have a cell that I must remove the first 2 characters "RO" for each value in a column on a sheet called RAW DATA and put into a cell on a sheet called ROSS DATA. Some of the values in that cell have ...

**0**

votes

**1**answer

72 views

### Excel: Look up function for combinations of cells in a single column

I'm looking to find the number of times a certain combination of values appears in a single column, I was hoping to do this in Excel but I'm starting to think it may not be possible.
As an example, I ...

**0**

votes

**1**answer

96 views

### Cross-match a number of worksheets to one master worksheet

Hopefully the title is not too confusing. Basically, I have a master list of addresses and those addresses are listed in multiple columns (Column A - street number, Column B - street name, Column C - ...

**1**

vote

**1**answer

144 views

### Excel access.Vlookup? IF?

What im looking to do, is move stuff from one excel sheet, to another sheet in the same workbook.
We will call the sheet with the data the "suppliers list" and the sheet where i want it to go, the ...