Just add another IF:

....MODE(IF(Terms!$O$2:$O$65500<"",IF(Terms!$N2:$ N65500<90,MATCH...

Or, you could multiply the 2 arrays together like this:

....MODE(IF((Terms!$O$2:$O$65500<"")*(Terms!$N2:$ N65500<90),MATCH...

Note that if any cells in Terms!$N2:$N65500 are empty they will evaluate to
be <90. Which means you might have to add another array:

....MODE(IF((Terms!$O$2:$O$65500<"")*(Terms!$N2:$ N65500<90)*(Terms!$N2:$N65500<""),MATCH...

Follow the same syntax for the second formula but *make sure* the range refs
are all the same size.

Since you're referencing such a large range *expect* this to be slow!


--
Biff
Microsoft Excel MVP


"John" wrote in message
...
I am currently using the following formulas to pull the #1 - #5 most common
occurances from a range. Now I need to do the same thing, but I need it to
compare the results to another column before returning the results.

{=INDEX(Terms!$O$2:$O$65500,MODE(IF(Terms!$O$2:$O$ 65500<"",MATCH(Terms!$O$2:$O$65500,Terms!$O$2:$O$ 65500,0))))}

{=INDEX(Terms!$O$2:$O$20000,MODE(IF(Terms!$O$2:$O$ 20000<"",IF(COUNTIF(H$177:H177,Terms!$O$2:$O$2000 0)=0,MATCH(Terms!$O$2:$O$20000,Terms!$O$2:$O$20000 ,0)+{0,0}))))}

Right now these formulas return the result off one range, but I need it to
return the same result but after comparing it too a second range (i.e.
Terms!$N2:$N65500<90). I just can't figure out how to add it to this
equation
to make it work.

Using Excel 2003

Thanks in advance!