You could use autofilter to filter out the rows where "N" appears.

Then F5SpecialVisible Cells OnlyOK

Copy and select a cell on Sheet2 then Paste SpecialTransposeOKEsc


Gord Dibben MS Excel MVP

On Tue, 30 Jan 2007 15:44:00 -0800, notso
wrote:

I have a table

Y A
Y B
N C
Y D

I need a formula (can't use a macro) to show only column 2 on another sheet
and have it displayed on one row, leaving out the fields with an "N" in the
first column.

A B D <--- this would be my result on the other sheet, one row and three
columns.