|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 22nd, 2005, 06:17 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
max number repeated
sup pros i have many numbers in rows & columns i want to find out the max number repeated in these set of rows & columns then the second max number repeated then the 3rd max number repeated & so on -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=495575 
|
|
#2
December 22nd, 2005, 07:00 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
max number repeated
Check out Tools DataAnalysis Histogram..........
Vaya con Dios. Chuck, CABGx3 "Pivotrend" wrote: sup pros i have many numbers in rows & columns i want to find out the max number repeated in these set of rows & columns then the second max number repeated then the 3rd max number repeated & so on -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=495575
|
|
#3
December 22nd, 2005, 07:12 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
max number repeated
max # repeated -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=495575
|
|
#4
December 22nd, 2005, 10:05 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
max number repeated
Are you talking about MODE()?
=MODE(A1:A100) Returns the most frequently occurring number. If you want the second or third or whatever most used number, enter which occurrence you're looking for into B1, and try this: =INDEX(A1:A100,MATCH(LARGE(FREQUENCY(A1:A100,A1:A1 00),B1),FREQUENCY(A1:A100, A1:A100),0)) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Pivotrend" wrote in message ... max # repeated -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=495575
|
|
#5
December 23rd, 2005, 03:44 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
max number repeated
RagDyer Wrote: =INDEX(A1:A100,MATCH(LARGE(FREQUENCY(A1:A100,A1:A1 00),B1),FREQUENCY(A1:A100, A1:A100),0)) -- thanx dude but can you correct this formula -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=495575
|
|
#6
December 23rd, 2005, 02:48 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
max number repeated
If it's not working correctly for you, watch out for "word wrap".
You could try keying it in yourself. -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "Pivotrend" wrote in message ... RagDyer Wrote: =INDEX(A1:A100,MATCH(LARGE(FREQUENCY(A1:A100,A1:A1 00),B1),FREQUENCY(A1:A100, A1:A100),0)) -- thanx dude but can you correct this formula -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=495575
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| AfterUpdate code to generate new sequential number | Jan Il | Using Forms | 2 | August 21st, 2005 07:43 PM |
| thank you Access newsgroup posters | Dan | General Discussion | 3 | April 18th, 2005 04:11 PM |
| Combo Box & Text Box | AccessRookie | Using Forms | 3 | April 6th, 2005 11:33 PM |
| incorrect sums in report using 2 tables | jkendrick75 | Setting Up & Running Reports | 22 | December 13th, 2004 02:19 PM |
| Setting A Number Equal to Another Number | slag018 | General Discussion | 1 | October 19th, 2004 04:16 AM |
Linear Mode
