Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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!


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to lookup item for Qty? tb Excel Worksheet Functions 2 February 13th 09 08:18 PM
vlookup formula fails to return data search item is text Delfina Excel Worksheet Functions 1 November 30th 07 01:01 PM
lookup single value in a range and return specified value bjw Excel Worksheet Functions 3 June 7th 07 11:25 PM
Lookup & Return Range of Data shehasclass Excel Discussion (Misc queries) 2 April 6th 06 04:17 PM
how to lookup a value within a range and return a label jocmccoy Excel Discussion (Misc queries) 1 November 16th 05 11:52 AM


All times are GMT +1. The time now is 02:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"