Anyone know how to do this or a formula that will help me accomplish this?

If information within Column C of Worksheet 1 is not within Column B of
Worksheet 2, then populate a new row on Worksheet 2 with information missing
from Column C of Worksheet 1.

This is basically what I need.

I need all the missing information within the column to copy everything in
the row of the column item missing. Is there also a way to specify where the
row information will be placed on worksheet two, for example, B6 on worksheet
1 needs to populate on C24 of worksheet 2.

Thank you.

try insert this in C1 Sheet2 and copy down

=IF(COUNTIF(Sheet2!$B$1:$B$100,Sheet1!C1)=0,Sheet1 !C1,"")


"LiveUser" skrev:

Anyone know how to do this or a formula that will help me accomplish this?

If information within Column C of Worksheet 1 is not within Column B of
Worksheet 2, then populate a new row on Worksheet 2 with information missing
from Column C of Worksheet 1.

This is basically what I need.

I need all the missing information within the column to copy everything in
the row of the column item missing. Is there also a way to specify where the
row information will be placed on worksheet two, for example, B6 on worksheet
1 needs to populate on C24 of worksheet 2.

Thank you.

Thank you excelent...

I entered the formula and so far I believe it works... I have to look at it
a little further.
Could you please explain how this formula works?
Is there an easy way to get rid of blank cells within a certain region?



"excelent" wrote:

try insert this in C1 Sheet2 and copy down

=IF(COUNTIF(Sheet2!$B$1:$B$100,Sheet1!C1)=0,Sheet1 !C1,"")


"LiveUser" skrev:

Anyone know how to do this or a formula that will help me accomplish this?

If information within Column C of Worksheet 1 is not within Column B of
Worksheet 2, then populate a new row on Worksheet 2 with information missing
from Column C of Worksheet 1.

This is basically what I need.

I need all the missing information within the column to copy everything in
the row of the column item missing. Is there also a way to specify where the
row information will be placed on worksheet two, for example, B6 on worksheet
1 needs to populate on C24 of worksheet 2.

Thank you.