Hi,

We're trying to find some trends in some data that we've got, we've got a series of numbers from 1-98 ordered (psuedo-randomly) by users and I've put that into columns.

I'd like to find any patterns in the data, ie if two users have put the same numbers in the same order - but not necessarily in the same position.

ie, if one user has the sequence 5,88, 13 at the start, and another user has 5, 88, 13 at the end, we'd like to discover that.

Another way to think of it is, if we were to chart the data in a line graph, I'd like to find any areas that either overlap, or could overlap if you shifted one of the users data along the horizontal plane.

I'm thinking this is too complicated to be solved by a function, but perhaps there's a macro out there that could do this?

I'm not afraid of writing a complicated formula if someone will point me at the right functions to look at.

Cheers,

Chris