Ask Your Question

This range does not contain a valid query

asked 2019-04-28 22:16:51 +0200

ECBgoddess gravatar image

Trying to remove duplicates from a spreadsheet. Used DATA>MORE FILTERS>ADVANCED FILTERS Selected label column and then scrolled down to last entry while holding down shift key to select range. See image.

image description

When I click OK I get the above error message. Running on Mac OS Mojave

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-04-29 14:08:14 +0200

m.a.riosv gravatar image

updated 2019-04-29 14:08:34 +0200

Looks as you are introducing the data range, not the filter range. Filter: Applying Advanced Filters.
But it's possible to do it with standard filter Menu/Data/More filters/Standard filter, so you don't need to define a filter range.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-04-28 22:16:51 +0200

Seen: 26 times

Last updated: Apr 29