Excel question: How do I rank data from multiple worksheets?

get rank
EdCotaMan2 asked:

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.



Comments (1)    Posted in Software    

Subscribe RSS 2.0 feed. Leave a response, or Trackback from your own site.




One Response to 'Excel question: How do I rank data from multiple worksheets?'

  1. PCS_Help - July 7th, 2010 at 5:31 am

    This should work for you

    =RANK(C3,Sheet1:Sheet12!C3)

    Use that formula on each sheet and you will get a ranking for cell C3 on each sheet. Duplicate this for each cell you wish to compare.

    For immediate help go to


Leave a Reply