Gurus I think this one is too complicated using formulas so I'm looking for guidance to use VBA directly for solving it.
If I have a set of data that I want to calculate the average for each ID, each ID might have 1 or more than 1 lines.
Right now I'm having trouble writing the script coping with an ID with more than 3 lines of value.
In short, could you give me some hints and guidance on finding out outliers to exclude them and then do average on the remaining lines? Thanks!
If I have a set of data that I want to calculate the average for each ID, each ID might have 1 or more than 1 lines.
Right now I'm having trouble writing the script coping with an ID with more than 3 lines of value.
In short, could you give me some hints and guidance on finding out outliers to exclude them and then do average on the remaining lines? Thanks!