Skip to Content

Highlight duplicate value in tow different blocks

capture.png

Highlight duplicate value in tow different blocks. Please refer to the image attached. Just wanted to know if this is possible.

capture.png (7.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 25, 2017 at 02:13 PM

    Yes it is, but you will have to merge your common dimension and create a variable or 2 and add conditional formatting

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Attached the screen shot. I have query from 2 DP. one from table(Material)and another from Excel(ITEM)

      I am doing an extended merge, so i can get matching as well as unmatching record

      The formula i am trying =If IsNull([LWVAL])<>0 Then "A" ElseIf IsNull([V_LastWeek_Data]<>0) Then "B" ElseIf IsNull([LWVAL])<>0 And IsNull([V_LastWeek_Data]<>0) Then "C" Else "NotDefined"

      1) 111 contains in both table (Material& Excel)

      2)121 only contains in Excel

      3)123 only contains in Material

      capture1.jpg

      capture1.jpg (21.3 kB)