Hi Max,
This formula is what I am looking for too. It works, but, column C has
blank cells in it. Is there a way to get column C to not have blank cells.
To have it report only the cells from column A that have a number?
Your help is greatly appreciated,
Terri

"Max" wrote:

... looks through the first row, and for every cell that isn't blank,
it displays the text to the right of the cell...

Assuming you mean look through the first *column* (typo?), and the first and
second cols are cols A and B, with data from row1 down,
you could put in C1 and copy down:
=IF(TRIM(A1)<"",B1,"")

Col C should return as required.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"thephoenix12"
wrote in message
news:thephoenix12.1qrxib_1119017105.2233@excelforu m-nospam.com...

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