"Mode" function - using text

W

wrightr

New Member
Joined
Sep 13, 2006
Messages
16
You can use the "mode" function to return a value that has occured the most time in a range

This only works for numeric values but I need this to work for text values as well.

Does anyone know how to do this?
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Sort by date Sort by votes
Maybe try eg:

=INDEX(A1:A10,MATCH(MAX(COUNTIF(A1:A10,A1:A10)),COUNTIF(A1:A10,A1:A10),FALSE))

which must be confirmed with Ctrl+Shift+Enter, not just Enter. If correctly entered Excel will surround this array formula with curly braces {}.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Formula to return most repeated text in filtered data
Replies
4
Views
206
Domenic
D
G
  • Question
SUMIFS multiple criteria, the CRITERIA (not the CRITERIA RANGE) is a range and it has blank cells
Replies
6
Views
302
Fluff
Fluff
C
  • Question
Median / If (and Mode / If) not working
Replies
1
Views
104
Eric W
Eric W
N
  • Question
Finding most common number in a range
2
Replies
14
Views
368
Peter_SSs
Peter_SSs
B
  • Question
Can't Exit Desing Mode because Control 'xxxx' can not be created
Replies
1
Views
217
ktwwtk
K

Forum statistics

Threads
1,214,599
Messages
6,120,453
Members
448,967
Latest member
grijken

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top