I wanted to do the following -
I have a master database of about 2000 items (with details against each
name). I also generate smaller lists (only names) every week that comprise
items from this list. Now is there any way I can pull out other details about

Not sure if this is the function for the job but I need to have SUMIF
compare values in multiple ranges/columns and add if the values match
in those columns
e.g.

Hi all, I am very novice with Excel and I have a problem that I don't
even know where to start with. I have two different Excel
spreadsheets
that have data for different television programs. I need to go

Okay , this maybe a tough one....but I hope its solvable , basically I am
uploading products to one of the more popular websites , they have various
columns , one of which is comment , in this I can type in up to 1000
characters but cannot contain "<" or ">"

Any suggestions?
Some of these rows only need a few columns updated, and others need
all of them updated. If possible if say row 800 column 'S' is filled
in the access DB but is blank on the excel spreadsheet, if possible i

Is there a way to set up a drop-down list that shows numerous cells, yet only
fills in one cell?  (ie...I have a list of banks in one column and the
account numbers in the next column.  I'd like to see both when I pull the
list down, but only the account number fill in when ...

This is probably very easy for Excel gurus, but my expertise is in
writing websiters and not so much in Excel---so I need a little help
with this one.
In English, I need a date formula to display answer in a particular

I have an excel file which i have sorted by column 'Ordered Item'.
Next to this column is a 'Price' column.  The 'Ordered Item' Column
may have duplicates.  What I need to do is put a subtotal beside each
group of 'Ordered Items' (even if they are single items).  How would I

I am trying to perform a lookup but also do arithmetic calculations.
=SUM(B5 -3%(LOOKUP(B5,D5:F17)*?
B5 = 1000
? IS THE VALUE OF MY LOOKUP FORMULA

I am looking for a calculator template that will allow me to calculate the
amortization for a line of credit where the starting balance would be $0 and
increased by $3000 per year (annual payment), interest rate of 7%, term of
up to 30 years. I would like it to calculate what ...

I'm trying to insert a background into a worksheet. When I do tis I only want
a single instance of the background and not the multiple images that I am
getting. Is there any training for this?
Thanks for any help,

Newbie here. Any advice on which online Excel tutorials are deemed best
by those on this NG.
Thanks!
Bert Morris

I was just doing some investigation and found that the normsdist
function errors when given a value higher than 2147483647.  I worked
on this when doing some calculations for options based on Black
Scholes and I thought it might be helpful for others running into

I have a folder that has about 100 schedules all of them are Excel files.
What I like to do is to have a macro that will change a certain part of the
file name in the folder by using Excel via a command button.  For example I
have a file name "RTX (INC).xls"  I want to retain the ...

Okay i pretty new to Excel (office version 2003) , i need to make and save
some tab delimited files , No probs , but when i load them back up , for
example a long number such as :- 5031366015174 saves okay and is fine in its
delimited text file , but when i load the tab delimited ...