I've got a table with columns of Sales Reps names and their Total Sales.
I want to create a new worksheet that has two tables - one of the names of
the Reps with the highest sales figures and one with the lowest. I want to
be able to vary those figures - so will need to keep them ...

Hi! I want to use the PARETOINV function in Excel 2007.
But there is no description on how to enter the parameters
or which parameters to use between the brackets.
PARETOINV()

I entered the following
=QUOTIENT(PRODUCT(A1:C3),G1)
where A1=3, C3=468.1 & G1=74.8151
the answer should be about 18 but excel gives it as 0

Let's say I have a text called "Text" in column A1:A3.
In column B1:B3 I have a formula counting number of
square foot. In colum C1:C3 I want to output the text
in column A combined with the output of column C.

I have a table that looks like this:
----------------------------
   A   B   C   D   E
1.                       8

I have a spreadsheet that contains text and time information such as below:
    a       b       c
1  north  high  5:21
2  south  low   6:42

I'm looking for a formula that can calculate the sum of a number of
rows given. In the example below the formula should output the sum of
the figures from the last 7 rows (starting from the right to the
left).

I have a spreadsheet which is twenty fields (cells) which are all
lookups from twenty different spreadsheet "tables".  So this main page
holds info from 135 thousand plus lines of data, all of which could not
all fit onto one spreadsheet.

I created a pivot table but the end result has many empty blanks and
unecessary totals, please does anyone know how I can sort and or filter the
columns without messing up my data. I need just clean rows and of data
without the spaces and the total. I have 20 columns and ...

I have the language set on Eglish (Australian) but trying to format cells to
show date as 08-May -2008 for example.
NormallyI would type 08/5/08 and it would formated as above. But now if I
type that in it thinks I have typed month in first - like US mehtod. How can

need for projected csah flow report.thanks

I have a spreadsheet with B9:B39 containing the numbers 1 to 31, B4 =  a
month and B5 =  a Year.
The month and year cells are validated so the user chooses "April" etc from
a drop down list and likewise "2008" from a dropdown list in the year cell.

I need to find the smallest number in a column which may have the
range from 0 to 9 but need to exclude 0 ie: strokes in a game of golf
so that I can calculate the lowest number of strokes taken. Zere means
that they have wiped the hole and therefore cannot be used.

What i want to do is double click on a calendar date(Monday May 12th) and
have a new sheet pop up. Its for budget purposes. Be able to click on a date
and then have all my finances pull up for that date is this possible?

Microsoft 2003 - I have to compare data extracted from one application to
data extracted from another application and resolve all discrpancies between
the two files.  Any ideas on how to do this?
The file has 8 columns - 4 from one application and 4 from the other