Display only Blank Cells?

[jo15765]

Okay, so last week, I used the VLookup to compare data within two spreadsheets and locate the duplicate information from both spreadsheets. Now I am wanting to sort the data to only display the ticket #'s that are not on both lists. For example, Field A has the ticket # and Field B says, "Yes" if it is a duplicate and is blank if it is not. I want to, if possible, ONLY show the fields that do not display yes. Any suggestions on how to do this?

[NBVC]

Filter for blanks in that column through Data|Filter|Autofilter.

[jo15765]

But if the field is blank, I need the ticket # in Column A so that I know what ticket # I need to go and pull. Basically if it is on the 2nd list, the list that I compared, then I know we received payment, if it is only displaying on the 1st list we are waiting for payment. So if the field is blank, I need to know which ticket # is beside it so I know payment is pending. Does that make sense?

[NBVC]

When you filter for blanks on one column, all the data in each of the filtered rows displays.

So if you filter column C for blanks, then if column A contains data in the corresponding rows, you will see that data.

If I am still not on the same wavelength, then post a sample workbook showing expected results.

[jo15765]

Maybe I am just not understanding how you are saying to do it. I am using Office 2000 and I hate it! haha
Here is an example, on a much smaller scale, I have over 150,000 entries on my main document, but maybe this well help me out!

[NBVC]

This file does not resemble your case above.

I don't see Yes's, I don't see blanks, I don't know what you are wanting from this file. Kindly advise what the end result is supposed to be.

BTW, this is an XL2007 file.. therefore it appears you are not using 2000....

[jo15765]

I am using 2000 at work, and have 2007 at home, so that is a huge transition in itself for me. On the spreadsheet Column A contains ticket numbers, and Column B was containing a Yes if it was a duplicate or remaining blank if it is not duplicated.
Ticket # Duplicate
1111112
1111113 YES
1111114
1111115
1111116 YES
1111117 YES

now I agree on a smaller scale such as this, it would be easy to distinguish, but I am needing a way to either hide the data in both Ticket # field and Duplicate if duplicate says yes, or I am needing a way to keep the data intact and sort as to where if the Duplicate Field is blank then the TIcket # will be brought to the top of the list. For instance, I would love to be able to have Excel sort it to display like this:

Ticket # Duplicate
1111112
1111114
1111115
1111113 Yes
1111116 Yes
1111117 Yes

Does that make more sense?

[NBVC]

See attached for a couple of options.

I just created by own Duplicate search formula and used column A to find dupes...the end concept should be the same.

In Sheet1, I used Data|Filter|Autofilter and filtered column D for blanks.

In Sheet1 (1), I simply sorted Ascending by Column D.

[jo15765]

Well first off, I see why you were so confused, because I uploaded the wrong spreadsheet!!! Sorry! The Data.Filter is very simple and easy to use, but my ? is does Excel 2000 have that same feature?

[NBVC]

I don't have 2000 anymore, but I am pretty sure it does..

[jo15765]

I just found a copy of excel 2000, it is similar to the steps for 2007. That being said, if i do the data.filter I choose autofilter, and then on the first cell on my column I am wanting to filter it has the drop down list where I choose, "Yes" or blank. If the first cell hasthe word "YES" in it, then the first cell remains even on the filtered list. Is there a way to remove that, or should I go to my first blank cell (which on my actual list is pretty far down)

[NBVC]

Insert a row above then select all column and appy Autofilter, the first row will contain the arrows

[jo15765]

ahh something so easy! thank you!

[jo15765]

Okay, the data.sort worked for this problem, but now we are adding another column for Contact Made, that I will also need to sort to look for "yes" or "no." It didn't look like I could multiple sort without copying the data to another sheet, is there any way to do multiple sorts? Oh yes, and I also found out that my first column, Ticket # has duplicates in it, so I need to filter that to only show unique id's.

Let me create a sample database, and see if it will make more sense with that visual aid.

[martindwilson]

that's not very representative there's no duplicates and no NO's

[jo15765]

I apologize that was the example I did yesterday, let me give you the one I updated to match what current issues I am working on.

[NBVC]

You can filter by one column, then the other.. also you can sort by one column, then the other.

For the first column choose the priority one... so if you want to see all the blanks in column C, then out of those you want all the "yes's" in column B, then sort by C then by B.

[jo15765]

When I tried that today at work, when I cliked the 2nd group I wanted to filter, it "undid" the filter for the first, unless I copied it to a different workbook?????

[NBVC]

It shouldn't. Try again.

See attached. Filtered first for blanks in C, then for Yes in B.