Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2006

Tip: Looking for answers? Try searching our database.

Returning multiple lines of data for a single query?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jg - 10 Mar 2006 22:55 GMT
Worksheet "Orders" (19,000 rows, give or take)
In column A: Customers (of which there are 41 unique entries)
In column B: Locations (from 1 to 8 per customer)
Other columns have additional data from each order.

On worksheet "Query", I'd like to create a function which, for a particular
Customer, returns all possible Locations associated with that customer.

So, for instance, the result might look like this:

     A                  B
1 Customer    Alamo
2 Loc1           Ogden
3 Loc2           SLC
4 Loc3           Alb
...

and so on.

What formulae do I need in B2-B4?

Thanks
davesexcel - 10 Mar 2006 23:07 GMT
http://www.contextures.com/xlFunctions02.html
Check out VLOOKUP here

Signature

davesexcel

jg - 10 Mar 2006 23:21 GMT
Yeah, sorry.  Should have mentioned - already checked out Deb's excellent
site.

However, I don't see anything there that gives me what I want.

For each unique "Customer" in Column A, I'd like to return the 1-8 unique
"Locations" from Column B that are uniquely tied to that customer.   Note
that each customer and location occurs many times in their respective
columns.

I guess what I want is a function that gives the result as manually using
AutoFilter.  Perhaps some array function using some combination of Index,
Match, If?

Thanks

> http://www.contextures.com/xlFunctions02.html
> Check out VLOOKUP here
kletcho@gmail.com - 11 Mar 2006 22:13 GMT
Just put an autofilter on your data and filter on that customer name.
Your other option is to create a pivot table and use the filter on the
pivot table to choose your customer.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.