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!