Unfortunately, rows are being added to the sheet all the time - I'd rather
not have to filter, copy & paste every time new ones are added. Isn't there a
way to do it so that I can keep a running mode?

"Gary''s Student" wrote:

Use AutoFilter:

Say A1 thru B6 contain:

V CRT
2 20
1 11
2 8
1 16
2 3

Click on B1 and:

Data Filter Autofilter Custom is greater than 10
this will produce:

V CRT
2 20
1 11
1 16

Copy and paste this to, say H16 and then =MODE(H16:H100) will get you what
you want.
--
Gary''s Student - gsnu200772


"PaladinWhite" wrote:

I have two columns of data. I want to calculate the mode of some cells in the
first column - including only those cells whose corresponding cell in the
second column has a value greater than 10.

For example:
2 | 20
1 | 11
2 | 8
1 | 16
2 |3
Would return MODE(2,1,1) = 1.

How do I pass the MODE() function only the criteria-filtered cells?

Thanks!