Jan 25 2021 12:21 PM
Jan 25 2021 12:35 PM
@GrumpyOldWoman I'm sorry to hear your frustration but your description leaves me clueless what exactly you are trying to do. Please attach a sample spreadsheet showing how the data is set up and what you are trying to accomplish. That said it sounds like you are having trouble with addressing an array like A1:A100 where you need part of it to index but part of it to not index. I just want to make sure you understand that you can use the '$' to lock any part of it. For example A$1:A100 would only lock row 1 of the first part so the next cell down would reference A$1:A101. There are also many things you can do with INDEX, FILTER, etc... but not knowing more about what you are doing, I'm stabbing in the dark.
Jan 25 2021 01:39 PM
We would need to see an example of what you are talking about including the formulas you have considered and what you are hoping to see by way of results. At first sight, I would say that it is the purpose of MEDIAN to return a single 'mid' value for one or more arrays.