Skip to main content

Conas comparáid a dhéanamh an bhfuil ilchealla cothrom le Excel?

Mar is eol dúinn uile, chun comparáid a dhéanamh an bhfuil dhá chealla cothrom, is féidir linn an fhoirmle A1 = B1 a úsáid. Ach, más mian leat a sheiceáil an bhfuil an luach céanna ag ilchealla, ní oibreoidh an fhoirmle seo. Labhróidh mé inniu faoi roinnt foirmlí le comparáid a dhéanamh an bhfuil ilchealla cothrom le Excel.

Déan comparáid idir an bhfuil ilchealla cothrom le foirmlí


mboilgeog cheart gorm saighead Déan comparáid idir an bhfuil ilchealla cothrom le foirmlí

Má tá an raon sonraí seo a leanas agam, ní mór dom a fháil amach an bhfuil na luachanna in A1: D1 comhionann, chun an tasc seo a réiteach, cuideoidh na foirmlí seo a leanas leat.

doc-seiceáil-más-comhionann-cealla-1

1. I gcill bhán seachas do chuid sonraí, iontráil an fhoirmle seo le do thoil: = AGUS (EXACT (A1: D1, A1)), (A1: D1 léiríonn sé na cealla ar mhaith leat comparáid a dhéanamh, agus A1 an chéad luach i do raon sonraí) féach an scáileán:

doc-seiceáil-más-comhionann-cealla-2

2. Ansin brúigh Ctrl + Shift + Iontráil eochracha le chéile chun an toradh a fháil, má tá na luachanna cille cothrom, taispeánfaidh sé TRUE, ar shlí eile, taispeánfaidh sé FALSE, féach ar an scáileán:

doc-seiceáil-más-comhionann-cealla-3

3. Agus roghnaigh an chill agus tarraing an láimhseáil líonta chuig an raon a theastaíonn uait an fhoirmle seo a chur i bhfeidhm, gheobhaidh tú an toradh mar seo a leanas:

doc-seiceáil-más-comhionann-cealla-4

Nótaí:

1. Tá an fhoirmle thuas íogair ó thaobh cásanna de.

2. Más gá duit na luachanna a chur i gcomparáid gan cás-íogair, is féidir leat an fhoirmle seo a chur i bhfeidhm: = COUNTIF (A1: D1, A1) = 4, (A1: D1 léiríonn sé na cealla ar mhaith leat comparáid a dhéanamh, A1 an chéad luach i do raon sonraí, agus an uimhir 4 tagraíonn sé do líon na gcealla a theastaíonn uait a sheiceáil más ea, ansin brúigh Iontráil eochair, agus gheobhaidh tú an toradh seo a leanas:

doc-seiceáil-más-comhionann-cealla-5


Déan comparáid idir dhá raon agus faigh amach an bhfuil na cealla cothrom nó nach bhfuil

Le Kutools le haghaidh Excel'S Déan comparáid idir Cealla fóntais, is féidir leat na luachanna céanna nó luachanna difriúla idir dhá chealla a fháil go tapa. Cliceáil chun Kutools a íoslódáil le haghaidh Excel!

Kutools le haghaidh Excel: le níos mó ná 300 breiseán áisiúil Excel, saor in aisce le triail gan aon teorannú i 30 lá. Íoslódáil agus triail saor in aisce Anois!


Airteagal gaolmhar:

Conas a sheiceáil an bhfuil an uimhir slánuimhir in Excel?

Uirlisí Táirgiúlachta Oifige is Fearr

🤖 Kutools AI Aide: anailís sonraí a réabhlóidiú bunaithe ar: Forghníomhú Chliste   |  Gin Cód  |  Cruthaigh Foirmlí Saincheaptha  |  Anailís a dhéanamh ar Sonraí agus Cairteacha a Ghin  |  Feidhmeanna Kutools a agairt...
Gnéithe Coitianta: Faigh, Aibhsigh nó Aithnigh Dúblaigh   |  Scrios Sraitheanna Bána   |  Comhcheangail Colúin nó Cealla gan Sonraí a Chailleadh   |   Babhta gan Foirmle ...
Cuardaigh Super: Ilchritéir VLookup    VLookup Illuachanna  |   VLookup Trasna Ilbhileoga   |   Amharc doiléir ....
Liosta anuas Casta: Go tapa Cruthaigh Liosta Anuas   |  Liosta anuas Cleithiúnach   |  Liosta Buail Isteach Ilroghnacha ....
Bainisteoir Colún: Cuir Líon Sonrach Colún leis  |  Colúin Bog  |  Scoránaigh Stádas Infheictheachta na gColún Ceilte  |  Déan comparáid idir Raonta & Colúin ...
Gnéithe Réadmhaoin: Fócas Eangaí   |  Amharc Dearaidh   |   Barra Mór na Foirmle    Leabhar Oibre & Bainisteoir Bileog   |  Leabharlann Acmhainní (Uaththéacs)   |  Piocálaí Dáta   |  Comhcheangail Bileoga Oibre   |  Criptigh/Díchriptigh Cealla    Seol Ríomhphost trí Liosta   |  Scagaire Super   |   Scagaire Speisialta (scagaire trom/iodálach/stailc tríd...) ...
Barr 15 Uirlisí12 Téacs uirlisí (Cuir Téacs, Bain Carachtair,...)   |   50 + Cairt cineálacha (Cairt Gantt,...)   |   40+ Praiticiúil Foirmlí (Ríomh aois bunaithe ar lá breithe,...)   |   19 Insertion uirlisí (Cuir isteach Cód QR, Ionsáigh Pictiúr ón gCosán,...)   |   12 Tiontú uirlisí (Uimhreacha le Focail, Comhshó Airgeadra,...)   |   7 Cumaisc & Scoilt uirlisí (Sraitheanna Comhcheangail Casta, Cealla Scoilt,...)   |   ... agus eile

Supercharge Do Scileanna Excel le Kutools le haghaidh Excel, agus Éifeachtúlacht Taithí Cosúil Ná Roimhe. Kutools le haghaidh Excel Tairiscintí Níos mó ná 300 Ardghnéithe chun Táirgiúlacht a Treisiú agus Sábháil Am.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

Tuairisc


Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
Comments (40)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
hi ... i have a five letter word ... the five letters are in five cells in a row ... i want to put the letters of the word ... into alphabetical order ... into 26 columns ... A to Z
This comment was minimized by the moderator on the site
Hi.. I have a range of cells (say - a1:h1). this range can contain empty cells as well as numbers (at start, middle or end of range). These numbers can be similar or different, at any situation. I need a formula to see if all the 7 cells (a1:h1) have similar value then the similar value should be displayed in cell i1 or an error. Can someone help please.
This comment was minimized by the moderator on the site
I want to compare 3 cells and filter out the rows which doesn’t fulfil the criteria, for example Like 3 columns A,B,C have different values and from these columns if anyone cell doesn’t cross   Like for example 100 that entire row must be deleted 
This comment was minimized by the moderator on the site
Hi,Kishan,Do you mean to delete the rows that the cells are not equal?If so, please apply the formula in this article to test if the cells are equal or not, and then filter based on the formula cells to display all FALSE rows, and last, select and delete the filtered rows as you need.Please try, hope it can help you!
This comment was minimized by the moderator on the site
I am trying to compare the same cell in multiple tabs to see whether the contents are identical.  If so, then return that identical value; and if not, then return "NO".  How am I able to accomplish this?  It appears that the AND(EXACT function doesn't work across multiple sheets.
This comment was minimized by the moderator on the site
hello sir, i have 6 columns of 2 tables in different sheets, but i want to match 2nd tables data with 1st tables data.
This comment was minimized by the moderator on the site
I have two cols with numbers and want to find the matches but the same/ different number are not in the same row. How do i
This comment was minimized by the moderator on the site
Hello, Joanne,Can you give more details of your problem, or you can insert an image of your problem here?Thank you!
This comment was minimized by the moderator on the site
I have a scenario like this I have same values in col A, Col B and Col C ( AA,AA,AA) and I want to return the Same value AA if all 3 in SYNC in col D.Can anyone assist in this ?
This comment was minimized by the moderator on the site
Hello, Prabakar,To solve your problem, please apply the below array formula:=IF(AND(EXACT(A2:C2,A2)),A2,"")
After entering this formula, please remember to press Ctrl + Shift + Enter keys together to get the correct result.Please try it.
This comment was minimized by the moderator on the site
I HAVE 3 CELLS THAT CAN HAVE VALUE OF EITHER "W"OR"L" IE. W/L/W OR L/W/L OR W/L/L

MEANING WIN OR LOSS

HOW DO I COUNT 2 WINS OR 2 LOSSES? TO PUT ANSWER IN SINGLE CELL!
This comment was minimized by the moderator on the site
Lets asume you have results in Columns A,B and C) starting in second row, For example you can add a helper Colum (all wins/loses) and add =if(Or(And(a2="W",b2="w",C2="W"),(a2="L",b2="L",C2="L"),0,1)And then just perform a sum at the end - the above will assign a 0 value to 3 wins or 3 losses, and a 1 value to other results
This comment was minimized by the moderator on the site
sO GRAET HELPFUL
This comment was minimized by the moderator on the site
=COUNTIF(A1:D1,A1)=4 ---> mind = blown
There are no comments posted here yet
Load More
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations