I was wondering if there was a way to return unique values in a column
from another column which contains duplicates. I already have a number
of macros to do this (and I'm aware of Filtering) but I was wondering if
there was a formulaic solution one might try to implement something like
this within a spreadsheet to keep this light and simple without having
to resort to these other methods. I think there should be a way.

To illustrate, say I have the following in column A:

A
A
B
C
C
D
D
D
D
E
F
F
G
G

The goal would be to return A-G IN CONTIGIUOUS cells in Column B (or
some other column). I should mention that using "helper" columns (such
as those containing the count of the value in column A for offset
purposes) would be okay, of course (as long as it's limited to a few of
them, say in B-D and my results column is D or something like that).

Thus far, I've been thinking along the lines of (for rows 2 and
greater):

Helper column B:

=COUNTIF(A:A,A2) ...[For Cell A2, and similar, copied down]

Results column C:

=OFFSET($A$1,SUM(OFFSET(B2,0,0):OFFSET(B2,(-1*ROW())+1,0)),0)

But this isn't quite doing it.

I'd love to collaborate on this, if anyone is willing.

Thanks,

-Petee


--
Peter Bernadyne
------------------------------------------------------------------------
Peter Bernadyne's Profile: http://www.excelforum.com/member.php...fo&userid=7017
View this thread: http://www.excelforum.com/showthread...hreadid=526791