Skip to main content

Déan comparáid tapa idir dhá raon chun luachanna dúblacha nó uathúla in Excel a roghnú / scáthú

Kutools le haghaidh Excel

Treisíonn Excel Le 300+
Gnéithe cumhachtacha

De ghnáth, is féidir leat an fheidhm Formáidithe Coinníollach a úsáid chun na difríochtaí idir dhá raon in Excel a fháil amach. Ach tá sé ró-chasta le húsáid. Kutools le haghaidh Excel'S Roghnaigh Cealla Mar an gcéanna & Éagsúla is féidir le fóntais cabhrú leat luachanna dúblacha nó uathúla a roghnú nó a scáthú bunaithe ar gach ró nó cill aonair in Excel.

Déan comparáid idir dhá raon agus faigh na taifid chéanna nó taifid dhifriúla bunaithe ar gach ró

Déan comparáid idir dhá raon agus faigh na cealla céanna nó cealla difriúla bunaithe ar chill aonair


cliceáil Kutools > Roghnaigh> Roghnaigh Cealla Mar an gcéanna & Éagsúla. Féach screenshots:

lámhaigh comparáid a dhéanamh idir raonta001 2 lámhaigh comparáid a dhéanamh idir raonta 02

 Déan comparáid idir dhá raon agus faigh na taifid chéanna nó taifid dhifriúla bunaithe ar gach ró

1. Coinnigh síos CTRL eochair chun dhá raon a roghnú ar mhaith leat comparáid a dhéanamh mar a leanas (Féach Gabháil scáileáin). nótaí: Roghnóidh an fóntais seo dúbailtí i Raon A. Is féidir leat Raon A agus Raon B a shonrú thar bhileoga oibre agus leabhair oibre éagsúla.

lámhaigh comparáid a dhéanamh idir raonta 03

2. Cuir an fóntais seo i bhfeidhm agus sa Roghnaigh Cealla Mar an gcéanna & Éagsúla bosca dialóige, is féidir leat na roghanna seo a leanas a shonrú:

(1.) Mura roghnaíonn tú na raonta i gCéim 1, is féidir leat cliceáil cnaipe a roghnú Faigh luachanna in (Raon A) agus De réir (Raon B) gur mhaith leat comparáid a dhéanamh.

(2.) Má tá ceanntásca i do chuid sonraí agus gur mhaith leat neamhaird a dhéanamh ar iad a chur i gcomparáid, seiceáil le do thoil Tá ceanntásca ar mo chuid sonraí rogha.

(3.) Roghnaigh Gach as a chéile faoi ​​na Bunaithe ar alt seo.

(4.) Sonraigh Luachanna céanna or Luachanna Éagsúla faoi Faigh an chuid chun sraitheanna dúblacha nó uathúla a chuardach idir dhá raon.

(5.) Is féidir leat na luachanna dúblacha nó uathúla a líonadh le dath cúlra nó dath cló mar is mian leat trí sheiceáil Líon backcolor or Líon dath cló faoi ​​na Próiseáil na dtorthaí alt seo.

(6.) Más mian leat na sraitheanna iomlána a roghnú laistigh den raon a úsáidtear, seiceáil le do thoil Roghnaigh sraitheanna iomlána rogha. Seiceáil Cás-íogair rogha, más mian leat comparáid cás-íogair.

lámhaigh comparáid a dhéanamh idir raonta 04

3. Cliceáil OK, agus roghnófar na taifid chéanna nó taifid dhifriúla chomh maith le daite mar a leanas an pictiúr a thaispeántar:

lámhaigh comparáid a dhéanamh idir raonta 05
lámhaigh comparáid a dhéanamh idir raonta 06

Nótaí:

1. Tá ceanntásca ar mo chuid sonraí tabharfaidh an rogha neamhaird ar na cealla ceanntásca agus dhá raon á gcur i gcomparáid.

2. An Faigh luachanna in (Raon A) agus De réir (Raon B) caithfidh an líon céanna colún a bheith acu agus dhá raon á gcur i gcomparáid.

3. Roghnóidh an fóntais seo na dúblacha nó na luachanna uathúla i Raon A le linn comparáid a dhéanamh idir dhá raon. Más mian leat na dúblacha nó na luachanna uathúla i Raon B a roghnú, ní gá duit ach an dá raon a mhalartú.

4. Is féidir leat Raon A agus Raon B a shonrú thar bhileoga oibre éagsúla.


 Déan comparáid idir dhá raon agus faigh na cealla céanna nó cealla difriúla bunaithe ar chill aonair

Is féidir leis an bhfóntas seo cabhrú leat dhá raon a chur i gcomparáid lena chéile agus na luachanna cille céanna nó luachanna difriúla a fháil bunaithe ar chill aonair. Déan mar a leanas le do thoil:

1. Coinnigh síos CTRL eochair chun dhá raon a roghnú ar mhaith leat comparáid a dhéanamh mar a leanas (Féach Gabháil scáileáin). nótaí: Roghnóidh an fóntais seo dúbailtí i Raon A. Is féidir leat Raon A agus Raon B a shonrú thar bhileoga oibre agus leabhair oibre éagsúla.

lámhaigh comparáid a dhéanamh idir raonta 07

2. Sa an Roghnaigh Cealla Mar an gcéanna & Éagsúla bosca dialóige, is féidir leat na roghanna seo a leanas a shonrú:

(1.) Mura roghnaíonn tú na raonta i gCéim 1, is féidir leat cliceáil cnaipe a roghnú Faigh luachanna in (Raon A) agus De réir (Raon B) gur mhaith leat comparáid a dhéanamh.

(2.) Roghnaigh Cill aonair faoi ​​na Bunaithe ar alt seo.

(3.) Sonraigh Luachanna céanna or Luachanna Éagsúla faoi Faigh an chuid cealla dúblacha nó uathúla a chuardach idir dhá raon.

(4.) Is féidir leat na luachanna dúblacha nó uathúla a líonadh le dath cúlra nó dath cló mar is mian leat trí sheiceáil Líon backcolor or Líon dath cló faoi ​​na Próiseáil na dtorthaí alt seo.

(5.) Seiceáil Cás-íogair rogha, más mian leat comparáid cás-íogair

lámhaigh comparáid a dhéanamh idir raonta 08

3. Tar éis duit na socruithe a chríochnú, cliceáil le do thoil Ok, agus roghnaítear agus dathaítear na cealla céanna nó cealla difriúla atá bunaithe ar chill aonair i Raon A mar seo a leanas:

lámhaigh comparáid a dhéanamh idir raonta 09
lámhaigh comparáid a dhéanamh idir raonta 10

Nótaí:

1. Roghnóidh an fóntais seo na dúblacha nó na luachanna uathúla i Raon A le linn comparáid a dhéanamh idir dhá raon. Más mian leat na dúblacha nó na luachanna uathúla i Raon B a roghnú, ní gá duit ach an dá raon a mhalartú.

2. Is féidir leat Raon A agus Raon B a shonrú thar bhileoga oibre éagsúla.


Uirlisí Táirgiúlachta Molta
Féadann na huirlisí seo a leanas do chuid ama agus airgid a shábháil go mór, cé acu ceann atá ceart duitse?
Cluaisín Oifige: Cluaisíní úsáideacha a úsáid i d’Oifig, mar bhealach Chrome, Firefox agus New Internet Explorer.
Kutools le haghaidh Excel: Níos mó ná 300 Ardfheidhmeanna le haghaidh Excel 2021, 2019, 2016, 2013, 2010, 2007 agus Oifig 365.

Kutools le haghaidh Excel

Níl san fheidhmiúlacht a thuairiscítear thuas ach ceann de 300 feidhm chumhachtach atá ag Kutools le haghaidh Excel.

Deartha do Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 agus Office 365. Íoslódáil agus úsáid saor in aisce ar feadh 30 lá.

Scáileán de Kutools le haghaidh Excel

btn léamh níos mó      btn íoslódáil     ceannach btn

Comments (11)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
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
This comment was minimized by the moderator on the site
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
This comment was minimized by the moderator on the site
[quote]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 SusanneBy 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. :-)
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
[quote]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.By Jenna[/quote] Thanks for your feedback. We will try to enhance our feature in upcoming versions. :-)
This comment was minimized by the moderator on the site
Same with me.....the highlights disappeared when I select any cell on the worksheet
This comment was minimized by the moderator on the site
Is it possible to identify and permanently highlight the duplicate cells in 2 columns please?
This comment was minimized by the moderator on the site
Yes, you can. You just need to use this utility to select the duplicates and then please apply colors to highlight them. :)
This comment was minimized by the moderator on the site
[quote]Yes, you can. You just need to use this utility to select the duplicates and then please apply colors to highlight them. :)By adminjay[/quote] Is there some special trick to selecting those cells that are highlighted? 'select cells by format' perhaps? As soon as I selected one of the duplicates, all of the highlights disappeared.
This comment was minimized by the moderator on the site
Thanks Jay - that works great. Much appreciated Deesale
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations