Jeffs problem No. 14273 for experts to array formulas
Posted by Eli Weiss on January 13, 2002 9:59 PM
I am interested too in thease kind of problems
It could be solved by macros of course, but I am sure that array formulas using =countif etc. can solve this problem simply
There was no answer to this question yet
Can anybody try to solve it?
Jeffs question from 1/9/02 was as follows:
I'm looking for a way to compare two seperate lists of numbers and having Excel create a third list that shows only non-duplicated entries. In other words, I want List 3 to consist of the numbers that appear in List 1, but that are not in List 2. Example below:
List 1 List 2 List 3
------ ------ ------
1 1 2
2 3 4
Thanks for your help!!