Without formulas or VBA...............

Select all then EditFind

What: your data

Find All

In the "found" dialog select top cell then SHIFT + End + Downarrow

You can also key-in Ctrl+A at this point to select all the items in the list
(you can do this immediately after hitting the Find All button as the focus
is already in the list it produced).

--
Rick (MVP - Excel)