First Page
Previous Page
Posted 08/08/2010 12:53 am
I am appalled at the neatness of this spreadsheet! 
Other than that, very nice work Scooby 
Some odds and ends in mine that might come in handy...
Keeping track of daily guesses.. with the date in an inserted column to the far left, and one inserted between Guess and Clue (or wherever).
Under Today:
=IF(A$6=TODAY(),COUNTIF($D$6:$D$30,D13),"")
(not incremental - it would show the total per person for the day each time they guessed)
Duplicate check:
Hidden columns to the side to check each currency for how many times it appears in the master currency list, do this per cell:
=COUNTIF($B$6:$B$173,H6)
then:
=IF(SUM(AD41:AO41)>10,"DUPE(S)!","OK")
Similar.. check for typos (using same range just for example):
=MATCH(H6,$B$6:$B$173,0)
then:
=IF(OR(COUNTIF(AD41:AO41,">0")=10,COUNTIF(AD41:AO41,">0")=0),"OK","TYPO")
I had one large formula instead of per cell and it just got too huge. Plus it would be harder to tell which was the dupe or typo to highlight in the guess accordingly.
Anyway.. some fun with formulas
Other than that, very nice work Scooby Some odds and ends in mine that might come in handy...
Keeping track of daily guesses.. with the date in an inserted column to the far left, and one inserted between Guess and Clue (or wherever).
Currencies Player Guess Today Clue 8/7/2010 AED steve199 1 9/2 AED AFN AMD ANG AOA ARS AUD AWG AZN BAM AFN steve199 2 0/0 BBD BDT BGN BHD BIF BMD BND BOB BRL BSD
Under Today:
=IF(A$6=TODAY(),COUNTIF($D$6:$D$30,D13),"")
(not incremental - it would show the total per person for the day each time they guessed)
Duplicate check:
Hidden columns to the side to check each currency for how many times it appears in the master currency list, do this per cell:
=COUNTIF($B$6:$B$173,H6)
then:
=IF(SUM(AD41:AO41)>10,"DUPE(S)!","OK")
Similar.. check for typos (using same range just for example):
=MATCH(H6,$B$6:$B$173,0)
then:
=IF(OR(COUNTIF(AD41:AO41,">0")=10,COUNTIF(AD41:AO41,">0")=0),"OK","TYPO")
I had one large formula instead of per cell and it just got too huge. Plus it would be harder to tell which was the dupe or typo to highlight in the guess accordingly.
Anyway.. some fun with formulas
