find unique records
 

how do i look through a column of data and create list of the unique entries
not showing the number of duplicates ie apple, pear, orange - and create a
new list of these unique items ? i want to then use this list as a means of
providing a "record count " in a different worksheet. thanks

find unique records
 

you might search this NG for "unique records"
or lookup Help for filtering

On 19 Maj, 13:56, frankfurtjoe
wrote:
how do i look through a column of data and create list of the unique entries
not showing the number of duplicates ie apple, pear, orange - *and create a
new list of these unique items ? i want to then use this list as a means of
providing a "record count " in a different worksheet. thanks