Excel 2003 SP2
Three columns in a data sheet: Country, Number B, Number C.
In a summary sheet, I have a list of the countries and want to create a
formula which calculates the B-weighted average of C, for each Country in

I have a hierarchy of 4 excel spreadsheets that link to one another.  WKSHT 1
is the original information that gets changed manually, WKSHT 2 gets its
information and is updated by linking to information in WKSHT 1, WKSHT 3
updates from WKSHT 2, and WKSHT 4 updates from WKSHT 3.  ...

It would be useful to have a search tool implemented in Excel that
would allow the user to select from a list, afterwards the user would
be transported to the cell from the list. Does anyone know hoiw to
implement this.

now how can I chart in the format I described in first post?

Have product sales data spreadsheet that I need to produce chart for sales
presentation.
Data includes sales transactions spread over several months. Sample:
Transaction 1 - July 20  $12,000

Is there any way to show gridlines and use colors in cell?
If you use fill color option, gridlines vanish immediately?
Background option could be one, but how to get real colors there.
Thanks

Please can someone advise me on how to do the following:
I have an excel spreadsheet which has the following columns
Name     Address     Town     Postcode
What I require is some way that allows the user to choose a town (Towns

One of my file is opening as Read Only, for me and everyone, even after
I closed the file.
How can I sort out this?
-Dileep

Hope you can help! I have 11 employee tables which cover their shifts for
the year.  I would like to create an overview table of a given day showing
who is working.
I have used INDEX & MATCH before to retrieve the information I need from a

I've just used calculated items for the first time to calculate a
variance between two specific ledger types (Ledger Type being one of my
column fields).
This works nicely, but it fills in a zero for all rows regardless of

please help

HI ALL,
I'm trying to multiply cells d5-d9 by cells a5-a9 and
put the answer in cells d14 - d18 ( using caps )
I have tried     =(D5*A5)  

I need to find a formula that's on the sheet I'm working on - I don't know
what it is or where it is and it's causing problems.  How can I display all
formulas on the sheet I'm working on?

I have Name, PO Box, street address, city, state, zip across a row in 6
seperate cells/columns.
I want to have this format in 1 cell:
Name

Although I have just posted I thought this might be worth a separate
posting.
Over the last few months I have learnt some of the basic formulas used and
at times have had the idea of combining different formulas together as I