Results 1 to 4 of 4

Thread: how to compare 2 sheets and mark the duplicate values?

  1. #1

    how to compare 2 sheets and mark the duplicate values?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    the values at first and second sheet:
    z.xlsx
    is possible to mark at the second sheet,the duplicate values in these 2 sheets?

    something like that:
    zm2.xlsx
    is possible?

  2. #2
    Try conditional formatting with a formula of

    =COUNTIF([z.xlsx]Φύλλο1!$A$1:$D$6,B1)>0

  3. #3
    i tried but nothing! doesn't mark the values.

    i tried this =match("Φύλλο1!$A$1:$D$6";B1)>0
    and give me that:z3.xlsx
    Last edited by zois; 2015-01-12 at 06:28 PM.

  4. #4
    sorry that:z4.xlsx

Tags for this Thread

Posting Permissions

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