excel Help Needed

Reply #9

lottaloot — Sat, 12 Nov 2005 21:18:34 GMT

Thanks. I will try send it to you tonight.

Reply #8

Thoth — Sat, 12 Nov 2005 19:38:29 GMT

I think you should try using the Database Functions....DMAX, DCOUNT, DAVERAGE.I have an Excel workbook that uses them to display the total hits, largest skip (max out), averages and other info for each pair by position (front,back, and split). It is a bit tricky to update though. If you care to send me your states history in Excel format I will update it for you and send you the workbook file.integraGSR18L@aol.comScott

Reply #7

JKING — Sat, 12 Nov 2005 13:27:18 GMT

Try this link:http://www.mrexcel.com/board2/index.phpIt doesn't answer your question, but, sends you to a really good source for the solution.

Reply #6

lottaloot — Sat, 12 Nov 2005 11:09:49 GMT

I want to see an idividual list of far many skips hits for each pair (each time they hit) Hard to explain it...The sheet already gives me the skips of a pair I can see how many times it has hit as well. Like Versabet doesI want it to give me the max out average out of the pairs

Reply #5

Thoth — Sat, 12 Nov 2005 05:27:47 GMT

Lottaloot,Do you want a spreadsheet that tracks all the pairs in each position (front-back-split) and how far they are currently out, or do you want to see a list of the skips and hits for each pair

Reply #4

lottaloot — Sat, 12 Nov 2005 04:01:54 GMT

Nope, that's not it.The quotation marks return a blank cell.Trying to develop this for the OK spreadsheet--since it is just taking off.and would like to incorporate it into my all states spreadsheet.

Reply #3

cahaba — Sat, 12 Nov 2005 03:55:45 GMT

You may have too many quotation marks

Reply #2

lottaloot — Sat, 12 Nov 2005 03:52:47 GMT

Actually I typed in the word pair 33 was the pair that I was in search of.=IF(COUNT($H:$M)=33,1, )I could type in any pair that I happen to be searching for.

Reply #1

hypersoniq — Sat, 12 Nov 2005 03:44:23 GMT

that formula seems like part of a much more complex sheet.I don't recognise pair , that might have been a few pre-filtering columns that identified pairs with the word pair ...

excel Help Needed

lottaloot — Sat, 12 Nov 2005 03:15:30 GMT

Trying to come up with a formula that will count the max out of a pairSomeone gave me this formula but it doesn't seem to work for me. =IF(COUNT($H:$M)=( pair ),1,