I have some datas in a sheet named "2001" of an Excel file(work book) named
"orders", the same is located in "C:\LOCAL"
My MD is in need of the same data but I am affraid if he may delete or alter
any data in that file. So I need a separate file other than the above - may

How can we tranfer data from IBM iSeries in MS-Excel 2003 with SP2? But I am
having option of transfering data from iSeries in MS-Excel 2003 with SP1 in
Menu (Data). Could anyone guide me.......
Best Regards,

(P.S. This is more readable with Courier font.)
I'm using data from a CSV file to make a Pivot Table.
My data is sum of widgets per year.
In the Pivot Table, I have the years across the top as column headers

i have a problem when wanting to calculate time using 24 hour clock, i have
attached a simple example:
These are the columns & row 1:
A               B              C                             D              

I am trying to put an IF & AND function into Conditional Formating but I am
not getting the required result.
I am trying to express "If D7 = Yes AND D8=0 THEN Change Font in D8 to Red"
How would I express this in Conditional Formatting?

I've read the posts on using "sumprodut" instead of "sumif", but I'm either
doing something wrong or using "sumproduct" isn't the right tool for what I'm
doing. Here's my problem:
If $A$8:$A$23 = 660010 and if $B$8:$B$23 = "Ideation", sum $C$8:$C$23.

I have "false" as my range_lookup in VLOOKUP.  It is still returning a match
to something that is not exact.  Am I doing something wrong?
Thanks!

When I use very small numbers with LINEST it returns zeros. Please help me
solve this problem

I am sure there is a simple answer out there...
I am using Excel to create a kind of workbook for my users to fill
in...because I have a few lists with checkboxes, there are columns of varying
width - after all the basic info such as name, date, project, etc is filled

Hello all... not sure if this is even possible to do in Excel but I
have a worksheet where I am trying to calculate an answer using
multiple conditions. Column A has years of service (1, 5, 10, etc etc
etc). Column B has hours per week (35 or 37.5 depending on where a

Hi, I have an Excel worksheet and I am trying to find a way to delete
selected lines via VB, can any one help me please. Thanks

I have two worksheetsa with information that is the same but the text
is same
foe example
worksheet 1 has a column of countries e.g United Kingdom

I am using Excel 2003
I am trying to add conditional format to a column of cells with the
condition refering to a date in the corresponding cell in the previous
column.  Is there a way of copying this conditional formatting to other cells

How do I do the following:
Column B (add)
Column C (minus)
Column D (total of A minus B)

Here is my current formula:
=IF(B41<29,"$.03",IF(B41<=34,"$.03",IF(B41<=39,"$.06",IF(B41<=44,"$.09",IF(B41<=49,"$.15",IF(B41<=54,"$.26",IF(B41<=59,"$.42",IF(B41<=64,"$.56"))))))))
The formula is actually 8 and it is allowing it, but anything after
that it wont. I need to add 3 more. ...