Hi

Lets try and make this a bit clearer.

In column A I have 3500 numbers in numerical order (starting at 12746
and ending at 45981).

The numbers in column A represent a user. Some of these users are
Disaabled and some are not.

If they are disabled then there is a 'Y' in column B next to it.

I have then got a 1000 numbers (users) ranging from 12746 to 45981 that
I need to sort into two categories.

Disabled and enabled.

So I have used the sort function to get them in the correct order and
then sorted them using the Y in column B.

What I can't do is extract them so that all the other numbers that are
not referenced (2500 of them) are not in the list with them !!

I could obviously go down the sorted list picking them out but there
must be a way to filter them surely?

I have tried using the VLOOKUP function but with no success.

I hope this is a little clearer and somebody can help.


--
mabbutt
------------------------------------------------------------------------
mabbutt's Profile: http://www.excelforum.com/member.php...o&userid=34294
View this thread: http://www.excelforum.com/showthread...hreadid=540598