Here is my problem...
I have simplified my excel pages as much as I can to make this issue easy but I am left with one last column I cannot complete.
I need to return only the values in a set number of cells in a larger range (always counting and including the cells starting from left to right) based on a number manually set in another cell, while the range is always static (lets say 20 cells)
so If I have the number 8 in one cell that I am going to reference in this formula as the "count" and I want to use that "count" ONLY to return the valuse of the first (8 in this case) cells in a range of lets say 20, what would that formula be?
If the number is 2 I want to then ONLY return the values in the first 2 cells in the same range of 20, etc. etc.
I have simplified my excel pages as much as I can to make this issue easy but I am left with one last column I cannot complete.
I need to return only the values in a set number of cells in a larger range (always counting and including the cells starting from left to right) based on a number manually set in another cell, while the range is always static (lets say 20 cells)
so If I have the number 8 in one cell that I am going to reference in this formula as the "count" and I want to use that "count" ONLY to return the valuse of the first (8 in this case) cells in a range of lets say 20, what would that formula be?
If the number is 2 I want to then ONLY return the values in the first 2 cells in the same range of 20, etc. etc.