N-1 factorial arrayformula in Google Sheets?

Thanks, Jeff. This will do it then:

=if(A2-1<1,"",A2-1) then Drag/Fill to the block.

Column is filled by a Query indexing another sheet, so the number of rows is dynamic. So, I’ll just pre-pack the sheet (consuming valuable rows!) and move on. My original question wouldn’t have addressed need to fill those Rows, but I was hoping for something clever that might.

Thanks!

1 Like