cwgii wrote:not sure if you are doing a 'year total ' but,,,,,, i ended up with 230 war out of sorting $31,000
SO I AM NOT SURE OF 'DOUBLE POSTS ETC'. AS I ONLY HAD 230 BY MY RECORDS, AND YOU HAVE ALREADY CREDITED ME WITH 232. I CANNOT IMAGINE HOW YOU COULD KEEP US ALL STRAIGHT.
SO, YET AGAIN, A PROFOUND , THANK YOU.
Thanks... I try to be accurate, but sometimes the data is a little off.
For 2010, I have ya down searching $30900.30 nickels and finding 2 V-Nicks, 20 Buffalos, and 240 War Nicks. That's a lot a nickels you've searched...
Within an Excel file, I use a worksheet to enter monthly data from each person's posts; it has column tables for easy sorting. Each month I create a new empty worksheet to collect the month's data. I have other worksheets that automatically summarize the state and yearly data by collecting the data from all of the monthly worksheets using conditional array formulas; no hand calculation necessary. Finally, I have an output worksheet that summarizes the data and then I copy it and paste into the first post of the thread. Hand pasting sorted monthly, yearly, and state data into the output worksheet takes the most time.