Help on Sorting/Formula

[ZombieStench]

i have a spreadsheet over 60k people listed with multiple dates. i have a set date of say 1/1/2012 now i need to keep the people with old dates (anything before 1/1/12) as long as they also have a current date (anything after 1/1/12) but get rid of the people with just old dates. How can i go about doing this?

[arlu1201]

Do you have a sample that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[ChemistB]

Are all the dates in a single column? Spread out over multiple columns? Are names in some kind of order or might the same name appear in A2 and A56. An example spreadsheet (Go Advanced> Manage Attachments) would go a long way to helping us understand exactly what you need.

[ZombieStench]

all dates are in a single column names are in a separate single column

[ZombieStench]

example attached

[ChemistB]

In a new column, you could use an Array function (use Contrl SHFT ENTER instead of ENTER. You'll see brackets {} around your formula)

=MAX($H$2:$H$27*($C$2:$C$27=C2))< "1/1/12"+0
See attachment
Then filter on TRUE and delete those rows/names
Does that work for you?

[ZombieStench]

Thanks alot ChemistB that is what i needed!!!