Filtering in Gnumeric: how to?
If anyone here uses Gnumeric, can you tell how to filter data?
Gnumeric's help doesn't make sense, and there is no forum for Gnumeric to ask, web search was useless too.
I'm trying to filter rows, containing the same word (there is more than one word in the cell), in interrupted columns range. Or is the filtering possible only by the whole cell content?
There is no information what AutoFilter is or how to use it, and for Advanced filter, it seems that List Range is name of the sheet in quote marks ' ' with "!", the selection of all sheet's cells without headers, say A2-AD1100.
But what can I use as Criteria Range? For what I'm trying to filter, it cannot be a range of sells, only one cell's content.
And why copy title bars in free cells in the same sheet, as help says, why type criteria there, if it will be not used anyway?
Can you clarify, please?