本文介绍了计算重复项并显示发生顺序的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试计算一列中每个值的出现次数,然后输出使用未排序的数据找到该值的顺序(从上到下).我一直找不到合适的公式来完成此任务.非常感谢您的协助.
I am attempting to count the number of occurrences of each value within a column and then output the order in which it was found (top to bottom) with unsorted data. I have been unable to find a suitable formula to accomplish this task. Any assistance is greatly appreciated.
示例:
Number DuplicateIndex
50 1
20 1
30 1
10 1
30 2
40 1
30 3
50 2
推荐答案
尝试
=countif(A$2:A2, A2)
,在B2中并填写.
这篇关于计算重复项并显示发生顺序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!