gspot analyses any video file and informs you what codecs are required to play it and whether you have this codec installed on your computer.
Windows only, can be found here:
http://www.headbands.com/gspot/
I've finally been able to play some .avi files which friends have sent to me ages ago!

Royston