使用下面的代码
={"Row 1 is row "&ROW();"Row 2 is row "&ROW()}
我得到这个
Row 1 is row 1
Row 2 is row 1
我认为这是因为ROW()返回公式实际输入的行。如何在数组中获得正确的行号?
编辑:
我实际上有这个
=ARRAY_CONSTRAIN({
TEXT(DATE(2022,1,1),"MMMM");ARRAYFORMULA(DATE(2022,1,SEQUENCE(DAY(EOMONTH(DATE(2022,1,1),0)))));
TEXT(DATE(2022,2,1),"MMMM");ARRAYFORMULA(DATE(2022,2,SEQUENCE(DAY(EOMONTH(DATE(2022,2,1),0)))));
TEXT(DATE(2022,3,1),"MMMM");ARRAYFORMULA(DATE(2022,3,SEQUENCE(DAY(EOMONTH(DATE(2022,3,1),0)))));
TEXT(DATE(2022,4,1),"MMMM");ARRAYFORMULA(DATE(2022,4,SEQUENCE(DAY(EOMONTH(DATE(2022,4,1),0)))));
TEXT(DATE(2022,5,1),"MMMM");ARRAYFORMULA(DATE(2022,5,SEQUENCE(DAY(EOMONTH(DATE(2022,5,1),0)))));
TEXT(DATE(2022,6,1),"MMMM");ARRAYFORMULA(DATE(2022,6,SEQUENCE(DAY(EOMONTH(DATE(2022,6,1),0)))));
TEXT(DATE(2022,7,1),"MMMM");ARRAYFORMULA(DATE(2022,7,SEQUENCE(DAY(EOMONTH(DATE(2022,7,1),0)))));
TEXT(DATE(2022,8,1),"MMMM");ARRAYFORMULA(DATE(2022,8,SEQUENCE(DAY(EOMONTH(DATE(2022,8,1),0)))));
TEXT(DATE(2022,9,1),"MMMM");ARRAYFORMULA(DATE(2022,9,SEQUENCE(DAY(EOMONTH(DATE(2022,9,1),0)))));
TEXT(DATE(2022,10,1),"MMMM");ARRAYFORMULA(DATE(2022,10,SEQUENCE(DAY(EOMONTH(DATE(2022,10,1),0)))));
TEXT(DATE(2022,11,1),"MMMM");ARRAYFORMULA(DATE(2022,11,SEQUENCE(DAY(EOMONTH(DATE(2022,11,1),0)))));
TEXT(DATE(2022,12,1),"MMMM");ARRAYFORMULA(DATE(2022,12,SEQUENCE(DAY(EOMONTH(DATE(2022,12,1),0)))))},379,1)
这将列出一年中所有的日子，并添加一行作为月份的名称。在它旁边有对应于每一天的数字，我想用相同的数组公式将每个月的所有数字相加。问题是有些年份是闰年，所以二月是动态的，我需要ROW()来告诉我三月从哪一行开始，但现在我似乎需要重新考虑这个公式。
应该是:
={"Row 1 is row "&ROW();"Row 2 is row "&ROW()+1}
或:
={"Row 1 is row "&ROW(A1);"Row 2 is row "&ROW(A2)}
但是这样更好:
=INDEX({"Row "&ROW(A1:A2)&" is row "&ROW(A1:A2)})