Return most common, 2nd common...within the data range

**tantcu** · 10-07-2015, 04:07 PM

Hello,

is there a formula that help return the common value within the range of data? I attached the workbook for reference. Please help.

Thanks,Retuan Common Data.xlsx

**shg** · 10-07-2015, 04:38 PM

One way:

Row\Col	I	J	K	L	M	N	O	P
2		1st common	2nd common	3rd common	4th common	5th common
3		35	30	17	8	51		J3: {=MODE(IF(ISNUMBER(MATCH($B$3:$F$27, $I3:I3, 0)), "", $B$3:$F$27))}

Enter the array formula shown in J3 then copy right.

**tantcu** · 10-07-2015, 05:55 PM

Thank you.

**shg** · 10-07-2015, 06:06 PM

You're welcome.

Return most common, 2nd common...within the data range

LinkBack

Thread Tools

Rate This Thread

Display

Return most common, 2nd common...within the data range

Re: Return most common, 2nd common...within the data range

Re: Return most common, 2nd common...within the data range

Re: Return most common, 2nd common...within the data range

Thread Information

Users Browsing this Thread

Similar Threads

Identify common alphanumeric thread (but remove the last two digits) PLUS common identifie

I would like to automatically return unique records associated with common data

Lookup value in a column and return the most common value which follows...

[SOLVED] Need a formula that will return the 6 most common numbers in a range

[SOLVED] Copy data from a range of cells into a blank range based on common cell

Need help with sorting a column by most common to least common

Finding the most common (and 2nd, 3rd most common) text

Bookmarks

Bookmarks

Posting Permissions