I am interested, how to make easily adoptable formula for changing array each month. I had difficulties knowing how to call this problem, also maybe my terminology is not correct, hopefully the explanation is clear.
I am using LARGE and INDEX formula to pick out some items and their prices each month. However, every month the number of items changes and that can require me to change the formula to adapt the array, for instance from $E$2:$E$78 (77 products) to $E$2:$E$80 (79 products). Of course I can do this manually by changing the number from 78 to 80, but is there a way, to maybe just refer to another cell, that would state how many items there is in the table or that it would tell the array? I don't want the user to be changing the area, just somewhere aside changing the array.
Thank you in advance!
Bookmarks