+ Reply to Thread
Results 1 to 4 of 4

how to make search that finds the "x"s in a long list and posts them in consecutive cells

  1. #1
    Registered User
    Join Date
    05-22-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    how to make search that finds the "x"s in a long list and posts them in consecutive cells

    my goal is to set up the excel file like this:

    list of foods in column A
    food group options in columns B - E
    mark appropriate food group column with "x"
    in columns H - K, paste all foods in column B with an "x" into H, all foods in column C with an "x" into I, and so on and so forth

    there are about 20 foods listed in column A, with the food groups not sorted vertically (ie. column B food group in cells A3 and A12, column C food group in cells A5, A9, A16). I would like to write a file that can search through column B, C, etc. find the cells marked with an "x", and display the respective cells column A equivalent into column H, I, etc.

    The problem I am having is with the pasting of the column A output. I can only get it so that the A output will show up in the same row as the input, I would like it so the results show up in consecutive H,I, etc. vertical cells regardless of position in A.

    Input: "x" in B3 and B12.
    What I want Output: A3 and A12 in H2, H3.
    What I have Output: A3 and A12 in H3 and H12

    Apologies about length, hope what i want was clear, i appreciate all comments.

    thanks,
    David

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: how to make search that finds the "x"s in a long list and posts them in consecutive ce

    Moved...

    A small workbook example would be helpfull

  3. #3
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: how to make search that finds the "x"s in a long list and posts them in consecutive ce

    zbor, could you loosen up on the deleting of posts
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: how to make search that finds the "x"s in a long list and posts them in consecutive ce

    hmm, sorry abousetta, didn't delete it.. Probably is still somewhere there
    Didn't even notice it's missing...

    urbi er orbi: abousetta is responsible that this post went to desired address

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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