I have a large file of 2000 lines and I would like to make 2 columns from 1.  
For example:
COLUMN A
HEW-FA282A

I have a worksheet that has 2 columns on it 1 is numbers and the others are
names. I want to be able to export a group of names from one of my programs
and then have excel match the name and dump the corresponding number into the
spreadsheet.  I beleive I can use vlookup but I am ...

Hi friends,
First of all sorry for my not very good English.
I have very strange problem, I have to import a data from excel sheet. I
have 10 columns and all the data is coming properly except the data from one

I'm trying to come up with an efficient formulae or function to calculate tax
The problem I have is that the tax is progressive. As below
the first 20,000 is taxed at 5%
the next 20,000 is taxed at 6%

I have a checkbox that when checked, places "Paid" and the date in a
cell.
IF(V12,"PAID "&TEXT(TODAY(),"mmmm dd")
Once the checkbox is checked, I'd like the date value that it places in

I'm having a bit of difficulty with sumproduct. I'm using it to work out
the amount of time something is spending in a given temperature bracket.
The data I have is a long list of temperatures taken at 30 second
intervals. What I've done is have two values (e.g. 120 & 139.9999) and

In using the XIRR formula, is it possible to use the date as "year only"
instead of month/day/year format ?

Hi all - I've received some terrific info here before, and after 2 days
of struggling have decided to try again.  Here's my problem:
I have a PivotTable tied to an ODBC data source (AS400 Table).  The
data is updated daily.  A simplified version of the table is:

Is it possible to 'round' a time to the next nearest 15min interval?
As an example in cell A1 I have a value that returns 2:07 PM (its formated
as h:mm AM/PM), but in B1 I wish to translate this to the nearest 15min
interval in an hour which is 2:15 PM, if the value in A1 was 5:39 ...

Using Excel, I want to look up a garmetn name in column A, then return a cost
per product from column B, C, or D, based on tier quantities purchased.
Example:  In one cell(A1) I know the garment , in another cell (A2) I know
the quantity purchased.

This is what I have in range A1:B7
Product_code    Date
ABC    06/01/06
DEF    06/01/06

I have a list of sales persons (the list varies from time to time), and want
to query which sales person has the highest or lowest sales. I would like to
get the return of the name and amount. Here is an example.
A                       B

I have this array formula:
=SUM(IF(Trades!$J$2:Trades!$J$170>=$M$23,IF(Trades!$J$2:Trades!$J$170<=$N$23,Trades!$L$2:Trades!$L$170,0),0))
I need the Trades!$J$2:Trades!$J$170, Trades!$J$2:Trades!$J$170 and
Trades!$L$2:Trades!$L$170 to be dynamic in lenght.

I have say Column A with Number values (1.0,0.25,0.50,0.75..... etc)
Representing Hours
In say Column B i have the time (hh:mm)
EG.

I have few dates in column A but it starts with an apostrophe sign.
Lets say the range is A1:A9 and here is a sample data
'6/5/2006 11:35:08 AM
'6/5/2006 11:35:08 AM