A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

learn more… | top users | synonyms (2)

1
vote
2answers
2k views

How to find specific text syntax format in a cell with an Excel function?

I am looking for a cell formula to find/identify/validate if an adjacent cell contains characters in the correct format. If there is a character "|", then it must be preceded or followed by any ...
0
votes
1answer
479 views

How to fill sequence in Excel from ranges given in another sheets?

I have an Excel sheet where two columns (say J and K) among data in sheet1 are as follows: J ------------ K 1 ----------- 25 26 --------- 50 101 ------ 150 Which are some ranges. ...
2
votes
1answer
650 views

How to format numbers in Excel column using the same exponent?

I have a bunch of decimal numbers in a particular column, for example: 1.123E-05 4.567E-06 8.910E-03 1.112E-07 I would like to format the column so that they have a common exponent, say E-06 like ...
0
votes
2answers
7k views

How to extrapolate or predict a project completion date

I have a few data points consisting of a percentage completed and a date. I would like to be able to predict the expected completion date based on the progress made so far. If this cannot simply be ...
0
votes
1answer
1k views

Drag Subtraction Formula for Excel : [ Aj − Fixed Cell ] for multiple j

Please forgive me for any analogous questions that have already been posted. I desire: A1 = A27 − B1 A2 = A1 − B1 A3 = A2 − B1.... So I input in A1 the formula A27 − B23 and then dragged it ...
0
votes
3answers
31k views

Comparing columns in two different excel sheets and if they match copying third column

I have limited working knowledge of Excel and I hope someone will be able to help me with my problem. I have two different work sheets (say F1 and F2) with last name in Column A, first name in Column ...
0
votes
2answers
224 views

How do I determine if a value is between range of values specified in two columns and return another value from the row where condition is true?

I have a value that I enter in cell B5. I need a value returned from column C and the corresponding row where the value is between minimum values in A10:A12 and maximum values in B10:B12. In the ...
2
votes
1answer
137 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
437 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 ...
1
vote
2answers
197 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
123 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
159 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
176 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 ...
1
vote
1answer
492 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
233 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 ...
7
votes
2answers
3k 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 ...
4
votes
1answer
3k 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
1k 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
521 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
326 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 ...
3
votes
1answer
2k 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
93 views

Pasting from several rows into a single row every 6th cell [duplicate]

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
147 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 ...
7
votes
2answers
64k 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
603 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
58 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
1answer
1k 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
41 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
1k 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 '...
4
votes
1answer
5k 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 ...
4
votes
0answers
2k 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. ...
0
votes
1answer
350 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
104 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 ...
2
votes
1answer
1k 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
117 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
2k 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
1answer
132 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 a curling tournament. The event will follow the Shenkel system: first match determined by general draw after ...
0
votes
1answer
54 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, ...
1
vote
0answers
65 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
782 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
53 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
745 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
2answers
3k 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
182 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 ...
1
vote
1answer
299 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
250 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
358 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
548 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
255 views

Excel access.Vlookup? IF?

What I am looking to do, is to 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, ...