req: Help with Sorting

[kip801]

I have some data that looks like this:

slinko_1163939680 slinko name1 12/20/2006 sarge ADH534
slinko_1163939680 slinko name1 ----------- sarge ADH534
slinko_1163939680 slinko name1 ----------- sarge ADH534
slinko_1163939680 slinko name1 ----------- sarge ADH236
slinko_1163939680 slinko name1 ----------- sarge ADH446
slinko_1163939680 slinko name2 12/19/2006 slinko ADH387
slinko_1163939680 slinko name2 ----------- sarge ADH534
slinko_1163939680 slinko name2 ----------- sarge ADH534
slinko_1163939680 slinko name2 ----------- sarge ADH236
..
..
..
..

I would like to filter it so I get the following:

slinko_1163939680 slinko name1 12/20/2006 sarge ADH534
slinko_1163939680 slinko name1 ----------- sarge ADH236
slinko_1163939680 slinko name1 ----------- sarge ADH446
slinko_1163939680 slinko name2 12/19/2006 slinko ADH387
slinko_1163939680 slinko name2 ----------- sarge ADH236


The last column is for tape numbers, so I need to grab unique tape numbers that have unique names (column 3) associated with them.

Essentially I could have two duplicate tape numbers listed in the sort as long as they were assoicated to unique names (column 3).

Sorry if this is vague, let me know if you need more information. Thanks for your time.

[Carim]

Hi,

It seems that what you looking for is not sorting but
Data Filter AdvancedFilter
Unique Items Only (down at the bottom left)

HTH
Carim

[kip801]

That advance filter works very well -- one question though,

When I use advanced filter I have this problem

Say I have:

slinko_1163939680 slinko name1 12/20/2006 sarge ADH534
slinko_1163939680 slinko name1 ----------- sarge ADH534

after the filter I should only have:

slinko_1163939680 slinko name1 12/20/2006 sarge ADH534

I know i'm not getting my desired result because of the date column. The date is shown when the date changes but then is ommitted on all the entries following until the date changes again.

example:

slinko_1163939680 slinko name1 12/20/2006 sarge ADH534
slinko_1163939680 slinko name1 ----------- sarge ADH534
slinko_1163939680 slinko name1 ----------- sarge ADH534
slinko_1163939680 slinko name1 ----------- sarge ADH236
slinko_1163939680 slinko name1 ----------- sarge ADH446
slinko_1163939680 slinko name2 12/19/2006 slinko ADH387
slinko_1163939680 slinko name2 ----------- sarge ADH534
slinko_1163939680 slinko name2 ----------- sarge ADH534


so it is giving me unique rows, but I need to figure out away to either fill in the blank date gaps so they wont be counted as a 'unique row' or some other work-around .. any suggestions?

thnx

[VBA Noob]

Hi,

The attached website shows you up to fill the gap's

http://www.contextures.com/xlDataEntry02.html#Fill

Then do the advance filter

VBA Noob

[Carim]

Well ...

In addition to the field you are using, you can also monitor the date fields ... with blanks and non blanks which, by combination, will give you the result you want ...

HTH
CArim

[kip801]

Thank you for your help Carim & VBA Noob. You've made my life a lot easier!

[Carim]

Thanks for your thanks ...

And let'us not forget Debra too ...!!!

Carim

[VBA Noob]

Well said Carim,


Debra site rocks

I've just purchased her pivot book and it's great too

VBA Noob