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

Above solution doesn't work

 

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.