Neil

Put like data in like columns e.g. competitors in a competitors column,
years in a year column. i.e lay out the sheet so years are above one
another. rather than in the same row.

Can't see any problem with different numbers of events in different
years. Assume there is a separate row for each event, for each year.

When you get the data into the format suggested by Debra, you'll have
plenty of extra tools for analysis, pivottable usually being the most
useful.

Cheers,


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=529822