Bonbon ede nou delivre sèvis nou yo. Lè l sèvi avèk sèvis nou yo, ou dakò pou nou sèvi ak bonbon.
Ide: Lòt lang yo se Google-tradui. Ou ka vizite a English vèsyon nan lyen sa a.
Ouvri yon sesyon
x
or
x
x
enskri
x

or

Byen vit konpare de chenn nan chwazi / lonbraj kopi oswa valè inik nan Excel

Nòmalman, ou ka sèvi ak fonksyon an fòma kondisyonèl jwenn diferans ki genyen ant de chenn nan Excel. Men, li twò konplèks yo sèvi ak. Kutools pou Excel'S Chwazi menm & Selil diferan sèvis piblik ka ede w fasil chwazi oswa lonbraj kopi oswa inik valè ki baze sou chak selil ranje oswa sèl nan Excel.

Konpare de chenn ak jwenn menm oswa diferan dosye ki baze sou chak ranje

Konpare de chenn ak jwenn selil menm oswa diferan ki baze sou selil sèl


Klike sou Kutools > Chwazi> Chwazi menm & Selil diferan. Al gade nan Ekran:

piki konpare chenn001  2 piki konpare chenn 02

Konpare de chenn ak jwenn menm oswa diferan dosye ki baze sou chak ranje

1. Kenbe desann Ktrl kle nan chwazi de chenn ke ou vle konpare jan sa a (Al gade nan Ekran). nòt: Sa a sèvis piblik pral chwazi Doublon nan Range A. Ou ka presize Range A a ak ranje B atravè fichye diferan ak manyèl.

piki konpare chenn 03

2. Aplike sèvis piblik sa a ak nan Chwazi menm & Selil diferan bwat dyalòg, ou ka presize opsyon sa yo:

(1.) Si ou pa chwazi chenn yo nan Step1, ou ka klike sou bouton yo chwazi Jwenn valè nan (Range A) ak Selon (Range B) ke ou vle konpare.

(2.) Si gen Tèt nan done ou epi ou vle inyore konpare yo, tanpri tcheke Done mwen gen tit opsyon.

(3.) Chwazi Chak ranje Anba a Baze sou seksyon.

(4.) Espesifye Menm valè or Valè diferan anba Jwenn seksyon nan rechèch ranje oswa ranje inik ant de chenn.

(5.) Ou ka ranpli valè yo kopi oswa inik ak koulè background oswa koulè font jan ou renmen pa tcheke Ranpli backcolor or Ranpli koulè font Anba a Pwosesis rezilta yo seksyon.

(6.) Si ou vle chwazi ranje yo tout antye nan ranje a itilize, tanpri tcheke Chwazi tout ranje opsyon. Tcheke Ka sansib opsyon, si ou vle ka-sansib konpare.

piki konpare chenn 04

3. Klike sou OK, ak dosye yo menm oswa diferan yo pral chwazi kòm byen ke gen koulè pal tankou sa yo Ekran yo montre:

piki konpare chenn 05
piki konpare chenn 06

nòt:

1. Done mwen gen tit opsyon pral inyore selil yo header pandan y ap konpare de chenn.

2. Nan Jwenn valè nan (Range A) ak Selon (Range B) dwe gen menm kantite kolòn pandan wap konpare de chenn yo.

3. Sa a sèvis piblik ap chwazi duplicates yo oswa valè inik nan Range A pandan konpare de chenn. Si ou vle chwazi doublay yo oswa valè inik nan Range B, ou jis bezwen echanj de chenn yo.

4. Ou ka presize Range A ak Ranje B atravè fich diferan.


Konpare de chenn ak jwenn selil menm oswa diferan ki baze sou selil sèl

Itilite sa a ka ede ou konpare de chenn yo epi jwenn menm selil oswa diferan selil ki baze sou selil sèl. Tanpri fè jan sa a:

1. Kenbe desann Ktrl kle nan chwazi de chenn ke ou vle konpare jan sa a (Al gade nan Ekran). nòt: Sa a sèvis piblik pral chwazi Doublon nan Range A. Ou ka presize Range A a ak ranje B atravè fichye diferan ak manyèl.

piki konpare chenn 07

2. Nan Chwazi menm & Selil diferan bwat dyalòg, ou ka presize opsyon sa yo:

(1.) Si ou pa chwazi chenn yo nan Step1, ou ka klike sou bouton yo chwazi Jwenn valè nan (Range A) ak Selon (Range B) ke ou vle konpare.

(2.) Chwazi Selil sèl Anba a Baze sou seksyon.

(3.) Espesifye Menm valè or Valè diferan anba Jwenn seksyon nan rechèch selil kopi oswa inik ant de chenn.

(4.) Ou ka ranpli valè yo kopi oswa inik ak koulè background oswa koulè font jan ou renmen pa tcheke Ranpli backcolor or Ranpli koulè font Anba a Pwosesis rezilta yo seksyon.

(5.) Tcheke Ka sansib opsyon, si ou vle ka-sansib konpare

piki konpare chenn 08

3. Apre fini anviwònman yo, tanpri klike sou Ok, ak selil yo menm oswa diferan ki baze sou sèl selil yo chwazi ak ki gen koulè nan Range A kòm swiv:

piki konpare chenn 09
piki konpare chenn 10

nòt:

1. Sa a sèvis piblik ap chwazi duplicates yo oswa valè inik nan Range A pandan konpare de chenn. Si ou vle chwazi doublay yo oswa valè inik nan Range B, ou jis bezwen echanj de chenn yo.

2. Ou ka presize Range A ak Ranje B atravè fich diferan.


Zouti Productivity Rekòmande
Zouti sa yo ka anpil sove tan ou ak lajan, ki yon sèl ki bon pou ou?
Biwo Tab: Sèvi ak onglè sou lamen nan biwo ou, kòm wout la nan Chrome, Firefox ak New Internet Explorer.
Kutools pou Excel: Plis pase 300 Fonksyon avanse pou Excel 2019, 2016, 2013, 2010, 2007 ak Biwo 365.
Klasik Menu pou Biwo: Pote meni yo abitye nan Biwo 2007, 2010, 2013, 2016, 2019 ak 365, tankou si li te Biwo 2000 ak 2003.

Kutools pou Excel

Fonksyonalite ki dekri pi wo a se jis youn nan fonksyon 300 pwisan nan Kutools pou Excel.

Ki fèt pou Excel (Biwo) 2019, 2016, 2013, 2010, 2007 ak Biwo 365. Gratis download epi itilize pou jou 60.

Piki ekran nan Kutools pou Excel

btn li plis btn download achte 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 · 8 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