Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function '=Frequency' Help! | Excel Worksheet Functions | |||
Frequency Function | Excel Worksheet Functions | |||
Frequency Function | Excel Worksheet Functions | |||
Frequency function | Excel Discussion (Misc queries) | |||
Using FREQUENCY Function to Count | Excel Worksheet Functions |