Hi,
I have a database and want to do some sorting. I give an example,

Ron 1 4
Jes 2 8
Raj 3
Don 4 5
Ali 5
Mo 6 3
Sid 7

We have data in Column A , B & C. We want to show the sorting result in
other sheet Horizontally. We only want to show those with value in Column B
& C. So, it will show like below

Ron Jes Don Mo

Any idea

Assuming column D is free, in D1 put

=IF(OR(B1="",C1=""),D2,D2&" "&A1)

and copy this down the data.

The answer as you specified will be in cell D1, copy this and Paste
special = values to your new location.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=375874