Maybe just selecting the two columns and doing Data|Filter|Autofilter would work
for you.

You could filter on the first column and show only the non-blank cells.

When you're done, you can use Data|Filter|Showall to see everything.

thephoenix12 wrote:

Hey,

I'm looking for a way to search through two columns, the first column
contains cells that are either blank or contain numbers in them, and
the second column contains text. I want to have a search that looks
through the first row, and for every cell that isn't blank, it displays
the text to the right of the cell. I guess the best option would be to
use VBA to do this, but I dont know much about it right now. Any help
would be very useful!

-Steve

--
thephoenix12
------------------------------------------------------------------------
thephoenix12's Profile: http://www.excelforum.com/member.php...o&userid=24336
View this thread: http://www.excelforum.com/showthread...hreadid=380061

--

Dave Peterson