I’ve got a database that consists of 12 identical worksheets (same rows and columns, different cell values), and I want to rank each cell in comparison to the same one on on the other worksheets. For example, I want to see how C3 on sheet1 ranks among all the other C3’s.

I tried the rank() function, but I can’t figure out how to enter the array because it’s unattached. Any ideas? Thanks in advance.

It’s a simple problem, with most likely a complicated answer. I have a series of data that is in auto-sum, I want the greatest value to be ranked first and the lesser value, which may be negative, to be last. The ranks go from 1st to 17th.
This will be a contiguos series, I don’t want to keep resorting every time I enter something.