Ranking Only Visible Cells

Giganews Newsgroups
Subject: Ranking Only Visible Cells
Posted by:  Jim
Date: Thu, 12 Mar 2009

I have a spreasheet with store numbers in column A and the store's sales in
column B.  Example:

1    $500.00
2    $497.38
3    $557.15

etc.

There are 70 stores but only 64 of them are OFFICIALLY generating sales.  I
have hidden the stores that are generating sales UNOFFICIALLY and want to
rank the visible stores only.

Is there a way to rank only the visible cells?  The hidden stores are
scattered throughout and will become "official" at different times, so
"hard-coding" the formula would be a pain (there are many of these
spreadsheets with different information).

Is this even possible?

Thanks!

Replies