Given your example list and rules shouldn't the resulting list look like this:
Peter CA Jan CA Marge CA Donald CA What is the storage method of this data? I'd write something in SQL if your data is in a table somewhere. --- In [email protected], "Perry Kappetein" <pkappet...@...> wrote: > > Hi > > I am trying to figure this out, to see if it's possible at all > > I have a listtree/listview with the following > > 12 rows with 2 collumns > > > First column has names and the 2nd one has the State > > Donald WI > Peter CA > Jan OK > Marge NH > Donald CA > Peter DC > Jan CA > Marge CA > Donald FL > Peter FL > Jan FL > Marge FL > > I want to take out the duplicates But with the Rule that if they are in CA > they should show, and if there is no CA then take FL > > So it should end up like this > > > Peter CA > Jan CA > Marge CA > Donald FL > > I can't find much info regarding duplicates, > is there a way to do it like that? > > Thanks so much > > Perry > > > > [Non-text portions of this message have been removed] >
