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.00
s?
如何获得每个块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:
并复制下来: