With monday.comâ€™s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

I have the following function to get a max number if a row = 1 .. How could i use this to get the row id????

=LARGE(IF(Result!N2:N1001=1,Result!O2:O1001,""),2)

=LARGE(IF(Result!N2:N1001=

=MATCH(1,(Result!O1:O1001=

confirmed with CTRL+SHIFT+ENTER

regards, barry

Try:

=LARGE(IF(Result!N2:N1001=

confirmed with CTRL+SHIFT+ENTER

=LARGE(IF(Result!N2:N1001=

=LARGE(IF(Result!N2:N1001=

=LARGE(IF(Result!N2:N1001=

=LARGE(IF(Result!N2:N1001=

=LARGE(IF(Result!N2:N1001=

note that A2 is the race number so 1

=SMALL(IF(Result!N2:N1001=

etc...

=SMALL(IF(Result!$N$2:$N$1

NB_VC is finding the the nth row where column N = 1, is that what you need - isn't column O relevant?

regards, barry

Column E on sheet Stats is basicly putting the top 5 from sheet "Result" where its (j+l)/2 ..... i want to get the row its from so i can get horses name jockey ect...

J.P.B.S.xlsx

=INDEX(Result!D$2:D$1000,M

change the first range to whatever column you want for other info like jockey

regards, barry

Its attached

J.P.B.S.xlsx

regards, barry

=IF(E2="","",INDEX(Result!

confirmed with CTRL+SHIFT+ENTER and copied down the column

That still gives the same horses, though......

I populated the numbers in column A for every row, otherwise it will be more complex (and I also had to remove a #VALUE! error from column O in Results) - see attached

regards, barry

Racing.xlsx

```
=IF(E2="","",INDEX(Result!D$2:D$500,SMALL(IF(Result!O$2:O$500=E2,IF(Result!N$2:N$500=A2,ROW(Result!D$2:D$500)-ROW(Result!D$2)+1)),COUNTIFS(A$2:A2,A2,E$2:E2,E2))))
```

if i wanted to chnage my selection for form(B) or Odds (K)??
I have attached the spreadsheet with the new information in and the old information currently on the stats page.

What you do is on the INFO sheet on the top right you will see a button that says "Run TidyUp". Click on that and it should provide the top 5 horses ect on the stats page.... (It updates the Result page and lets you stats page pull the information)

Upon doing this the Results page is updated but the Stats page is full of #REF

J.P.B.S.xlsm

The things you can do....

1. Don't delete the Result sheet. Instead clear everything, then instead of "adding" a Result sheet in the macro, just use the existing one.

2. Convert all the formula in the Result sheet to include the INDIRECT() function. This is less recommended as the INDIRECT formula adds volatility to the workbook, i.e. force repeated recalculations....

for example the formula in B2 would be:

=IF(E2="","",INDEX(INDIREC

so everywhere you reference the Result sheet, you will need to wrap an INDIRECT() function around it. This will not delete the sheetname from the formula if you delete the RESULT sheet.

I tried it and did the results for today but still get a #Value! error....

Not sure why as formulars have stayed the same this time

Please see attached

J.P.B.S2.xlsm

All Courses

From novice to tech pro — start learning today.

=MAX(IF(INDIRECT("Result!$