I work for a service company.  I am working with a list of sites.  Most of
the sites that have mulitple visits.   I need a formula that will go through
the column and allow me to create a list of all sites that have more than 3
visits to them or repeat 3 or more times.

I am trying to calculate safety stock using an exponential distribution need
to calculate the safety factor for a desired service level

I was wondering if anyone knew of a way to get excel to list the frequency of
an alpha numeric entry and list the frequency of that particular value beside
it.  For example,
33344asdf    1

I have a cell (C3) in a 'Totals' worksheet summing the contents of cells in
other worksheets (named APPL, ACRF, OMAC, OPNG & ACRD) by using the formula:
=sum(APPL!C72+ACRF!C72....)  Simple, so far.  I want to be able to edit the
row number - 72 - globally by refencing it in ...

I have a list of hundreds of numbers.
I have averaged the numbers, and the average is about 100.
I want to see what impact each value has on the average.
To be overly simple.  If I had a list of 1, 2, 3, 4, 5, 100.  The average is

I have a spreadsheet with many numbers and I would like to have a cell that
shows the largest value of all the cells.  Any ideas?

I have a column of dates in Column A that generate with a formula like so:
A1 "=O18" (This is currently a date that is inputted by the user.
a2 "=b1+1"
Column b is like:

Apologies in advance - text functions are not my strong point.
I'm introducing a unique identifier to an old data set.
Previously, total transactions would be tagged with a staff member's ID,
e.g. 123a.

I have a spreadsheet which you can view here:
http://www.mediafire.com/?en2ywr1tjs8
If you go to the 'Gary Results' Tab, you will see that in cells C3:C5 it is
pulling 'Rhydian Roberts' through 3 times from the 'Gary Scores' Tab.  

Got a problem that's driving me crazy... I'm using Excel 2007 and the
compatibility check for backwards-compatability when saving as .xls is
interrupting my automated report generator. We've got a bunch of
report templates that I've set up that loop through an input list,

I want to make a cell display the earliest, and/or latest date in a list of
dates in a column. That way I can have a cell show the date range of a list
of dates from the earliest to the latest. I'm a rookie at Excel, I know just
enough to get me into trouble. Can anyone help me ...

In Excel 2003
I am using CF (to change cell colour) to identify differences in cell values.
However I would also like to incorporate into the criteria differences in
text e.g. upper case / lower case (not font) and/or strikethrough.

If I have a list of say, 100 values (Cells A1-A100), and there many
duplicates, is there a way to create a "master" list elsewhere that does NOT
contain the duplicates.  Thanks.

I have a spreadsheet with several hundred records in Excel 2000. I have
autofilter turned on, and I've filtered by one of my headings. Now I want to
count the rows that are left - should be easy, right?
However, when I use the COUNT function (=COUNT(D1:D351)), I always get 0.

I have a masterfile worksheet that has all the names and catergories listed
in rows/columns.
I have worksheets that have the same information but in column G the
information is populated with the information I want.