Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 2nd 06, 06:49 PM posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default Customer List Categorized

Personally I would use a separate column for each vendor, and then
CONCATENATE them all into an additional column for identifying groups.

The separation can be done then with either conventional sorting on the
Vendor columns, or better yet by using the Data Filter AutoFilter.........

hth
Vaya con Dios,
Chuck, CABGx3



"SeaTiger" wrote:

I am setting up my customer list and I need to identify which vendors
each customer buys from. I currently have 8 different vendors that I
have assigned a letter, i.e. A B C D E F G H. Some customers may buy
from one vendor, others from a few to all.

I want to eventually be able to sort this list according to the vendors
that the customers buy from for specific calling lists for my sales
staff. The headings on my list are CUST NAME (A1), STORE NAME (B2),
ADDRESS (C3), CITY (D4), ST(E5), ZIP (F6), TEL # (G7). What's the best
way to set up the heading(s) for the VENDORS for sorting? Can it be
one cell and where I would enter A, B, C etc. codes for the vendor or
should I create separate cell/columns for each potential vendor?

In either example, what formula would I use to sort the customers who
buy from let's say for vendor A or a group of vendors B, D, G? I would
like the new list to be exported to a new spreadsheet.

Your time and consideration would be deeply appreciated.

Thanks,
victor


  #2   Report Post  
Old February 3rd 06, 12:34 AM posted to microsoft.public.excel.newusers
la90292
 
Posts: n/a
Default Customer List Categorized

Hi Chuck:

Thanks for your suggestion. So I created columns a1-h1 to input the vendor
codes for each customer. How would you CONCATENATE them all into an
additional column for idenifying groups?

Thanks,

Victor

"CLR" wrote in message
...
Personally I would use a separate column for each vendor, and then
CONCATENATE them all into an additional column for identifying groups.

The separation can be done then with either conventional sorting on the
Vendor columns, or better yet by using the Data Filter
AutoFilter.........

hth
Vaya con Dios,
Chuck, CABGx3



"SeaTiger" wrote:

I am setting up my customer list and I need to identify which vendors
each customer buys from. I currently have 8 different vendors that I
have assigned a letter, i.e. A B C D E F G H. Some customers may buy
from one vendor, others from a few to all.

I want to eventually be able to sort this list according to the vendors
that the customers buy from for specific calling lists for my sales
staff. The headings on my list are CUST NAME (A1), STORE NAME (B2),
ADDRESS (C3), CITY (D4), ST(E5), ZIP (F6), TEL # (G7). What's the best
way to set up the heading(s) for the VENDORS for sorting? Can it be
one cell and where I would enter A, B, C etc. codes for the vendor or
should I create separate cell/columns for each potential vendor?

In either example, what formula would I use to sort the customers who
buy from let's say for vendor A or a group of vendors B, D, G? I would
like the new list to be exported to a new spreadsheet.

Your time and consideration would be deeply appreciated.

Thanks,
victor



  #3   Report Post  
Old February 3rd 06, 01:22 AM posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default Customer List Categorized

Hi Victor.....

In cell I1, put this formula and copy it down as far as you have an entry in
any of the other columns.....

=A1&B1&C1&D1&E1&F1&G1&H1

Vaya con Dios,
Chuck, CABGx3


"la90292" wrote in message
. com...
Hi Chuck:

Thanks for your suggestion. So I created columns a1-h1 to input the vendor
codes for each customer. How would you CONCATENATE them all into an
additional column for idenifying groups?

Thanks,

Victor

"CLR" wrote in message
...
Personally I would use a separate column for each vendor, and then
CONCATENATE them all into an additional column for identifying groups.

The separation can be done then with either conventional sorting on the
Vendor columns, or better yet by using the Data Filter
AutoFilter.........

hth
Vaya con Dios,
Chuck, CABGx3



"SeaTiger" wrote:

I am setting up my customer list and I need to identify which vendors
each customer buys from. I currently have 8 different vendors that I
have assigned a letter, i.e. A B C D E F G H. Some customers may buy
from one vendor, others from a few to all.

I want to eventually be able to sort this list according to the vendors
that the customers buy from for specific calling lists for my sales
staff. The headings on my list are CUST NAME (A1), STORE NAME (B2),
ADDRESS (C3), CITY (D4), ST(E5), ZIP (F6), TEL # (G7). What's the

best
way to set up the heading(s) for the VENDORS for sorting? Can it be
one cell and where I would enter A, B, C etc. codes for the vendor or
should I create separate cell/columns for each potential vendor?

In either example, what formula would I use to sort the customers who
buy from let's say for vendor A or a group of vendors B, D, G? I would
like the new list to be exported to a new spreadsheet.

Your time and consideration would be deeply appreciated.

Thanks,
victor





  #4   Report Post  
Old February 3rd 06, 07:27 AM posted to microsoft.public.excel.newusers
SeaTiger
 
Posts: n/a
Default Customer List Categorized

I am setting up my customer list and I need to identify which vendors
each customer buys from. I currently have 8 different vendors that I
have assigned a letter, i.e. A B C D E F G H. Some customers may buy
from one vendor, others from a few to all.

I want to eventually be able to sort this list according to the vendors
that the customers buy from for specific calling lists for my sales
staff. The headings on my list are CUST NAME (A1), STORE NAME (B2),
ADDRESS (C3), CITY (D4), ST(E5), ZIP (F6), TEL # (G7). What's the best
way to set up the heading(s) for the VENDORS for sorting? Can it be
one cell and where I would enter A, B, C etc. codes for the vendor or
should I create separate cell/columns for each potential vendor?

In either example, what formula would I use to sort the customers who
buy from let's say for vendor A or a group of vendors B, D, G? I would
like the new list to be exported to a new spreadsheet.

Your time and consideration would be deeply appreciated.

Thanks,
victor


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
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM
HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO CHAIM Excel Discussion (Misc queries) 1 September 29th 05 08:28 PM
Copying list item (a bit less vague) Hru48 Excel Discussion (Misc queries) 7 September 29th 05 04:51 PM
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 Ed Excel Worksheet Functions 5 September 12th 05 09:48 AM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017