.. Will a dynamic range work for these kind of comparison extractions?

In this instance, we might face problems as the dynamic ranges returned may
not exactly sync with the other corresponding static ranges used within the
formulas. Eg: Any unequal range sizes between an indexed range (say: a
dynamic range) and the MATCH table array (say: a static range) would foul up
/ yield incorrect returns. The non-array approach suggested averts such
possible problems by using consistent entire col references.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"BrandonC" wrote:

Max,
Yea, I have been try to get my lists to work with just that kind of
formula. The non-array approach looks good, I will give it a whirl.
I did have more success with the following:
=IF(COUNTIF($A$1:$A$10,B1)0,B1,"") put in the first cell of a column
and filled down.
=IF(COUNTIF($A$1:A1,A1)=1,A1,"") put in the first cell of a column and
filled down
=IF(COUNTIF($A$1:$A$10,B1)=0,B1,"") put in the first cell of a column
and filled down
Which for the example works fine. But for later lists, the drilling
down of data will be greater. The smallest lists will easily be 3000
rows. Will a dynamic range work for these kind of comparison
extractions?