| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Function
I have a colum of numbers ranging for 0 to 100, for each row I need to know how many are the same value how many are a higher value how many are a lower value Is there a easy way of doing this? ie rate same higher lower 80 1 1 2 50 0 4 0 55 0 3 1 80 1 1 2 90 0 0 4 -- Rikuk ------------------------------------------------------------------------ Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559 View this thread: http://www.excelforum.com/showthread...hreadid=546671 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Function
One way:
B2: =COUNTIF(A:A, A2) - 1 C2: =COUNTIF(A:A, "" & A2) D2: =COUNTIF(A:A, "<" & A2) In article , Rikuk wrote: I have a colum of numbers ranging for 0 to 100, for each row I need to know how many are the same value how many are a higher value how many are a lower value Is there a easy way of doing this? ie rate same higher lower 80 1 1 2 50 0 4 0 55 0 3 1 80 1 1 2 90 0 0 4 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Function
Thanks that works great Can you tell how many are within a range of a number say 5 lower ie 80 How many between 80 & 75 70 how many between 70 & 65 -- Rikuk ------------------------------------------------------------------------ Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559 View this thread: http://www.excelforum.com/showthread...hreadid=546671 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Function
Try:
=COUNTIF(A:A, "<=" & A2)-COUNTIF(A:A, "<" & A2-5) "Rikuk" wrote: Thanks that works great Can you tell how many are within a range of a number say 5 lower ie 80 How many between 80 & 75 70 how many between 70 & 65 -- Rikuk ------------------------------------------------------------------------ Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559 View this thread: http://www.excelforum.com/showthread...hreadid=546671 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Function to count unique items in list | Excel Worksheet Functions | |||
| Count function applied to a time period | Excel Worksheet Functions | |||
| Function to count unique values? | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
Linear Mode
