Results 1 to 7 of 7

pulling values from a column and reordering them in another column without spaces

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2008
    Location
    new york
    Posts
    14

    pulling values from a column and reordering them in another column without spaces

    Hi,

    I have a couple of columns that look like this in basic form:

    Column A Column B
    A 1
    B 1
    C 0
    D 2
    E 1
    F 0
    G 2

    What I want is in a separate worksheet for it to pull the names (A, B, E) that have 1s next to them in column B and put them in a list.

    I could do this kinda manually, but how can I create a nice list in a separate column on a separate worksheet just of the names (column A values) where there is a 1 in column B? All I can think to do is vlookup the data and put blanks where its not equal to 1 and then manually delete out the other rows.

    Thanks a lot for the help
    Last edited by rantarctica; 12-11-2008 at 04:11 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