sheet = count i count i
column a a列a，列表作者列表。相互作用第一个A2是空白的，应计为B2中的1。然后，A3应导致B3显示2。A4应导致B4显示3。A5应导致B5显示4。A6应导致B5显示4。A6应导致B6显示5。A7是空白的，并应导致该a6重新开始，因此B7应为1，B8 = 2，B9 = 3，B10 = 4，B11 = 5，B12 =6。B13在测试数据中再次开始。
我正在使用的公式是：= arrayformula（if（if（a2：a =“”，row（a2：a）-row（a2）+1）） - 1）
此公式计数错误的方式，如3,2中，1而不是1,2,3，当应该为1时，还会给出空白单元0。
有什么想法吗？
https://docs.google.com/spreadsheets/d/1anfWAkxa73-N7TydeMXVRNTuA1UB-vJ9A3iEnDjXa-I/edit?usp=sharing
Sheet = Count
I have column A with a list of Author. Interactions the first A2 is blank and should be counted as 1 in B2. A3 should then result in B3 showing 2. A4 should result in B4 showing 3. A5 should result in B5 showing 4. A6 should result in B5 showing 4. A6 should result in B6 showing 5. A7 is blank and should result in the the count starting again, therefore B7 should be 1, B8 = 2, B9 = 3, b10 = 4, b11 = 5, b12 = 6. B13 starts again in the test data.
The formula I am using is: =ArrayFormula(MIN(IF(A2:A="",ROW(A2:A)-ROW(A2)+1))-1)
This formula counts the wrong way as in 3,2,1 instead of 1,2,3 and also gives the blank cell 0 when it should be 1.
Any ideas?
发布评论
评论（1）
使用：
use: