Skip to main content

Conas sraithuimhir a shannadh do luachanna dúblacha nó uathúla in Excel?

Má tá liosta luachanna agat ina bhfuil roinnt dúblacha, an féidir linn uimhir sheicheamhach a shannadh do na luachanna dúblacha nó uathúla? Ciallaíonn sé ordú seicheamhach a thabhairt do na luachanna dúblacha nó do luachanna uathúla mar a leanas an pictiúr a thaispeántar. An t-alt seo, labhróidh mé faoi roinnt foirmlí simplí chun cabhrú leat an tasc seo a réiteach in Excel.

dúblaíonn sannadh dúbailt uathúil 1

Sraithuimhir a shannadh chun luachanna a mhacasamhlú leis an bhFoirmle

Sraithuimhir a shannadh ar luach uathúil leis an bhFoirmle

mboilgeog cheart gorm saighead Sraithuimhir a shannadh chun luachanna a mhacasamhlú leis an bhFoirmle

Chun na luachanna dúblacha a ordú, cuir an fhoirmle seo a leanas i bhfeidhm le do thoil:

Iontráil an fhoirmle seo: = COUNTIF ($ A $ 2: A2, A2) isteach i gcill bhán in aice le do chuid sonraí, agus ansin tarraing an láimhseáil líonta síos go dtí na cealla ar mhaith leat an fhoirmle seo a chur i bhfeidhm, agus sannadh na luachanna cille bunaithe ar na luachanna dúblacha, féach an scáileán:

dúblaíonn sannadh dúbailt uathúil 2

mboilgeog cheart gorm saighead Sraithuimhir a shannadh ar luach uathúil leis an bhFoirmle

Le sraithuimhir a shannadh ar luach uathúil, féadfaidh an fhoirmle thíos fabhar a thabhairt duit:

Iontráil an fhoirmle seo: =IF(COUNTIF(A$2:A2,A2)=1,MAX(B$1:B1)+1,VLOOKUP(A2,A$1:B1,2,0)) isteach i gcill bhán in aice le do chuid sonraí, agus ansin tarraing an láimhseáil líonta síos go dtí na cealla ar mhaith leat an fhoirmle seo a chur i bhfeidhm, agus ordaíodh na luachanna uathúla mar a thaispeántar ar an scáileán a leanas:

dúblaíonn sannadh dúbailt uathúil 3

Nótaí:

1. San fhoirmle thuas, A2 an bhfuil an luach a theastaíonn uait a shannadh sa chill, B1 an chill thuas ina bhfuil do fhoirmle suite.

2. Is féidir na foirmlí seo a chur i bhfeidhm freisin ar na luachanna ar an liosta sórtáilte, agus gheobhaidh tú an toradh seo a leanas mar is mian leat:

dúblaíonn sannadh dúbailt uathúil 4

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 (23)
No ratings yet. Be the first to rate!
gabrielraigosa@hotmail.com
This comment was minimized by the moderator on the site
Solución bastante sencilla y funciona bien.
Reply
Report
0
0
M
M
This comment was minimized by the moderator on the site
Getting NA result for more than 200 cells
Reply
0
0
SPUS
SPUS
This comment was minimized by the moderator on the site
Thanks for the formula, my only problem is that I want the generated 'unique identifiers' to be locked/linked to the 'values' but whenever I sort the table, the identifiers always remain in the same spot. Is there a way so that they stay linked to one another?

For example, I am using this code to assign serial numbers to customers, these need to be permanently assigned to one another as they do not change. However, when I sort the table by date, customers or anything at all that re-arranges the data. The serial numbers all get mixed up.
Reply
0
0
Lokesh Kumar
Lokesh Kumar
This comment was minimized by the moderator on the site
How to Convert a Cell Containing


A1 = Apple, Orange, Banana, Grapes

to

A1 = 1. Apple, 2. Orange, 3. Banana, 4. Grapes
Reply
0
0
YT Kong
YT Kong
This comment was minimized by the moderator on the site
Hello there,

If i want the formula to have alphabet infront is it possible?

DO123455 =A1
DO123455 =A1
DO223344 = A2
DO223344 = A2
DO567890 = A3

Appreciate if you can assist on my problem.

Thank you

YT Kong
Reply
0
0
Cesar
Cesar
This comment was minimized by the moderator on the site
Hi, i want some help, i need my data right this:

A 1
A 2
A 3
B 1
B 2
C 1
D 1
C 1
C 2
B 1
E 1
E 2
A 1
I need taht when it finds a new value starts since 1, every time. Is it posible ?
Reply
0
0
Abid
Abid     Cesar
This comment was minimized by the moderator on the site
=COUNTIF(G$2:G2,G2)
=COUNTIF(G$2:G3,G3)
Reply
0
0
Miskin
Miskin
This comment was minimized by the moderator on the site
I want serial number start from 1 when it encounter new series
Like
AA - 1
BB - 1
AA - 2
CC -1
DD -1
AA - 3
BB - 2

Is this possible?
Reply
0
0
Rio A Indonesia
Rio A Indonesia     Miskin
This comment was minimized by the moderator on the site
possible, simple guys=IF(COUNTIF(A$2:A7;A7)>=1;COUNTIF(A$2:A7;A7);VLOOKUP(A7;A$2:W6;23;0)+1)
Reply
0
0
Abid
Abid     Rio A Indonesia
This comment was minimized by the moderator on the site
=COUNTIF(G$2:G2,G2)
=COUNTIF(G$2:G3,G3)
Reply
0
0
Eric
Eric
This comment was minimized by the moderator on the site
Is it possible to do this with power query, and not with the vlookup formula?
Reply
0
0
Alex
Alex
This comment was minimized by the moderator on the site
Is it possible to assign such serial numbers within the same cell? I have a sheet that does this using a macro, but I cannot access the macro (password protected) to see how they did it.
Disclaimer: I have permission to access the macros, but it is an old sheet and the passwords are lost.
Reply
0
0
MIDHIN C R
MIDHIN C R
This comment was minimized by the moderator on the site
hai pls help

i have a series of data and i want this type of results
item product sequence number
a powder 1
a juice 2
b preprocess 2
b process 3
b jucie 1
c powder 1
c juice 2
c preprocess 3
c procss 4


want sequence number based on item and product column
Reply
0
0
There are no comments posted here yet
Load More
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations