Results 1 to 6 of 6

If row 1 contains <text> add column value A1 (<name>) to separate sheet

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2014
    Location
    Oslo
    MS-Off Ver
    Mac
    Posts
    4

    Question If row 1 contains <text> add column value A1 (<name>) to separate sheet

    Greetings all!

    I have an exported CSV file from a ticket system, but all tickets ordered by participants are sitting a row with columns of ticket/show names.
    We need to sort all the names out for the right ticket lists.

    What formula I need:
    If row 1 contains <"text"> add column value A1 (<name>) to separate sheet.

    In the example on attached image it would be:
    If row 1 contains "Tine Salling - Entre Nous" then add column value A1 ("Tessa Geraldino") to separate sheet (or i.e. A13.)

    DOWNLOAD AND WORK ON EXAMPLE FILE HERE:
    https://www.dropbox.com/s/9q8klhdrgd...mary.xlsx?dl=0


    Screen Shot 2014-10-28 at 13.15.33.png
    Last edited by imikeyr; 10-28-2014 at 08:58 AM. Reason: added file

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Match Multiple Columns from Separate Sheet to get separate column.
    By gvitoro in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-19-2014, 03:38 PM
  2. Transposing multiple rows from one sheet into one column on separate sheet
    By zcarroll in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-06-2013, 01:03 PM
  3. Replies: 3
    Last Post: 08-16-2012, 03:25 PM
  4. Replies: 10
    Last Post: 03-08-2012, 12:31 PM
  5. Replies: 1
    Last Post: 01-12-2012, 07:50 PM

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