Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Advanced Filter - error message
Hi there,
Can anyone tell me what the following message means and how to stop it please 'The extract range has a missing or illegal field name' In simple language please - not even sure what extract range and field name are. The filter works. It puts the data expected into the cell I tell it to but an error message pops up afterwards. I would be grateful for any answers. Cheers Mifty -- Mifty |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Advanced Filter - error message
The extract range is where you want the filter results to start. The
range can be blank, or can contain headings that exactly match headings from the source table. (You can use some or all of the headings from the source table.) A field is a column in the source table. Usually you get that message if a heading in the extract range isn't identical to one of the headings in the source table. Mifty wrote: Hi there, Can anyone tell me what the following message means and how to stop it please 'The extract range has a missing or illegal field name' In simple language please - not even sure what extract range and field name are. The filter works. It puts the data expected into the cell I tell it to but an error message pops up afterwards. I would be grateful for any answers. Cheers Mifty -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Advanced Filter - error message
Many thanks for your reply. Will have another try and let you know
-- Mifty "Debra Dalgleish" wrote: The extract range is where you want the filter results to start. The range can be blank, or can contain headings that exactly match headings from the source table. (You can use some or all of the headings from the source table.) A field is a column in the source table. Usually you get that message if a heading in the extract range isn't identical to one of the headings in the source table. Mifty wrote: Hi there, Can anyone tell me what the following message means and how to stop it please 'The extract range has a missing or illegal field name' In simple language please - not even sure what extract range and field name are. The filter works. It puts the data expected into the cell I tell it to but an error message pops up afterwards. I would be grateful for any answers. Cheers Mifty -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using Advanced filter | Excel Discussion (Misc queries) | |||
Hiding advanced filter | Excel Discussion (Misc queries) | |||
Refresh advanced filter | Excel Discussion (Misc queries) | |||
advanced filter | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |