HouseofRahl wrote:
Hi All,

I have a file which in column A had a list of numbers. There is a
second file with a different list of numbers in Column A. Ther are NO
repeated numbers, with the exception of the number 0.

I want to have a seperate file which gives me a list in column A of
all of the numbers in the first two files column A's that are not
zero.

Any ideas, via macro or formula or otherwise?

Thanks in advance...

Copy the first list below the second list then use Auto Filter to delete all
the zero rows