列出重复序列的每个第一个值的行号

时间:2022-11-11 18:17:33

In a spreadsheet I have a column of this structure:

在电子表格中,我有一个这种结构的列:

10.00
10.00
10.00
10.00
10.00
10.00
10.00
10.00
20.00
20.00
20.00
20.00
20.00
100.00
100.00
100.00
100.00
810.00
810.00
810.00
810.00
990.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
10.00
10.00
10.00
10.00
10.00

So lots of 10.00 followed by a couple of other values and then 10.00 starting again.

所以很多10.00后跟几个其他值然后10.00再次开始。

How can I get the row number of only the first 10.00 of each block of 10.00s?

如何获得每个块10.00s的前10.00行数?

2 个解决方案

#1


2  

Assuming your lists starts in A2 (with something other than 10 in A1), in a spare column Row2 and copied down to suit:

假设您的列表在A2中开始(在A1中使用10以外的其他内容),在备用列Row2中并向下复制以适应:

=IF(AND(A2=10,A1<>A2),ROW(),"")

#2


1  

A small variation of the pnuts solution.

一小部分的核桃溶液。

in B1 enter:

在B1输入:

=IF(A1=10,1,"")

In B2 enter:

在B2输入:

=IF(A2<>10,"",IF(A1=10,"",ROW()))

and copy down

并复制下来

Now to get a compact list, in D1 enter:

现在要获得一个紧凑的列表,在D1中输入:

=IFERROR(SMALL(B:B,ROW()),"")

and copy down:

并复制下来:

列出重复序列的每个第一个值的行号

#1


2  

Assuming your lists starts in A2 (with something other than 10 in A1), in a spare column Row2 and copied down to suit:

假设您的列表在A2中开始(在A1中使用10以外的其他内容),在备用列Row2中并向下复制以适应:

=IF(AND(A2=10,A1<>A2),ROW(),"")

#2


1  

A small variation of the pnuts solution.

一小部分的核桃溶液。

in B1 enter:

在B1输入:

=IF(A1=10,1,"")

In B2 enter:

在B2输入:

=IF(A2<>10,"",IF(A1=10,"",ROW()))

and copy down

并复制下来

Now to get a compact list, in D1 enter:

现在要获得一个紧凑的列表,在D1中输入:

=IFERROR(SMALL(B:B,ROW()),"")

and copy down:

并复制下来:

列出重复序列的每个第一个值的行号