how filter and then export only the filtered rows of a very large Numbers dataset....filtered results in approx 75,000 rows

Question

Level 1

4 points

need to export only filtered portion of a very large Numbers dataset

prior answers not helpful because the dataset has 250,000 rows

and the resulting FIlter view has 75,000 rows

manual scrolling for selection is not workable

i need to do a set reduction using filtering

please advise

MacBook Pro 15″, macOS 10.15

Posted on May 5, 2023 1:57 PM

Reply

Answer 1

Top-ranking reply

Level 1

13 points

Variant on Badunit's response:

Reply

Answer 2

Level 7

30,918 points

Export to what/where?

Filter the table
Select the entire table (click on the green circle at the top left corner of the table)
Copy (Command C)
Paste (Command P) into an Excel worksheet or a TextEdit document set to Rich Text

Only the visible rows should have pasted, the hidden rows will be gone. You could also paste into a blank Numbers table, but you said "export".

Reply

Similar questions