|Posted: December 11, 2005, 7:18 am - IP Logged|
I think I'm getting closer (thanks to whoever spoke on naming ranges in another thread)
I named my columns H:M where my pairs are (Pairs)
=COUNTIF(pairs,AN2) To count the number of times the pairs are seen
Now do I simply divide by the draws to obtain the % that each pair hits?