Kidokezo: Lugha zingine ni Google-Ilitafsiriwa. Unaweza kutembelea English toleo la kiungo hiki.
Ingia
x
or
x
x
Daftari
x

or

Haraka kulinganisha safu mbili ili kuchagua / kivuli duplicate au maadili ya kipekee katika Excel

Kwa kawaida, unaweza kutumia kazi ya kupangilia masharti ili kujua tofauti kati ya safu mbili za Excel. Lakini ni ngumu sana kutumia. Kutools kwa Excel'S Chagua Same na Masiko tofauti utumishi unaweza kukusaidia urahisi kuchagua au kivuli duplicate au maadili ya kipekee kulingana na kila safu au seli moja katika Excel.

Linganisha safu mbili na kupata rekodi sawa au tofauti kulingana na kila safu

Linganisha safu mbili na kupata seli sawa au tofauti kulingana na seli moja


Bonyeza Kutools > Chagua> Chagua Siri na Sifa tofauti. Tazama viwambo vya skrini:

risasi kulinganisha safu001  2 risasi kulinganisha safu 02

Linganisha safu mbili na kupata rekodi sawa au tofauti kulingana na kila safu

1. Weka CTRL ufunguo wa kuchagua safu mbili ambazo unataka kulinganisha kama ifuatavyo (Ona Screenshot). Kumbuka: Huduma hii itachagua marudio katika Kipengee A. Unaweza kutaja Rangi A na Rangi B katika vitabu tofauti na vitabu vya kazi.

risasi kulinganisha safu 03

2. Tumia programu hii na katika Chagua Same na Masiko tofauti dialog box, unaweza kutaja chaguzi zifuatazo:

(1.) Ikiwa huna kuchagua viwango katika Step1, unaweza kubofya kifungo kuchagua Pata maadili katika (Rangi A) na Kwa mujibu wa (Rangi B) kwamba unataka kulinganisha.

(2.) Ikiwa kuna vichwa katika data yako na unataka kupuuza kulinganisha yao, tafadhali angalia Data yangu ina vichwa vya habari chaguo.

(3.) Chagua Kila safu chini ya Kulingana na sehemu.

(4.) Taja Maadili sawa or Maadili tofauti chini ya Pata sehemu kutafuta duplicate au safu ya kipekee kati ya safu mbili.

(5.) Unaweza kujaza maadili ya duplicate au ya kipekee na rangi ya asili au rangi ya font kama unavyopenda kwa kuangalia Jaza backcolor or Jaza rangi ya font chini ya Usindikaji wa matokeo sehemu.

(6.) Ikiwa unataka kuchagua safu nzima ndani ya viwango vya kutumika, tafadhali angalia Chagua safu nzima chaguo. Angalia Kesi nyeti chaguo, ikiwa unataka kulinganisha kesi.

risasi kulinganisha safu 04

3. Bonyeza OK, na rekodi sawa au tofauti zitachaguliwa pamoja na rangi kama skrini ifuatayo iliyoonyeshwa:

risasi kulinganisha safu 05
risasi kulinganisha safu 06

Notes:

1. Data yangu ina vichwa vya habari chaguo itapuuza seli za kichwa ikilinganishwa na safu mbili.

2. The Pata maadili katika (Rangi A) na Kwa mujibu wa (Rangi B) Lazima uwe na idadi sawa ya nguzo wakati wa kulinganisha safu mbili.

3. Huduma hii itachagua marudio au maadili ya kipekee katika Rangi A wakati wa kulinganisha safu mbili. Ikiwa unataka kuchagua duplicates au maadili ya kipekee katika Rangi B, unahitaji tu kubadili safu mbili.

4. Unaweza kutaja Rangi A na Rangi B kwenye karatasi tofauti za kazi.


Linganisha safu mbili na kupata seli sawa au tofauti kulingana na seli moja

Huduma hii pia inaweza kukusaidia kulinganisha safu mbili na kupata maadili sawa au tofauti ya kiini kulingana na seli moja. Tafadhali fanya kama ifuatavyo:

1. Weka CTRL ufunguo wa kuchagua safu mbili ambazo unataka kulinganisha kama ifuatavyo (Ona Screenshot). Kumbuka: Huduma hii itachagua marudio katika Kipengee A. Unaweza kutaja Rangi A na Rangi B katika vitabu tofauti na vitabu vya kazi.

risasi kulinganisha safu 07

2. Ndani ya Chagua Same na Masiko tofauti dialog box, unaweza kutaja chaguzi zifuatazo:

(1.) Ikiwa huna kuchagua viwango katika Step1, unaweza kubofya kifungo kuchagua Pata maadili katika (Rangi A) na Kwa mujibu wa (Rangi B) kwamba unataka kulinganisha.

(2.) Chagua Seli moja chini ya Kulingana na sehemu.

(3.) Taja Maadili sawa or Maadili tofauti chini ya Pata sehemu kutafuta duplicate au seli za kipekee kati ya safu mbili.

(4.) Unaweza kujaza maadili ya duplicate au ya kipekee na rangi ya asili au rangi ya font kama unavyopenda kwa kuangalia Jaza backcolor or Jaza rangi ya font chini ya Usindikaji wa matokeo sehemu.

(5.) Angalia Kesi nyeti chaguo, ikiwa unataka kulinganisha kesi

risasi kulinganisha safu 08

3. Baada ya kumaliza mipangilio, tafadhali bonyeza Ok, na seli sawa au tofauti kulingana na seli moja ni kuchaguliwa na rangi katika Rangi A kama kufuata:

risasi kulinganisha safu 09
risasi kulinganisha safu 10

Notes:

1. Huduma hii itachagua marudio au maadili ya kipekee katika Rangi A wakati wa kulinganisha safu mbili. Ikiwa unataka kuchagua duplicates au maadili ya kipekee katika Rangi B, unahitaji tu kubadili safu mbili.

2. Unaweza kutaja Rangi A na Rangi B kwenye karatasi tofauti za kazi.


Zana za Uzalishaji Zilizopendekezwa
Vifaa vifuatavyo vinaweza kuokoa muda na pesa yako, ni moja ambayo ni sawa kwako?
Tabia ya Ofisi: Kutumia vichupo vyema katika Ofisi yako, kama njia ya Chrome, Firefox na New Internet Explorer.
Kutools kwa Excel: Zaidi ya kazi za juu za 300 kwa Excel 2019, 2016, 2013, 2010, 2007 na Ofisi 365.
Menyu ya Classic ya Ofisi: Kurudia menus familiar kwa Ofisi 2007, 2010, 2013, 2016, 2019 na 365, kama ilivyo Ofisi ya 2000 na 2003.

Kutools kwa Excel

Kazi iliyoelezwa hapo juu ni moja tu ya kazi za 300 za Kutools kwa Excel.

Iliyoundwa kwa Excel (Ofisi) 2019, 2016, 2013, 2010, 2007 na Ofisi ya 365. Pakua na kupakua kwa siku za 60.

Screen shot ya Kutools kwa Excel

btn kusoma zaidi Btn shusha ununuzi wa btn

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Chris · 10 months ago
    When comparing two columns where the duplicate values in further down a column it doesn't match.
    column A, Column B
    3333, 4444
    222,333
    4444,3222


    I need to match the 4444 with the 4444 in the first column. Is there a way to do this? From your example they need to be right next to each other.
  • To post as a guest, your comment is unpublished.
    Howard Briggs · 1 years ago
    Hi
    I have a a column with multiple names of a person and another columns with a classification rating i.e. Excellent, Very Good,Good, Fair. Poor
    I need to count the number of times a particular person has been awarded Excellent in one column and in the next column Good etc.
    The person appears in the list several times so it needs to allow for more than one entry of the person.

    Many thanks
  • To post as a guest, your comment is unpublished.
    Susanne · 4 years ago
    I haven't bought the product yet, want to try it out first. But I found that I can't use the function Compare Range, the rows are "grey" and do not come up with anything.

    Do I do something wrong or don't I have the correct version for test?
    Rgds
    Susanne
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="Susanne"]I haven't bought the product yet, want to try it out first. But I found that I can't use the function Compare Range, the rows are "grey" and do not come up with anything.

      Do I do something wrong or don't I have the correct version for test?
      Rgds
      Susanne[/quote]
      Please try to contact me with more detailed information of your issue at jaychivo#extendoffice.com, please replace # with @.

      Or please try to create some sample data in new workbook and try it out.

      If the problem persists with the sample workbook, please attache it in your email. :-)
  • To post as a guest, your comment is unpublished.
    Jenna · 4 years ago
    Does Kutools have a feature where duplicates from a column are removed, but also case sensitive? Excel has the remove duplicates feature, but isn't case sensitive.

    For example, if I have:
    dog
    doG
    dog

    I want a feature where it only removes "dog", but not the one with the upper case. Does Kutools have such feature?
    Thanks.
    • To post as a guest, your comment is unpublished.
      Admin_jay · 4 years ago
      [quote name="Jenna"]Does Kutools have a feature where duplicates from a column are removed, but also case sensitive? Excel has the remove duplicates feature, but isn't case sensitive.

      For example, if I have:
      dog
      doG
      dog

      I want a feature where it only removes "dog", but not the one with the upper case. Does Kutools have such feature?
      Thanks.[/quote]

      Thanks for your feedback. We will try to enhance our feature in upcoming versions. :-)
  • To post as a guest, your comment is unpublished.
    Raft334 · 4 years ago
    Same with me.....the highlights disappeared when I select any cell on the worksheet