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