+ Reply to Thread
Results 1 to 2 of 2

Help with a formula to create a viewing heirarchy please

  1. #1
    Registered User
    Join Date
    02-11-2013
    Location
    Wash DC
    MS-Off Ver
    Excel 2010
    Posts
    5

    Help with a formula to create a viewing heirarchy please

    sample report to post on Excel Forum.zipexample for Excel Form.jpgI have a worksheet with several thousand rows of data which needs to be summarized. Please see an example of 10 rows below. What I need to do is display the results in a heirarchy. For example, look through all the rows and post the first response to Item. In the example I have attached, the formula should:

    - look at all rows with a Project number 01. A
    - if any of those rows has the number 1 in column E, show the first row in the listing and ignore all other rows (even if there is a number 1 in column E)
    - if none of the rows for project number 01. A has a number 1 in column E, then look at column F and show the first row that has a number 1 in column F
    - if none of the rows for project number 01. A has a number 1 in columns E or F, then look at column G and display the first row that has a number 1 in column F.
    - if none of the rows for project number 01.A has a number 1 in columns E, F, and G, then show the first row that occurs with a number 1 in column H (the N/A column)

    Thanks so much for your help! If you think this can be accomplished easier using VBA would appreciate advice on that.


    example for Excel Form.jpg
    Last edited by walkitoff; 09-06-2013 at 10:48 AM.

  2. #2
    Registered User
    Join Date
    02-11-2013
    Location
    Wash DC
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Help with a formula to create a viewing heirarchy please

    Attaching actual .xlsx file also.
    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. Condition Formatting - Viewing CF formula at each cell
    By rwgrietveld in forum Excel General
    Replies: 4
    Last Post: 01-06-2010, 03:33 PM
  2. create static headers for sorting and viewing data
    By photoguy in forum Excel General
    Replies: 3
    Last Post: 10-02-2008, 11:14 AM
  3. Viewing in web
    By Corrine in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-26-2006, 02:35 PM
  4. Viewing only the #’s
    By sungen99 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-25-2006, 12:10 PM
  5. Replies: 7
    Last Post: 08-22-2005, 08:05 AM

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