|
|
#1
04-19-2017, 07:29 AM
|
|||
|
|||
Find the most common number in a excel sheet
Hello,
i was wondering if anyone can help me. I'm looking to find the most number in a column depending on the criteria. For example: If i have color cars and then there are numbers next to them.... Red 1 Red 1 Blue 2 Blue 3 Red 2 Red 1 I would like to have a formula that will say that in a separate cell, just place the number 1 to show that red 1 is the most common number. any help would be appreciated 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| excel formula to find most common words in data | jenagain | Excel | 1 | 03-20-2016 11:03 PM |
| Find matching criterior in sheet 1 and copy to Sheet 2 | Auto | Excel Programming | 3 | 03-19-2016 01:41 PM |
 Find Results in excel copy the rows to another sheet
|
khalidfazeli | Excel | 2 | 02-06-2013 09:38 AM |
|
Need help with sorting a column by most common to least common
|
mikenmike0001 | Excel | 5 | 12-06-2011 05:17 PM |
|
Excel sheet Sequence Number
|
belloffice | Excel | 1 | 02-25-2010 02:41 PM |
Windows 8 
Office 2007
Threaded Mode