View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
ken ken is offline
external usenet poster
 
Posts: 21
Default Trouble with Advanced Filter

G'day there Roger,

Sorry, the amended formula should, of course, be

=OFFSET(Data!$A$9,0,0,COUNTA(Data!$A$9:$A$65536),2 2)


Thanks muchly for that Roger, it works like a charm now. Or at least,
just like an XL spreadsheet :)

I've also followed your advice about shrinking the file. Oddly enough,
the filter still didn't work properly until after I did the shrinky bit.
However it's fine now.

Thanks very much for all the help I received. It's much appreciated.
Now all I have to do is build the rest of the application :D

Thanks again,
See ya
Ken