08-15-2006, 03:05 PM
|
|
|
|
RE: Distinct list formula
When you say distinct list of entries I'm assuming you mean unique records.
One way to do this would be with a helper column. If the data which
distinguishes one row from another is in column A, then the helper formula
would be =IF(A1=A2,1,"") assuming the data table is sorted by column A.
If you provide more information about the data you're trying to sort I could
make this explanation more concrete.
"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
>
>
|