Copying Formulas to new row

[chrisnat]

NBVC I ran into a problem getting the formulas to work pas the first row in the worksheet. I tried to do as you suggested and changed the values for the cells but it doesn't seem to help. Do I change each value to the new row? What don't I change? The next row would be B15:B23.

the formula in question is below and used in Worksheet Votes. Workbook attached

=INDEX(B$2:B$10,SMALL(IF(C$2:C$10=C11,ROW(B$2:B$10)-ROW(B$2)+1),COUNTIF(C$11:C11,C11)))

Thank you again for your help. Still trying to learn.

[NBVC]

You would just select and copy the formula in B11 and paste it to B24, then change the ranges like:

=INDEX(B$15:B$23,SMALL(IF(C$15:C$23=C11,ROW(B$15:B$23)-ROW(B$15)+1),COUNTIF(C$24:C24,C24)))

and confirm with CTRL+SHIFT+ENTER and then copy down.

The LARGE formula would be then:

=LARGE(C$15:C$23,ROWS($A$1:$A1))

Note: You don't need to confirm with CTRL+SHIFT +ENTER

[chrisnat]

Thank you again