complicated if function

 

Dear Excelgeek,

I need your help to make formula for my study, here is the result table:

 

Male Result
Age Very Good Good Fair Poor Very Poor
10 04:47 04:48 05:49 05:50 06:52 06:53 07:53 07:54
11 04:17 04:18 05:14 05:15 06:12 06:13 07:09 07:10
12 04:12 04:13 05:05 05:06 05:57 05:58 06:49 06:50
13 07:23 07:24 08:40 08:41 09:58 09:59 11:15 11:16

 

Female

Result
Age Very Good Good Fair Poor Very Poor
10 05:16 05:17 06:28 06:29 07:37 07:38 08:48 08:49
11 05:04 05:05 06:10 06:11 07:19 07:20 08:28 08:29
12 04:52 04:53 05:54 05:55 06:55 06:56 07:56 07:57
13 09:29 09:30 10:55 10:56 12:21 12:22 13:46

13:47

From this result table I like to shown the Result cell for my worksheet using excel functions or formula, here is my worksheet:

# Name SEX TIME RESULT
1 ADISA Female 09:52  
2 ADAM Male 06:56  

Please help me guys, it really make me headache to figure the formula for this table. Yell Thank you so much for helping me. EmbarassedLaughingCool

By: Leslie

Leave a Reply

Your email address will not be published. Required fields are marked *