@googlegroups.com
>
> > I have a spreadsheet populated with game score data imported from an
> > external source (so I can't change the format!) that consists of
> > between 2 and 4 cells each containing a name (variable length) and a
> > score (always 3 characters)
cell#3 cell#4
name1 : 0.0 sjharris27 : 1.0 name2 : 3.0 anothername : 2.0
Or it could just look like this;
name4 : 1.0 sjharris27 : 0.0
The other names will vary from one game to another but there will
always be one with *my* name - sjharris27. What I would dearly like is
a formula I ca