|
most frequently occurring value
hello how do i find out the most frequently occurring value, digit, or number in a set of rows & columns ? then i need to find out the second most occurring value then the 3rd then find the least frequently occurring value then the second least occurring value then the 3rd thanx... -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=495720 |
most frequently occurring value
Look in HELP for the FREUQUENCY() function
-- Kind regards, Niek Otten "Pivotrend" wrote in message ... hello how do i find out the most frequently occurring value, digit, or number in a set of rows & columns ? then i need to find out the second most occurring value then the 3rd then find the least frequently occurring value then the second least occurring value then the 3rd thanx... -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=495720 |
most frequently occurring value
<FREUQUENCY()
make that FREQUENCY() -- Kind regards, Niek Otten "Niek Otten" wrote in message ... Look in HELP for the FREUQUENCY() function -- Kind regards, Niek Otten "Pivotrend" wrote in message ... hello how do i find out the most frequently occurring value, digit, or number in a set of rows & columns ? then i need to find out the second most occurring value then the 3rd then find the least frequently occurring value then the second least occurring value then the 3rd thanx... -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=495720 |
most frequently occurring value
Assuming that the numbers are in A2:A200
B2: = A1 B3: enter =IF(ISERROR(MATCH(0,COUNTIF(B$2:B2,$A$2:$A$200&"") ,0)),"", INDEX(IF(ISBLANK($A$2:$A$200),"",$A$2:$A$200),MATC H(0,COUNTIF(B$2:B2,$A$2:$A $200&""),0))) as an array formula, so commit with Ctrl-Shift-Enter Copy this as far down column B as you think you might have unique values in column A Select C2:Cn, where n is the number of uniques previously estimate (I have estimated down to 10 for this exercise), and then in the formula bar enter this formula =IF($B$2:$B$10<"",FREQUENCY($A$2:$A$200,$B$2:$B$1 0),"") again an array formula, committed with Ctrl-Shift-Enter -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Pivotrend" wrote in message ... hello how do i find out the most frequently occurring value, digit, or number in a set of rows & columns ? then i need to find out the second most occurring value then the 3rd then find the least frequently occurring value then the second least occurring value then the 3rd thanx... -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=495720 |
| All times are GMT +1. The time now is 07:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com