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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine 2 columns in a dynamic range into one 7
I need ONLY subtotals copied to a second sheet 4
Problem with a loop and column references 27
Post my named ranges in column A 10
Copying a formula to a range 2
Convert code to lookup three criteria return fourth 15
Vertical lookup with a lookup value that returns multiple matches 3
Three-way Lookup (revised) 8

Back
Top