Results 1 to 7 of 7

Next name down a list

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-24-2006
    Location
    Sevenoaks, Kent
    MS-Off Ver
    Office 365 ProPlus
    Posts
    459

    Next name down a list

    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
    Last edited by djfatboyfats; 11-23-2008 at 09:49 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1