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...