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