+ Reply to Thread
Results 1 to 6 of 6

Formula to find header and insert in new column

  1. #1
    Registered User
    Join Date
    12-02-2012
    Location
    Perth
    MS-Off Ver
    Excel 2007
    Posts
    8

    Formula to find header and insert in new column

    Hi,

    First post so sorry if I'm not that clear.

    I'm hoping someone can help me with a formula I've been searching and found similar problems but not specific enough. I'm trying to find one of four potential headers in column B and insert it into a blank column A alongside each row it corresponds to. The report comes like this and I need to sort it before entering into a database.

    It doesn't have to be that clean I can let the database do that, I just need to have the correct header in the new column.

    I've attached what it looks like and what I'm trying to get, thanks in advance

    DB
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Formula to find header and insert in new column

    Hi

    Definitely not clean but....

    A3: =IF(ISNUMBER(B3),A2,B3)

    HTH

    rylo

  3. #3
    Registered User
    Join Date
    12-02-2012
    Location
    Perth
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Formula to find header and insert in new column

    Thanks Rylo

    Unfortunately the formula will only work if I delete the blank cells in B4, 11 & 19. Is there a quicker way?

    edit to remove second question, found answer
    Last edited by dbracken1; 12-03-2012 at 01:42 AM.

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2010
    Posts
    4,332

    Re: Formula to find header and insert in new column

    try this one...

    I didn't see your second question so probably I'm assuming the attached file is as-is.
    In A5


    Formula: copy to clipboard
    Please Login or Register  to view this content.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  5. #5
    Registered User
    Join Date
    12-02-2012
    Location
    Perth
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Formula to find header and insert in new column

    that works great thanks a lot vlady

  6. #6
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2010
    Posts
    4,332

    Re: Formula to find header and insert in new column

    Your welcome.
    Thank also.

+ Reply to Thread

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