Hello, I am looking for a bit of help in regards to returning numbers from a set of values in a column. It is complicated to use just an IF function as it involves multiple criteria.
For ex., I would like set up a formula/macro such that the output field to auto-populate based on the following criteria: 1) the smallest number in the input filed gets the biggest value, i.e. 9; the next smallest gets 7, and so on in decrements of 2; 2) if there are identical values in the input field, then they would have an averaged output. I'd appreciate any insights on what functions/approach would be appropriate for this. TIA
