move cells based on partial-content.

Hello all,

I have a list of about 5000 cells, i've been tasked to organise them based on whether they contain certain strings.

They are a series of ID numbers, each one starting with either "N07-" or "N08-" followed by a 5 digit number.

What i need to do is sort them into columns based on the N0x- part, and then by the 5 digit number, in groups of hundreds.
For example, there would be a column for all the numbers that fall between "n07-00100" & "n07-00199", another for all those between "n08-0500" & "n08-0599", etc.

What i was thinking was to have it loop through the range, moving any matches to a column which is offset based on the first 3 digits of the numeric part.

Is this at all possible?

I've included a sample sheet to clarify what i mean, i hope its of some use.

Thanks!

Hi

This gives a slightly different heading scenario, but see how it goes.

Please Login or Register  to view this content.

rylo