hey everyone,
here is the scenario:
i have a huge list of data with about 20 columns of different metrics. This data represents different customers and each row/customer has different data, however, there is one line of data that groups that customer with other similar customers.
on a separate tab, i would like to select the customer group from a drop down or just type it in and when i do, all of the customers that are in that group populate in the cells below it. For some customer groups there are 1-5 customers, for others, there are 100 or more.
can this be done???
thanks!!!!!
here is the scenario:
i have a huge list of data with about 20 columns of different metrics. This data represents different customers and each row/customer has different data, however, there is one line of data that groups that customer with other similar customers.
on a separate tab, i would like to select the customer group from a drop down or just type it in and when i do, all of the customers that are in that group populate in the cells below it. For some customer groups there are 1-5 customers, for others, there are 100 or more.
can this be done???
thanks!!!!!