+ Reply to Thread
Results 1 to 4 of 4

Mark for given part and all its immediate lower level as `Yes'.

  1. #1
    Forum Contributor
    Join Date
    02-15-2016
    Location
    India
    MS-Off Ver
    2016
    Posts
    657

    Mark for given part and all its immediate lower level as `Yes'.

    Hello


    If `AKVC-AAKXA' found anywhere then that part and all its immeditate lower levels should be marked as Yes.

    I have tried this in `Tried Formula in Column D' with formulas (Column D) and helper formulas (Column C) but gettign error result in the green bolded text rows.

    Thanks in advance
    Sekar

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: Mark for given part and all its immediate lower level as `Yes'.

    If you can accept solution with VBA code, see attachment, and rum macro test.

    By the way it shows that also row 1960 shall be marked Yes :-)
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: Mark for given part and all its immediate lower level as `Yes'.

    Formula equivalent (keeping helper column, but with different contents):
    C2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    D2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    And copy both formulae all the way down

  4. #4
    Forum Contributor
    Join Date
    02-15-2016
    Location
    India
    MS-Off Ver
    2016
    Posts
    657

    Re: Mark for given part and all its immediate lower level as `Yes'.

    Hello Kaper

    Thank you

    This is exactly what i want, I will use your formula solution.

    Thanks again.

+ 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. copying a formula to 8 cells lower with a result of 1 cell lower
    By dyosa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-21-2014, 11:52 PM
  2. Posisible to Disable Save As at Program level (not workbook level)??
    By brian6464 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 02:49 PM
  3. Bill of Materials conversion from multi level to single level
    By susmitpatel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-11-2013, 12:53 AM
  4. Replies: 7
    Last Post: 09-10-2012, 09:18 PM
  5. Replies: 0
    Last Post: 09-23-2011, 01:01 AM
  6. Can't get VBA code to do task at worksheet level not workbook level
    By lealea1982 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2011, 10:22 AM
  7. high and low level part numbers
    By stevekirk in forum Excel General
    Replies: 1
    Last Post: 01-25-2007, 10:25 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