There is a formula for creating dynamic ranges across columns but it is for just one row. How would I make a formula for multiple rows to automatically update across columns. The original formula is something like offset(A1,0,0,Count(2:2)) I think that's right, but I want one that works for multiple rows at the same time. Thanks.