Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Item Lookup
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Item Lookup
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. -- Regards, OssieMac "mndpy" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Item Lookup
I have tried the Auto Filter. It still doesn't want to work. What other kind
of info do you need? "OssieMac" wrote: 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. -- Regards, OssieMac "mndpy" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Item Lookup
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. -- Regards, OssieMac "mndpy" wrote: I have tried the Auto Filter. It still doesn't want to work. What other kind of info do you need? "OssieMac" wrote: 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. -- Regards, OssieMac "mndpy" wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Item Lookup
Well I got it to work using this formula,
=IF('16 17 Codes'!G7="1",'16 17 Codes'!B7:D7," ") 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" wrote: 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. -- Regards, OssieMac "mndpy" wrote: I have tried the Auto Filter. It still doesn't want to work. What other kind of info do you need? "OssieMac" wrote: 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. -- Regards, OssieMac "mndpy" wrote: 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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Item Lookup
Sorry. Can't help because I can't picture what your data looks like
-- Regards, OssieMac "mndpy" wrote: Well I got it to work using this formula, =IF('16 17 Codes'!G7="1",'16 17 Codes'!B7:D7," ") 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" wrote: 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. -- Regards, OssieMac "mndpy" wrote: I have tried the Auto Filter. It still doesn't want to work. What other kind of info do you need? "OssieMac" wrote: 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. -- Regards, OssieMac "mndpy" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to lookup item for Qty? | Excel Worksheet Functions | |||
Multiple Item Lookup | Excel Worksheet Functions | |||
Multiple Item Lookup | Excel Worksheet Functions | |||
Item numbers result in item description in next field in Excel | Excel Worksheet Functions | |||
Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions |