Results 1 to 4 of 4

Excel Function Required-2

This is a discussion on Excel Function Required-2 within the Excel Questions forums, part of the Question Forums category; I have a Excel workBook with 2 sheets. Sheet 1 contains 2 columns. And the data is like the below. ...

  1. #1
    New Member
    Join Date
    Apr 2003
    Posts
    4

    Default Excel Function Required-2

    I have a Excel workBook with 2 sheets.


    Sheet 1 contains 2 columns. And the data is like the below.

    Activity code Status
    P1 In Progress
    P2 Completed
    P3 In Progress
    P1 completed
    P2 in progress
    P3 Yet to start

    Activity codes will repeat here.


    Sheet 2 contains

    Activity code Status
    P1
    P2
    P3

    The status should be captured from sheet 1 based on the below logic.


    The scenario is like this

    If all are yet to start I have to return Yetto start

    If all are completed I have to return completed

    If any one is In Progress I have to return In Progress.

    For Example, For P1 I have In Progress and Completed.In this case I have to return In Progress.

    Any Help??

    Thanks
    Sk5567

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    390

    Default

    Text deleted, because the same question (same author) is posted here

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    65,229

    Default



    Impatient aren't we?

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    390

    Default

    sk5567, please don't ask the same question two times in different messages within 3 minutes !

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com