Sort using 2 different parameters

M

mabbutt

Hi

I am new to this forum so I hope this is in the right place.

I am trying to sort numerous values using 2 different sort parameters.

Then display the returned data.

I have attached a file with the data I am trying to sort as it i
easier than trying to explain !!!

On this sheet I have explained what I am trying to do
 
D

Dav

It is still not entirely clear what you want! but if you select all your
data and choose data_sort from the menus you can sort by up to 3
columns, I would have thought all you need to do is choose the
appropriate columns and sort!

Regards

Dav
 
M

mabbutt

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.
 
N

notawahoo

I'm not completely sure I understand your dilemma, but maybe this will
help: You almost answered your own question with "there must be a way
to filter them" -- there is indeed! Choose Data / Filter / Autofilter.
This will put a drop-down arrow at the top of each column. Click the
drop-down arrow on column B, choose Y, and voila, only the rows that
have a Y in col B will be showing up. The drop-down arrow for col B
changes color to remind you that you've filtered that column. You can
then highlight all the rows numbers that show, and copy-and-paste them
onto a new worksheet or new workbook so that you have only the rows
with a Y.

Hope that helps,

Nancy
 
M

mabbutt

I can do up to the point that you describe but then that still leaves me
with the values that don't have Y next to them.

I need both you see and don't really want to have to scan down the
entire list which is 3500.
 
Top