Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding Minimum but if same number repeats in the range, then find
Can someone help me? I am trying to find a way to make a list of numbers from
a range. The numbers can repeat many time in the range but I want to list each different number once only. I tried to use MINIF function but if the range has only one number, then this function can not be used. For example: I have a range D1:Q25, I want to make a summary of numbers used in this range. Column A will have the each different number used in this range and Column B will show the number of times each number is used. If my Colum A has the right number, then I can use COUNTIF fuction for Coumn B. I tried for "A1" =MIN(D1:Q25) and for "A2" =MIN(IF(D1:Q25A1,D1:Q25,"")) and for "A3" =MIN(IF(D1:Q25A2,D1:Q25,"")) but if A2 is blank, then I get same number as A1. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding maximum, minimum in a range consists both Positive and Negative numbers | Excel Worksheet Functions | |||
Get a row number of range where a value is between minimum and max | Excel Worksheet Functions | |||
How do I find minimum duplicated values in a range? | Excel Worksheet Functions | |||
find minimum of range based on multiple criteria | Excel Worksheet Functions | |||
Finding the minimum in a selected number of rows of the same colum | Excel Worksheet Functions |