LIST unique values

  • Thread starter Thread starter James Gilbert
  • Start date Start date
J

James Gilbert

Hi all,

First, I need to be able to list the unique values in a column. Then I am
going to have to retrieve info from surrounding columns for each unique
value. for instance

4/5/03 1747 m 3 r b m
4/5/03 1820 m 4 r b f
4/5/03 1825 r 2 r b m
4/6/03 1605 miss b m
4/6/03 1606 m 1 b c m
4/6/03 1625 miss b m
4/6/03 1646 m 5 r b m
4/6/03 1700 END
4/7/03 1615 START
4/7/03 1632 r 3 r b m

now my unique values will be '3r', '1b', '5r' etc, and I need a table
containing the value, and a list of all the dates I saw that individual
(e.g. 3r was seen on 4/7/03, 6/7/03, 12/7/03 ...)

can anyone help, especially with the list of unique values ?

thanks in advance,

James :)
_______________________________________________________________

James Gilbert
t: (+44/0)1223 336638 m: (+44/0)7731 389380
Large Animal Research Group *small animal division*
Dept. Zoology, Cambridge University, Cambridge CB2 3EJ
_______________________________________________________________
 
Hi
not sure about how your values 'm 3 r b m' for example are stored?.
Separate cells, one cell. Also how do you identify unique values?
 
gosh! it looks different from when I posted it.

As you've quoted it, it's space delimited, i.e. each letter ('m b r') is
in a different column.

But that's no problem since if I want '3r' to be in one column I can
create a new column and concatenate them.

any ideas?

James
_______________________________________________________________

James Gilbert
t: (+44/0)1223 336638 m: (+44/0)7731 389380
Large Animal Research Group *small animal division*
Dept. Zoology, Cambridge University, Cambridge CB2 3EJ
_______________________________________________________________
 
Hi James
if you like, email me your file and I'll have a look at it
email: frank[dot]kabel[at]freenet[dot]de
 
Back
Top