View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default Advanced filter and a list

On Tue, 19 Sep 2006 21:47:36 +0100, Epinn
wrote:

Put the worms back in the can.


Hmmm, I didn't see a smiley nor a <g.

There wasn't one, you made the comment about worms and cans

A thread a month ago - has long gone.

I can still read it.

I delete threads after about 2 days


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.

Biff, can you help me out here please. The above only happened to me
once this afternoon. Subsequently, I had not got that warning message..
What is happening here? What will trigger that message?

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


Interesting enough, I am experiencing the opposite and cannot trigger
the message even though it happened to me once today.
Maybe this is proof that you and I are very different from each
other..... ;)

you have a smiley but just because you can't repeat it doesn't mean were
are different.
Luckily I can assure you we are.

Seems pretty logical and foolproof to me.


Talking about "foolproof," a philosopher once said: "The wise has a lot
to learn from the fool."


No smiley there I see

Epinn

"SteveW" wrote in message
news:op.tf46uynzevjsnp@enigma03...
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.