我有一个我正在研究的在线Excel工作簿，我想知道是否有一种方法可以找到文本具有重复位置的确切位置。
我在Excel下载的宏观工作簿中找到了一个解决方案，但我知道Excel Macro无法在线工作，因此我需要找到其他解决方案，以在线Excel Workbook中显示重复位置。
例如，使用条件格式，我将其格式化以向我展示它是重复的，但我希望它显示副本所在的行中的行号。 Excel Online提供任何此类功能吗？
I have an online Excel workbook that I'm working on and I wanted to know if there is a way we could find out the exact location of where the text has duplicates.
I found a solution in the Excel downloaded macro workbook using VBA but I got to know Excel macro does not work online therefore I need to find a different solution to show the duplicates location in the online Excel workbook.
For instance, using conditional formatting I formatted it to show me it is a duplicate but I want it show the row number of where the duplicate is located. Does the Excel online offer any such feature?
发布评论
评论（2）
您可以使用公式检索重复项行=1。辅助列
，然后在2。辅助列中添加此公式：
输出以重复的方式写入第一个值。
它首先通过联系人的名称过滤连接行号的结果。
您需要Excel 365。
you can use a formula to retrieve the duplicates row = 1. helper column
then in the 2. helper column you add this formula:
Output is written to the first value with duplicates.
It joins the result of the row numbers by first filtering them by the name of the contact.
You need Excel 365 for this.
= if（countif（$ a $ 2：$ a5，$ a5）＆gt; 1，行（a5），“”）将返回行号为第二列
= concatenate（“重复存在： “，true，b2：b15）））将把这些数字返回为一个看起来像重复的单元格中
：修改将列出所有重复的事件。
资料来源：
＆amp; https://www.exceldemy.com/excelcelcelcelcelcelcelcel-celcel-celcel-celcel-celcel-cell-compine-celcel-celcel-cell-compine-celcel-celcel-combine- -Rows-Into-One-cell-2/
=IF(COUNTIF($A$2:$A5, $A5)>1, ROW(A5), "") will return the row number as a second column
=CONCATENATE("Duplicates Exist in: ",TEXTJOIN(", ",TRUE, B2:B15)) will return those numbers back as a single cell that looks like Duplicates Exist in: 7.
Note: the above if identifies only the duplicates after the first, a slight modification would list all duplicate occurrences.
sources:
https://www.ablebits.com/office-addins-blog/2016/03/02/identify-duplicates-excel/ & https://www.exceldemy.com/excel-combine-rows-into-one-cell-2/