Searching a column for text (any text) and if it's there place it in a specific cell

[Gherkin]

Hi guys, I've made a trading based spreadsheet that changes every day. Basically when a stock shows certain characteristics it will appear in a certain cell in a column (otherwise the cell will be ""). It will usually be the only peice of text in that column, but maybe one other if they are exactly equal values (It's % change from previous close, so a tie is possible sometimes). Usually should be the only text in that column though. I'm wondering if it's possible to search thru that 99% empty column (or "" to be precise) and put the piece of text if it exists in a desired cell at the top of the spreadsheet. It's so I don't have to keep scrolling around to find the output of my spreadsheet. Hopefully I can organise it a bit (lot) better.

Craig.

P.S. I've found this forum very helpful for most of my dramas. Really good stuff.