# Formula for Classification for best time in a race

#### GerryZ

##### Well-known Member
Hello al excel guru
I need a formula in D14 and copy down
that gives me back the ID numbers with 3 criteria:
1) Gender
2) CAT
3) best time

Book1
ABCD
1ID numbertimegenderCAT.
210:00:05MA
3350:00:10FA
420:00:19MB
5150:00:26FB
61000:00:29MA
750:01:13FB
8120:01:15FA
9160:01:18FB
10440:01:20MA
11
12
13citeria GENDERMtimeID number
14criteria CAT.A00:01:20?
1500:01:18?
1600:01:15?
1700:01:13?
1800:00:29?
1900:00:26?
2000:00:19?
2100:00:10?
2200:00:05?
Foglio1

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

#### Jake Blackmore

##### Board Regular
Hi,

Ok so using the time in column C I make the formula an array formula (which means rather than just hitting enter after typing it in you need to hold down CTRL & SHIFT & then click ENTER)
D14=MAX(\$A\$2:\$A\$10*(--(\$C\$2:\$C\$10=\$B\$13)*--(\$D\$2:\$D\$10=\$B\$14)*--(\$B\$2:\$B\$10=C14)))

If there isn't an answer it will simply return zero - if you don't enter this as an array you will probably get a #Value error.
Jake

#### GerryZ

##### Well-known Member
Wooow!! it works fine
thank you so much!!

Welcome

Replies
3
Views
698
Replies
3
Views
277
Replies
9
Views
679
Replies
5
Views
910
Replies
3
Views
652

1,196,021
Messages
6,012,904
Members
441,740
Latest member
Latrs

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back