In sheet2 A1 try the below formula...Copy/drag the formula to cells to the
right ColB/C and then copy the formula down as required. Please note that
this is an array formula. An array formula can perform multiple calculations
and then return either a single result or multiple results.You create array
formulas in the same way that you create other formulas, except you press
CTRL+SHIFT+ENTER to enter the formula. If successful in 'Formula Bar' you can
notice the curly braces at both ends like "{=<formula}"

=IF(ROW(A1)<=COUNTIF(Sheet1!$A:$A,"?*"),INDEX(Shee t1!A:A,SMALL(IF(Sheet1!$A$1:$A$100<"",ROW($A$1:$A $100)),ROW(A1))),"")

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


"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