I am not sure what layout you mean. Take a look at my VBA version,
http://www.xldynamic.com/source/xld.LeagueTable.html, and see if the
results
format is what you mean.

That's the exactly the perfect layout, Bob !! In fact it turns out I
have been using this spreadsheet of yours and didn't even know it. I
really like it - its just that I can't use it on the work pcs because
they won't allow macros to run :(

Thanks again for the helpful responses - look forward to more news on
the subject...


--
gdh82
------------------------------------------------------------------------
gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213