Forum Discussion
How do I find the median of a selected column of values within a worksheet
Is it possible for you to upload a sample (devoid of actual names or other confidential info)? Otherwise, all you'll get is very general and it sounds very much like you would appreciate specific help.
Here is a sample with some simple formulas I put in for illustration of what I'm trying to do. There are two tabs. On the first tab (Differences within ID) there's a formula to calculate the differences for each line item, and a formula to calculate the median of the differences. Difference1 and Difference2 are independent of each other. On the second tab (MedianDifferencesPerID). I just copied the median values 1 & 2 for each ID. Finally, (I didn't mention this in my first post), I need to determine if any of the differences within an ID are outside of the range of the median value +/- 100,000. Still interested in helping? 🙂 Thanks!
