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
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

Or you could do like this:

First, create a [Index] column in "Edit Queries";

Second, create a calculated column:

Column = 
VAR x = MOD([Index], 2)
RETURN
IF(
    x = 0,
    BLANK(),
    [C3]
)

 

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.

 

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?