Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting events since last occurences
Hi everyone,
I have a database of results and i want to enter a formula in a cell (X1) that show the last time a number appeared. In column A is the number of the races in descending order (i.e 20 to 1), in column B is the number races since last win, in ascending order (1 to 20), in col C are the number of the winning horses only and in column D is the odds. The same number horse "23" (yes, he's was a beautiful jumper) may win race 6 and race 10 out of 20 races. I then sort the list with latest race at the top. In Col C, no 23 is now in cell C11 which means that it last won 11 races ago. If another 15 races take place and 23 doesn't win, it will now be 26 races since 23 last won. I'm looking for a formula that shows this instead on me having to filter out no 23 to see how many races have gone by since last win. please help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting occurences based on two criteria | Excel Discussion (Misc queries) | |||
Comparing and counting occurences in 2 columns | Excel Worksheet Functions | |||
Counting Occurences | Excel Discussion (Misc queries) | |||
Counting occurences of a specific day between two dates | Excel Worksheet Functions | |||
Counting the events | Excel Worksheet Functions |