Item Lookup

[mndpy]

I need help with formula. I have my scheduling on excel and I have it set
like this:

A B C D E F G

ID# Name RGY S/D Zone

In the zone column it states number 1-8

I have three sheets set up like this, 15 codes, 16 17 codes, 18 codes. Based
on how old the people are.

I want to list on a separate Sheet in order all those (Names) that are
scheduled in zone 1 and if possible alphabetically.

Any help would be appreciated.

 

[OssieMac]

I don't think that you have provided sufficient information for anyone to
create formulas to do what you want. However, have you tried using
AutoFilter. It is very easy to use (look it up in Help) and you can copy the
visible cells and paste them to another worksheet.

 

[mndpy]

I have tried the Auto Filter. It still doesn't want to work. What other kind
of info do you need?

 

[OssieMac]

Some examples of your source data and an example of the output you require
might help but until I see it not sure. I can't picture what it is that you
are trying to do particularly if you can't filter the data with AutoFilter to
separate your output from the source data.

 

[mndpy]

Well I got it to work using this formula,

=IF('16 17 Codes'!G7="1",'16 17 Codes'!B77," ")

It is displaying the correct info that i am asking for now however I would
like it to also alphabitize the names and eliminate empty rows from where it
is pulling from. I was thinking something like this but it doesn't seem to be
working. Any ideas?

=IF('15 Codes'!G7="","",IF(LEFT('15 Codes'!G7,3)="1",'15
Codes'!G7+ROW()/10^10,""))

 

[OssieMac]

Sorry. Can't help because I can't picture what your data looks like