Windows XP Pro
A spreadsheet has 86 rows. It is used to place competitive runs. In cell E5 is the time ran. In cell D6 is the penalty (if any). In cell E6 is the sum of E5 + D6. After all of the times are entered, the time in E6 is ranked against all of the other times posted and and the ranking placed in F5. The problem is not all of the lines have numeric entries. If a run is disqualified, a DQ is entered into cell D6. Plus there are non entry lines that have 0.000 for times. those times need to be exlcuded from the ranking. I can get numbers to rank, but I have to change the Rank cell reference to end at the last row that has a valid entry. I would like to have a formula that can be copied down all of the rows.
I have tried using both ISTEXT and ISNUMBER , but have not been able to make either work correctly. If I use ISTEXT, the cells with zeroes for times rank as 1. If I use ISNUMBER, the text is not carried from E6 to F5.
I am attaching screen shots to show what I have tried and the results.
If E6 is a number that is greater than 0, then rank E6 agasint E6:E86.
If E6 is text then enter the text