See site for ways to generate a unique list of data:

http://www.cpearson.com/excel/ListFunctions.aspx

About half way down, section titles "Extracting Elements From One List Not
On Another List"
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"debinnyc" wrote:

Hope you can help me.

I have data from two months.
June & July.

I have already reported June's and don't want to report the same data in
July.

How can I extract only the "new" information?

Data1 Data2
a a
b c
d d
e e
f g
h h

The new spreadsheet (column, whatever) would yield:

Data3
b
c
f
g