I need to add up cities and i cannot for the life of me figure out how to get
the cities added in a formula. PLEASE HELP ME . thank you

Can functions or cell references be used in a Comment. I have text
descriptions defined in a series of cells and would like to display a
description from one of these cells when I hover over another corresponding
cell. I would rather not write a VBA fucntion to implement this ...

i am new to using excell and my accountant has created a spead sheet for me ,
i was wondering can i set up a page so that the information i enter is done
on its own page and then put in the speadsheet behind the scenes
a bit like entering you contact details then it creates a ...

First off this question is not for the feint of heart. I know my way around
Excel pretty good but what I want to do is but very tricky and possibly
impossible but please someone prove me wrong. Here is the deal I have this
table of data from A1:F1000 that I need to retrieve data ...

I have two different files, both use the same unique identifiers. How can I
ascertain which records are missing from the smaller file.
For example:
File A, has 28,225 different records.

I want the value of a sum of few cellls to not exceed 50. Example ; Sum
(A1:E1) will show in F1 cell the value of 56. Can I make F1 cell shows
the value of 50 instead of 56. Tq for ur kind help.

Hi, I need your help. I have 2 spreadsheets, one with the data and another
with references to the data. If a make a change in the
data, in the spreadsheets with the references no changes its values. I don't
want to use the manual way, that is to say, press the

Novice Excel 03 user.  I have daily production totals in row 6 starting in
column C and going across.  In row 83 I would like to start a weekly sum of
the data from row 6.  What can I do so that when I sum C6:C10 in C83 I can
copy it to D83 and sum C11:C15?  I believe that I need ...

Columns used to display alphabetically left to right.  It changed to now
displaying numerically left to right.  How do I change back to alphabetically?

Hi, I've read through a few posts that are close to what I'm trying to do but i can't get it to work.
I'm constructing a fantasy F1 spreadsheet while i'm bored off work sick.
Sheetnames in workbook DriverSummary, AUS, MAL, CHN, BHR,.....for each round/country of the season.
Each ...

I have a column (D) with the following formatted data
0908-1234
0208-0691
0903-0256

I have a list of names (Column A) and a list of employee numbers
(Column B).  I have a separate worksheet which I want to replace
employee names with their numbers for confidentiality.  How can this
be done automatically?  Thanks in advance for your help!

I am trying to automatically place Members in a Group depending on their
Score, i.e
If the Score is a value from 1 to 13 then Group A,
If the Score is a value from 14 to 26 then Group B,

For example for a chart like this:
Procedural and diagnostic code.....40 (Frequency)
Provider information....9 (Frequency)
Others .....4 (Frequency)

Hi all, I'm new to Excel, having used MS Works for a customer list/database
for many years. I'm trying to decide whether it would be best to have:
1. A single Excel workbook with my entire customer list on one worksheet
or