Put the worms back in the can.

A thread a month ago - has long gone.

When I create a list of data cells and do Data, Filter, Advanced Filter...
I get an warning message pointing out that I haven't got a label or did I
want to use the first cell as the heading

In fact I can't actually find a selection that doesn't give this message..

Putting an AutoFilter on the first cell, did enable me to avoid the
warning,
but that's obvious as I'd marked the first cell by doing the AutoFilter.

Seems pretty logical and foolproof to me.

Steve



On Tue, 19 Sep 2006 20:57:48 +0100, Epinn
wrote:

Hello,

I may have opened a can of worms. I can really confuse myself and
everyone else. In order to truly understand what I am relaying, one
must follow my steps to the dot.

May I refer you to my thread on August 18 titled "List for AutoFilter
and list for Subtotals have different meanings?"

Based on my findings on August 18, my answer to Dave's question is "yes"
off the top of my head. But I have decided to actually do an experiment
and I have discovered more issues and my answer is "yes" and "no."

Now, Dave, do you mean I don't do listcreate list, but just insert a
row above the names and enter "names" to the cell? In other words,
"names" is the column heading.

Case 1 and Case 2 below work fine but not Case 3. Please note my list
is NOT sorted this time.

Case 1

If I select the entire range including the column heading "names" and
choose data filter advanced filter ...... everything is fine. There
is a difference between auto filter and advanced filter in that the
latter doesn't give me the down arrow beside the column heading. That's
okay. But how does the system know that "names" is the column heading?
I say it doesn't. Please read on.

Case 2

If I DON'T select the column heading "names" and just the names AND the
first name DOESN'T have a duplicate, then I have a good list too.

Case 3

If I DON'T select the column heading "names" and just the names AND the
first name HAS a duplicate, then there is problem.

This experiment tells me advanced filter doesn't really know that the
word "names" is a column heading. It just treats it as one of the
names. The new list (unique records) will be fine provided the first
text in the range selected (be it the column heading or a true name)
DOESN'T have a duplicate.

Should I do auto filter first to get the down arrow before I do advanced
filter? Is there a bug?

I am not going to spend any more time experimenting say with a sorted
list. In the future, this is what I am going to do. Create a list
(list create list) and sort it before I do advanced filter.

Comments welcome.

Epinn

"Dave Peterson" wrote in message
...

If you had added a single row with a header, would it work ok?

(Dropping all the list stuff, too.)



Epinn wrote:

Hi,

Today's discovery:-

I have a *column* of first names, some of which are duplicates. I did
a sort and then I tried to do advanced filter and I ticked unique
records. The info generated was not 100% correct - one name showed up
*twice*. In other words, I didn't get a list of *unique* names. But
it was interesting that only ONE name (i.e. the first duplicate) didn't
work.

I had a feeling that I should create a list but I wanted to see what
would happen if I didn't. Anyway, I backtracked and I created a list
(without header) and everything worked fine.

Lesson learned: Must always follow the rule to create a list (list
create list) before filtering. We can skip sorting but not creating a
list. The results will still be okay if data NOT sorted. However, it
may speed up processing if sorted??

Please feel free to comment.

Epinn