| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Return Range of Numerical Values in Single Column based on Frequency Percentage
Hi All,
I have a single column of numerical values that may repeat many times within the column. I require a flexible Formula: Use an Input Cell for the specified and changeable Percentage(s) %. Column may be filtered – so only take into account Visible Filtered Cells. The Formula will calculate and Return the numerical range of values that fall between the specified percentage % (using the Input Cell) e.g.; 70%. The Formula should Return two numeric values: a Start Value and an End Value – NOT necessarily the minimum and maximum per se BUT the MIN and MAX of the values that appear 70% of the time in the column; therefore, taking into account Repeat / Duplicate values. The calculated Results: the two numeric values will be returned to separate cells on a new Sheet. Thanks Sam -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200510/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return a value based on a range | Excel Worksheet Functions | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
| How sum values in column B using values in column A as the conditi | Excel Worksheet Functions | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
Threaded Mode
