Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

2
votes
1answer
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
1answer
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
0answers
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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 ...