Need a formula that will lookup one item and return a range of ite
 

Help!
I need to look for a group number and list the contents of the group as a
list. Then I need to proceed to the nexrt group number etc. without any
spaces in the new list.

Any help is appreciated!

Need a formula that will lookup one item and return a range of ite
 

Hi
see:
http://www.rondebruin.nl/copy5.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"curiouz" schrieb im Newsbeitrag
...
Help!
I need to look for a group number and list the contents of the group
as a
list. Then I need to proceed to the nexrt group number etc. without
any
spaces in the new list.

Any help is appreciated!

Need a formula that will lookup one item and return a range of ite
 

We would need to know the layout of your data to even attempt to provide a
formula. Also if you want to return a list, where would the list be
displayed. Since you are posting in programming, are you asking for a
worksheet formula or do you want a macro?

How is a group identified
how are the members of a group identified
how do we know what group to look for

It sounds like you might already have the list you need, you just need to
remove blank rows?

--
Regards,
Tom Ogilvy

"curiouz" wrote in message
...
Help!
I need to look for a group number and list the contents of the group as a
list. Then I need to proceed to the nexrt group number etc. without any
spaces in the new list.

Any help is appreciated!