Is there a 'frequency' function??
 

I have the following list:

A........B
102...Nassau
102...Nassau
102...Nassau
102...Nassau
102...Suffolk
102...Suffolk

I need a function to return the text that appears the most in colum
B;...... that would be "Nassau" and that co-relates to "102" or an
other designated #.


- Larry -
VBA Amateu

--
Message posted from http://www.ExcelForum.com

Is there a 'frequency' function??
 

Did you look? Try =FREQUENCY
<-*-<-*-<-*-<-*-<-*-<-*-<-*-<-*-
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-<-*-<-*-<-*-<-*-<-*-<-*-<-*-
"nrage21 " wrote in message
...
I have the following list:

A........B
102...Nassau
102...Nassau
102...Nassau
102...Nassau
102...Suffolk
102...Suffolk

I need a function to return the text that appears the most in column
B;...... that would be "Nassau" and that co-relates to "102" or any
other designated #.


- Larry -
VBA Amateur


---
Message posted from http://www.ExcelForum.com/

Is there a 'frequency' function??
 

Hi
to get the most frequent text entry try the following array formula
(entered with CTRL+SHIFT+ENTER):
=INDEX($B$1:$B$20,MODE(MATCH(IF($B$1:$B$20<"",$B$ 1:$B$20),IF($B$1:$B$2
0<"",$B$1:$B$20),0)))

if you put this formula in C1 put the following formula in D1 to get
the associated number:
=INDEX($A$1:$A$20,MATCH(C1,$B$1:$B$20,0))

Note: this returns the number for the first match of Nassau in column B


--
Regards
Frank Kabel
Frankfurt, Germany


I have the following list:

A........B
102...Nassau
102...Nassau
102...Nassau
102...Nassau
102...Suffolk
102...Suffolk

I need a function to return the text that appears the most in column
B;...... that would be "Nassau" and that co-relates to "102" or any
other designated #.


- Larry -
VBA Amateur


---
Message posted from http://www.ExcelForum.com/

Is there a 'frequency' function??
 

Move your data down 1 row and put labels in row 1 ("Code" and "Region"). Use
a pivot table with "Region" as a row area and sorted in descending order by
count of Region.

--
Regards,
Bill


"nrage21 " wrote in message
...
I have the following list:

A........B
102...Nassau
102...Nassau
102...Nassau
102...Nassau
102...Suffolk
102...Suffolk

I need a function to return the text that appears the most in column
B;...... that would be "Nassau" and that co-relates to "102" or any
other designated #.


- Larry -
VBA Amateur


---
Message posted from http://www.ExcelForum.com/