Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Only Calculating Numerics
Hi :)
I'm setting up a spreadsheet for the fixtures/results/points table for a league so that all i have to do is enter the scores of each match and it will calculate the wins/draws/losses for each team and then calculate the points based on those wins/draws/losses. I've managed to do the formulas for wins, losses and points, but i'm struggling with the draws. The formula i'm using for draws is: =IF(E4=E3,1,0) It's adding 1 to a draw for each of the blank results, because technically they are equal. So what i would like to know is; is there a way i can set this formula up so that it will only take into account the numerical values for the scores, so it will only add 1 to draws when there is an actual score? Also, while i have your attention, is there a way i can sort the points table so the team with the most points is at the top and sorts itself when the points change? Even though every cell on those rows have formulas(except for the team names). Thanks in advance! :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete all non-numerics | Excel Programming | |||
Extract Numerics only | Excel Discussion (Misc queries) | |||
VALIDATION USING ALPHA-NUMERICS ONLY | Excel Programming | |||
Remove Non-Numerics from String | Excel Programming | |||
How to forecast non-numerics? | Excel Worksheet Functions |