Hi all,

I've been wrestling with a problem for some time now and I think it's time
to ask for some professional help :(

I've got a column from J3:J1000 that contains information that can be either
text or a measurement value (this data may contain 1 or several of the same
entry) .

What I am trying to achieve is a function that looks in this column cell by
cell and generates a dynamic list of the 1st occurrence of any data
appearing in that list (starting at T3 and moving down).

What I want to do then is a simple ranking of the list to determine the
worst offender. This bit is simple, but I just can't seem to work out how to
generate a dynamic list in the first place :(

Any ideas or pointers would be welcome.

TIA

Dave