Complex Sorting/Replacing Question

RyBand0

New Member
Joined
Jul 28, 2015
Messages
1
Hello

I am working on a project that involves me sorting clients into various different groups based on parameters regarding what types of accounts they hold.

I sorted the list down to the people who have two accounts and now I want to sort the original client info sheet down to this same group of people.

I inserted a column into column A that has the list of around 500 unique client names next to the full data sheet of over 2000 clients. How can I do a function that will delete all the clients in the sheet that don't appear in column A?

Now that I've typed this out it sounds simpler to me but I couldn't find answers anywhere.

Please give me any advice or a link to something. Anything is appreciated as this is a very time sensitive project.:)
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
RyBand0,

Welcome to the MrExcel forum.

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?


I inserted a column into column A that has the list of around 500 unique client names next to the full data sheet of over 2000 clients. How can I do a function that will delete all the clients in the sheet that don't appear in column A?

This is not a good idea, because, it could cause problems.

the list of around 500 unique client names

This should be in a new worksheet, to compare the two worksheets.

3. Can we see a workbook with just two worksheets?

3a. The worksheet with the short list.

3b. The original raw data worksheet name, with just column A, with a sample clients list. And, on this list indicate in column B with an X (as a reference for me), those entries that should be deleted form the short list.

The following is a free site:

You can upload your workbook to (the BLUE link-->) Box Net ,

sensitive data changed

mark the workbook for sharing

and provide us with a link to your workbook.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,194
Messages
5,768,775
Members
425,492
Latest member
blueexcel123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top