To get only the entries with "new" try the below.. in sheet2 A2 and copy
across/down as required

=IF(ROW(A1)<=COUNTIF(Sheet1!$A:$A,"new"),INDEX(She et1!A:A,SMALL(IF(Sheet1!$A$1:$A$100="new",ROW($A$1 :$A$100)),ROW(A1))),"")

If this post helps click Yes
---------------
Jacob Skaria


"Eva" wrote:

One more question. Everything work very well, but I was trying to get rid of
the headings - so I would like to start my formula in sheet2 from A2 Sheet1.
I was trying to change the formula myself but it didn't work. Can you have a
look at this once again? Thank you very much
--
Greatly appreciated


"Eva" wrote:

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