|
|
#1
04-07-2013, 11:50 AM
|
|||
|
|||
Help!! find two number recurring numbers in row??
Hi everyone, new to posting on this forum so thank you for your patience.
I have a spreadsheet which has data in 7 columns and around 100 rows. I want to be able to find what two numbers appear most frequent together on each of the rows. They don’t have to appear side by side they can appear anywhere on the row. It is kind of like the mode but instead of finding which number is most frequent it is to find what two numbers appear most frequent on each row? To give a better idea of what i mean I have inserted some sample data below. The red highlighted numbers of 26 & 29 appear 5 times on separate rows so I would want Excel to indicate that 26 & 29 are the most frequent on each row? The numbers can only appear once on a row and the range is between 1-50... Sorry if the explanation is not clear it’s hard to put in words. I have searched all around but can find a solution, any help from you excel gods would be much appreciated. Thank you.....  
|
| Tags |
| beginner, formula |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I refer to page numbers, when the numbers change as I prepare the document? | StevenD | Word | 5 | 11-29-2012 12:52 AM |
 Page Numbers Not Matching Chapter Numbers
|
gracie5290 | Word | 1 | 02-02-2012 11:41 PM |
|
Find & Replace formula for numbers?
|
Griff | Word | 4 | 04-18-2011 02:47 AM |
| Find and replace page numbers in body of text | tollanarama | Word | 3 | 02-13-2011 06:00 AM |
| FInd recurring words in Word 2003 | NJ007 | Word | 4 | 01-25-2010 03:11 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode