Re: Array formula for unique entries

Use Data>Filter>Advanced Filter, it has a uniques option.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Martina" <Martina@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E51EF06B-6CB6-461E-BB13-BBD4DA841B9E@xxxxxxxxxxxxxxxx
Dear Experts,
I know how to filter a list of data for unique entries using the advanced
filter however I want to have it happen without user intervention.

Can I use an array formula to pick out unique entries from a predetermined
list and display them in adjacent columns?

regards
Martina


.

Relevant Pages

  • Re: filter with condition
    ... Tad more info, ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... but when i can change c1 value its not automatically filter. ...
    (microsoft.public.excel.misc)
  • Re: Auto Filter function only provide 2 criteria input
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... I want to filter out the rows which column A is any of the ... I want to auto-filter a spreadsheet with 6 criteria, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Copying, Pasting and Saving as (delimted.txt) on seperate sheets
    ... Then it does an advanced filter to show the unique entries ... Dim myCell As Range ... have a series of numbers that Cells E, F, G and H link to. ...
    (microsoft.public.excel.programming)
  • Re: Validation of data in a cell
    ... Why do the filter, why not just assume that value? ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... Danie wrote: ...
    (microsoft.public.excel.misc)
  • Re: SUMIF formula while filtering
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... only reflect when I filter by data in column H. Any ideas?- Hide quoted text - ... when I put it on mind it's coming up with "0" ...
    (microsoft.public.excel.worksheet.functions)