I'm playing with Google Spreadsheets at the minute, and it appears to be really clever (maybe it's not, maybe Excel is as clever- I just don't use Spreadsheets!)
This is my spreadsheet (it's public, you can edit/play/etc...)
Basically, I want to remove the *'s from the GBHI Data cell's and pull out all of the Sheffield Kings results.
You can see what I mean in the Kings Web Data sheet, but I've bodged that and just pasted the Values.
Surely this must be possible? Any Excel/Google Spreadsheet guru's around?