**1**

vote

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**3**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**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.
...

**0**

votes

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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