I am counting scores to determine what place they are in. If the number
equals someone else's score then I want the result to read "Tie" if the
number is not a duplicate I would like it to read 1, 2, 3, & so on. However,
because my formula is to add 1 to A7, if A7 is a tie I get an error. Does
anyone have a suggestion (see my formula below):
=IF(OR(I8=$I$7,I8=$I$9,I8=$I$10,I8=$I$11,I8=$I$12, I8=$I$13,I8=$I$14,I8=I$15,I8=I$16,I8=I$17,I8=I$18, I8=$I$19,I8=$I$20,I8=$I$21,I8=$I$22,I8=$I$23,I8=$I $24,I8=$I$25,I8=$I$26,I8=$I$27,I8=$I$28,I8=$I$29,I 8=$I$30,I8=$I$31,I8=$I$32,I8=$I$33,I8=$I$34,I8=$I$ 35,I8=$I$36,I8=$I$37),"TIE",A7+1)