|Subject:||Ranking Only Visible Cells|
|Date:||Thu, 12 Mar 2009|
I have a spreasheet with store numbers in column A and the store's sales in
column B. Example:
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?