Thread: Make a list from two other lists in different files
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HouseofRahl[_3_] HouseofRahl[_3_] is offline
external usenet poster
  
Posts: 1
Default Make a list from two other lists in different files

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


--
HouseofRahl
------------------------------------------------------------------------
HouseofRahl's Profile: http://www.excelforum.com/member.php...o&userid=25161
View this thread: http://www.excelforum.com/showthread...hreadid=563873

Reply With QuoteReply With Quote