昇順でないものから検索して範囲指定

=INDEX(LINEST(INDIRECT(ADDRESS(MATCH(I7,H:H),COLUMN(H13))):INDIRECT(ADDRESS(MATCH(K7,H:H),COLUMN(H13))),INDIRECT(ADDRESS(MATCH(I7,H:H),COLUMN(I13))):INDIRECT(ADDRESS(MATCH(K7,H:H),COLUMN(I13))),,),1)/10^3

=INDEX(LINEST(INDIRECT(ADDRESS(MATCH(I10,A:A),COLUMN(G13))):INDIRECT(ADDRESS(MATCH(K10,A:A),COLUMN(G13))),INDIRECT(ADDRESS(MATCH(I10,A:A),COLUMN(A13))):INDIRECT(ADDRESS(MATCH(K10,A:A),COLUMN(A13))),,),1)

=IF(ROW()<MATCH($P$16,H:H,0),D20+(C21-C20)/$D$4,D20+(C21-C20)/$D$5)

No.1 回答者： mike_g 回答日時： 2016/07/15 11:48

呆れたぁ～！