|
RE: Distinct list formula
See Chip Pearson's site topic "Extracting Unique Entries"
"summergs" wrote:
>
> Does anyone know of a formula I could use to compile a distinct list of
> entries from another column. I know this could be done with the
> advanced filter, and I know it could be done with VBA, but I need to do
> it with a formula. Likewise, I can't use a pivot table because then the
> data could be changed. I have to pull a distinct list and their
> correponding values from some static data so it can be graphed.
> Thanks
>
>
> --
> summergs
> ------------------------------------------------------------------------
> summergs's Profile: http://www.excelforum.com/member.php...o&userid=37419
> View this thread: http://www.excelforum.com/showthread...hreadid=571901
>
>
|