Data filtering(?) Question

  • Thread starter Thread starter BryGuy77
  • Start date Start date
B

BryGuy77

Hi all,

How can I list the most common word in a given range? I have office 2007, if
this matters. The range could all potentially carry the same value, or there
could be blank lines as well, so considering the blank line issue would be
appreciated. Thanks for the help!
 
Try this array formula** :

=INDEX(A1:A20,MODE(IF(A1:A20<>"",MATCH(A1:A20,A1:A20,0))))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Data Validation List with blanks 1
Ignoring Blanks in Data Validation 6
Blank Lines Question 2
Filters 9
Filtered cells return after saving 4
advanced filter for blanks 1
Data Validation 5

Back
Top