Forum Discussion
Selecting Data with Minimum Standard Deviation
In the attached version, I have implemented my VBA algorithm (with StDev_P instead of StDev_S) as a custom function. It is used in an array formula confirmed with Ctrl+Shift+Enter to return the selected values.
Thanks everyone JKPieterse HansVogelaar JoeUser2004 mtarler Nothing_Left_to_Lose
I've attached the data I have below. I like the approaches of mtarler and I think it would suits best with my data. I'm not familiar in anyway in VBA so I don't know how to replicate this for multiple dataset. The attached file have what I imagine easily useable.
https://itsacid-my.sharepoint.com/:x:/g/personal/muhammadalvaro_19025_student_its_ac_id/EXx9LrD-SMNItCrij9z-Oo0BoDstilAJ5cO9upnbuuRSgw?e=NtI6Wi
In the attached version, I have implemented my VBA algorithm (with StDev_P instead of StDev_S) as a custom function. It is used in an array formula confirmed with Ctrl+Shift+Enter to return the selected values.
- I tried to paste formula but I think there is problem because of me using english terms for the functions and don't know the correct translation.
2 changes are
a) change the range for 'in' to be row 3
b) using the 2nd formula above that has both make the last line: TRANSPOSE(out)
