the formula is fundamentally the same but you are looking at data on a
different sheet

so All the ranges $a$1:$a$1000 for example wil have to be name of data
sheet!$a$1:$a$1000

eg sheet2!$a$1:$a$1000

I think I have changed everything in attached

Regards

Dav


+-------------------------------------------------------------------+
|Filename: Leaguetable1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5010 |
+-------------------------------------------------------------------+

--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=560172