Next name down a list

[djfatboyfats]

Hi

I need a formula/vba function that will select the next name down on a list and place it in another cell, lets say for example we have names in cells A1:A20 names go as follows:

DJ
DJ
DJ
AC
AC
FB
FB

Now starting in column b i want a formula/vba that will look for the next name down column a and place it in the cells so i get

DJ
AC
FB

Thanks in advance

DJ

[Mikeopolo]

See http://www.cpearson.com/excel/DistinctValues.aspx for a VBA function which will do this.

Regards
Mike

[djfatboyfats]

page not working

[Mikeopolo]

Curious, works for me; try going to Chip's home page and follow the links from there.

[Ron Coderre]

With
A1:A10 containing this list, with A1 as the heading:

Please Login or Register  to view this content.

and
B1: SeqList

If the list will not contain any all-numeric entries, this formula begins listing
each unique name, as it is encountered

Please Login or Register  to view this content.

Copy that formula down as far as you need.

(If the list will include numeric entries, there's longer formula to use)

In the above example, the following values are returned by the formulas
in B2:B5

Please Login or Register  to view this content.

Does that help?

[djfatboyfats]

no still not working, keep getting "Configuration error" tried it on firefox and Internet explorer, thanks anyway. do you know the answer so you could post on here or is to complex?

Thanks

DJ

[djfatboyfats]

Sorted, thanks very much