+ Reply to Thread
Results 1 to 1 of 1

Need help with formula that converts table into columns and additional conversion

  1. #1
    Registered User
    Join Date
    12-12-2013
    Location
    California
    MS-Off Ver
    Excel Mac 2011
    Posts
    1

    Need help with formula that converts table into columns and additional conversion

    Hello,

    This is my first post on this site. I have used this site to answer my numerous excel questions. Thank you all.

    I need some help on some unique requirements.

    I have attached a spreadsheet with sample data and required result (in yellow).

    Brief explanation: I have unlimited number of employees (John Doe, Kelly Clark,etc), their Date of Birth, 3 person types (Employee,Spouse and Child) and 3 Plans (A, B and C).

    If Employee DOB is not null then insert a row for each plan (A, B, C) for that employee with type (Fname_lname_Plan) and coverage =1
    If Spouse DOB is not null then insert row for each plan (A, B, C) for that employee with type (Fname_lname_Plan) and coverage =2
    If Child DOB is not null then insert row for each plan(A, B, C) for that employee with type (Fname_lname_Plan) and coverage =3
    If all Employee,Spouse and Child DOB are not null then insert row for each plan(A, B, C) for that employee with type (Fname_lname_Plan) and coverage =4

    I have tried using MATCH and OFFSET function but being a novice at excel, couldn't figure it out.

    Any help is really appreciated. Please let me know if you need any additional information.

    Thank you!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Altering a formula to sort two additional columns of text
    By Tom T Hall in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-08-2013, 08:56 PM
  2. [SOLVED] Macro that converts today()+3 in to text on 2 columns
    By phish3rz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-24-2012, 02:13 PM
  3. Macro that converts today()+3 in to text on 2 columns
    By phish3rz in forum Excel General
    Replies: 3
    Last Post: 12-24-2012, 02:03 PM
  4. Pivot Table adding additional columns excel 2007
    By runner in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-28-2012, 12:24 PM
  5. Dynamic Count If Formula with additional columns and rows.
    By nwd9s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2011, 09:12 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