Here is what I would like to do but need help getting started.
I have numbers stored in column A, the amount of numbers could change each time I run this, no more than 500 to 1000.
I what to check each number to find which number has the max deviation from the average of those numbers and then flag that number.
I then want to continue doing this with that number removed for a predetermined amount of times.
I would then paster the numbers in column B with the flagged numbers (ex. 54.2 Flag).
What is the best way and cleanest way to do this. Should I store the numbers in some sort of array for should I just paste in a column to store the newest data.
Hope this makes sense.