Hi Kimberly,

Yes it is possible, I have attached a working copy with all the formulas in it on sheet 1 and sheet 2, when I add new names in column C sheet 1 and then drag down formulas on sheet 1 & sheet 2 to include these new names the formulas fail, it comes up in column B sheet 1 and column D sheet 2 as #value.

Note: on sheet 1 Column B it shows Can't win and 2 names next to Murray - these 2 names have picked the same as Murray.

I look forward to hear from you or anyone else who might be able to help!
regards

Mike

Attached Files

Tony's Football Tipping - copy.xlsx (21.6 KB, 17 views)