I’ve tried variations of the Offset and IF functions, but am wondering if I’m either missing something obvious or what I’m trying to do isn’t possible. I am trying to get the result of to start under column F (header = 4). What I am trying to create (using example above):Ĭolumn: A | B | C | D | E | F | G | H | I | J | K Header: Current Stage | Target Stage | Sequence FormulaĮxample with traditional sequence formula: So for example, if current value = 4 and target value = 6, the resulting sequence should be 4, 5, 6, and it should begin under the 6th column. I need to create a sequence across columns that is equal to target minus current plus 1, and have the resulting array begin under the column equal to the starting number of the sequence. I have two columns that represent current and target values (range is 1:9, and current value will always be <= target value). Hi Ben – very helpful post (as is your website in general).ĭo you know if it is possible to offset the starting position of a Sequence (or other array) formula? /rebates/&252fjim-collins-spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |