计算重复项并显示发生顺序 [英] Count duplicates and display order of occurence

问题描述

我正在尝试计算一列中每个值的出现次数，然后输出使用未排序的数据找到该值的顺序(从上到下).我一直找不到合适的公式来完成此任务.非常感谢您的协助.

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中并填写.

这篇关于计算重复项并显示发生顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！