Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any formula to return the most frequent bin range?
Hi all , In a row i have : A1= 450 B1=560 C1=500 D1=510 E1=445 F1=430 G1= 420 Those values represent several weights of a product prepared in this case 7 times, now that i want to decide what is the most relative weight to use on my list, i need a formula to tell me what is the most frequent bin scored given a difference of 50 grs maximum . The formula should return the following answer : 400-450 which means that the most frequent weight bin is between 400 and 450 grs , now the 50 should be variable so if i change it somehow in the formula to 100 it should return 400-500 which means that the most frequent weight bin falls between 400 and 500 grs. Any smart frequency formula can do that ? i appreciate anyone's help, thank you much. -- hankach |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link to a named range in another worksheet that is sorted frequent | Excel Worksheet Functions | |||
Formula to return the reference of a range of cells | Excel Discussion (Misc queries) | |||
formula to return a $ amount for a range of % | New Users to Excel | |||
Formula - Analyse range, return unique value | Excel Worksheet Functions | |||
return most frequent objects/numbers in large worksheet? | Excel Worksheet Functions |