Ma waena o nā mea hana maʻamau Microsoft Excel, nui nā ala like ʻole e hōʻike i nā kope me ka kala. ʻO ke ala maʻalahi a wikiwiki hoʻi me ka hoʻopili kūlana. No ka hana ʻana i kēia, koho wale i kahi ākea o nā cell a koho i ka pā Home — Hōʻano Kūʻai Kūʻai — Nā lula koho kelepona — Nā Waiwai Palua (Home — Hōʻano Kūʻai Kūʻai — Hōʻikeʻike i nā Rula Kelepona — Nā Waiwai Duplicate):
Eia nō naʻe, i kēia hihia, ʻano like ka waihoʻoluʻu piha o nā cell āpau, ʻo ia hoʻi, he hōʻailona wale nō ia he kope ʻia ka mea i kahi ʻē aʻe o ka laulā, akā ʻaʻohe mea e kōkua ai e loaʻa iā lākou. Hiki iā ʻoe ke hoʻoponopono i ke kūlana me kahi macro liʻiliʻi e hoʻopiha i kēlā me kēia pālua (a ʻoi aʻe paha) o nā kope hou ʻia me kona kala ponoʻī:
ʻOi aku ka maopopo, ʻeā? ʻO kaʻoiaʻiʻo, me ka nui o nā cell hou, e paʻakikī ke hoʻokaʻawale i waena o nā malu, akā me kahi helu liʻiliʻi o nā kope, e hana maikaʻi kēia ʻano.
No ka hoʻohana ʻana i kēia macro, kaomi i ka ʻaoʻao pōkole Alt + F11 a i ʻole pihi Ke kākoʻo XIX. uku pila mea haku polokalamu, e hoʻokomo i kahi module kaʻawale hou ma o ka papa kuhikuhi Hoʻokomo - Module a kope i ke code o kēia macro ma laila:
Sub DuplicatesColoring() Dim Dupes() 'E haʻi i kahi ʻano e mālama i nā kope ReDim Dupes(1 To Selection.Cells.Count, 1 a 2) Selection.Interior.ColorIndex = -4142 'Wehe i ka hoʻopiha inā i = 3 No kēlā me kēia cell In Koho If WorksheetFunction.CountIf(Selection, cell.Value) > 1 Then For k = LBound(Dupes) To UBound(Dupes) 'ina 'o ke kelepona i loko o ka laha o na kope, e hoopiha ina Dupes(k, 1) = cell A laila cell.Interior. ColorIndex = Dupes(k, 2) A laila k 'inā loaʻa i ke kelepona he kope, ʻaʻole naʻe i loko o ka papa kuhikuhi, e hoʻohui iā ia i ka papa kuhikuhi a hoʻopiha inā cell.Interior.ColorIndex = -4142 A laila cell.Interior.ColorIndex = i Dupes(i, 1 ) = cell.Value Dupes(i, 2) = ii = i + 1 End If End If Next cell End End Sub
I kēia manawa hiki iā ʻoe ke koho i kekahi ʻano me ka ʻikepili ma ka pepa a holo i kā mākou macro me ka hoʻohana ʻana i ka pōkole keyboard Alt + F8 a i ʻole ma ke pihi macros (Macros) uku pila mea haku polokalamu (Ka mea hoʻomohala).
- Hoʻokaʻaʻike i nā kope me ke kala
- He aha nā macros, kahi e hoʻokomo ai i ka code macro i Visual Basic, pehea e holo ai
- Pehea e helu ai i ka helu o nā waiwai kūʻokoʻa ma kahi ʻano o nā cell i hāʻawi ʻia