Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

extract single value

Hi, in the attached sheet, C4 extracts the unique values from C3 with conditions   C1-A && C2-P1in C4 - 500, If C2 is duplicated single value should consider in C4.   Hence the reuired Column is...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

It need not in a sequence .. the records in C3 will not be in sequence. In that how to resolve this?

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Above solution doesn't work

 

  • edhans's avatar
    edhans
    Community Champion
    6 years ago

    Anonymous can you be more specific? You keep saying for us to share the file, but my first post has the file link. 

     

    THen you keep responding that something isn't working. Can you please tell us EXACTLY what isn't working and what your expected output is? Help us help you. Just saying "it doesn't work" isn't helpful. Our solutions do work if implemented correctly and if we understand your requirements. You have to be very clear about what those requirements are, and what exactly isn't working to give those requirements

     

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    First sort the [C1] column in ascending order, then sort the [C2] column in ascending order, and finally add the [Index] column:

    Column = MOD(Sheet3[Index], 2)
    Column 2 = 
IF(
    [Column] = 1,
    [C3],
    BLANK()
)

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.