Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

A slightly less complex solution might be to select the range you want to work with and use a standard filter - Data | More Filters | Standard Filter

You might want to use a named range if there is a lot of rows to work with. You mention ten million items; of course you won't be able to add that many rows to a Calc sheet as the maximum number of rows is 1048576.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. That will help other people with the same question.