You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Eva" wrote in message
...
Thanks, it is great!
--
Greatly appreciated
Eva


"T. Valko" wrote:

Try this...

Assume the data on Sheet1 is in the range A2:C20

Enter this array formula** on Sheet2 in cell A2:

=IF(ROWS(A$2:A2)COUNTIF(Sheet1!$A:$A,"new"),"",IN DEX(Sheet1!B:B,SMALL(IF(Sheet1!$A$2:$A$20="new",RO W(Sheet1!A$2:A$20)),ROWS(A$2:A2))))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the
SHIFT
key then hit ENTER.

Copy across to B2 then down until you get blanks meaning all relative
data
has been extracted.

--
Biff
Microsoft Excel MVP


"Eva" wrote in message
...
I have the data in sheet 1 as follows
col A - blank or "new"
col B - name
col c - number

I need to create in sheet2 report that takes only "new" data from
column A
col B - name
col c - number

I thought about the offset function - any ideas?

--
Greatly appreciated


.