so - someone on this groups list posted the following awesome and
simple formula to pull unique values out of one column (thank you very
much, by the way)

=INDEX($D$4:$D$21,MATCH(0,COUNTIF($G$3:G3,$D$4:$D$21),0))

this formula (when you shift-control enter it and paste down column g)
will list all the unique values from column d. this is a great formula.

however, can anybody suggest a way i could adapt this formula to the
following 2 problems?

1. where instead of pasting down a column, i need a unique value every
3 cells down a column?

2. where i only want unique values that correspond to positive values
in a neighboring column?

thanks!!
jason gers
glaceau
whitestone, queens, nyc