Distinct list formula

From: summergs <summergs.2clhdg_1155667810.4424@xxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 15 Aug 2006 14:48:51 -0400

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?action=getinfo&userid=37419
View this thread: http://www.excelforum.com/showthread.php?threadid=571901

.

Prev by Date: Re: Making Time Right
Next by Date: Re: IPMT Function for fractional periods
Previous by thread: Re: Can I embed 'goal seek' functionality into a spreadshee
Next by thread: Re: Distinct list formula
Index(es):
- Date
- Thread

Relevant Pages

Passing a hash by reference
... sub AddHashEntries ... sub PrintHashEntries ... print("\nAdded all entries OK"); ... I can't even get the PrintHashEntries routine to compile - I ...
(comp.lang.perl.misc)
Re: "Too many continuation lines" error message (no solution, just comment)
... >>DATA to initialize the static data. ... > which would have had different values all over - these arrays were ... > compile times from when the compilation crashed the system). ... So it was about 29MB of static data? ...
(comp.lang.fortran)
configurable device (and other) tables in the kernel ?
... containing at least device-id tables, ... Right now we compile them statically in the code. ... human-readable representation of entries in userland, ...
(freebsd-arch)
Re: Multiple references to same component in reference dialog
... I have several entries for components I evidently ... I use RegClean on XP/SP2. ... My expperience is that if I compile a project with or without binary ... the entry will still be in the registry and in the ...
(microsoft.public.vb.general.discussion)
Re: collecting text througout the document to build lists
... I can not sort the entries by keywpords...I could live with this ... As a table of conents I would like to print the index at the ... Either it didn't compile or it didn't expand... ...
(comp.text.tex)