Im trying to get the Max value from the longest wait time for the month of Jan, Feb and Mar.i tried using =max(if($c$c="Jan",$h$h)) but it wont work, can someone help me please? thank you so much.
SkillGroup | Year | Month | Day | Total Inbound Calls | Total Calls To Queue | Total Calls Abandoned In Queue | Longest Wait Time |
US Business Hours | 2019 | Jan | 1 | 86 | 82 | 4 | 0:00:45 |
US Business Hours | 2019 | Feb | 1 | 462 | 446 | 15 | 0:04:34 |
US Business Hours | 2019 | Mar | 1 | 388 | 372 | 13 | 0:07:19 |
German Queue | 2019 | Feb | 1 | 3 | 2 | 1 | 0:05:49 |
German Queue | 2019 | Mar | 1 | 5 | 5 | 0 | 0:00:06 |
Spain Queue | 2019 | Feb | 1 | 18 | 17 | 1 | 0:01:55 |
Spain Queue | 2019 | Mar | 1 | 9 | 9 | 0 | 0:00:18 |
Portugal Queue | 2019 | Feb | 1 | 9 | 9 | 0 | 0:00:28 |
Portugal Queue | 2019 | Mar | 1 | 9 | 9 | 0 | 0:04:51 |
Mandarin Queue | 2019 | Jan | 1 | 32 | 26 | 6 | 0:05:52 |
Mandarin Queue | 2019 | Feb | 1 | 8 | 8 | 0 | 0:00:09 |
Mandarin Queue | 2019 | Mar | 1 | 6 | 6 | 0 | 0:00:10 |
French Queue | 2019 | Feb | 1 | 2 | 1 | 1 | 0:01:03 |
French Queue | 2019 | Mar | 1 | 7 | 5 | 0 | 0:01:00 |
US Business Hours | 2019 | Jan | 10 | 818 | 750 | 59 | 0:11:50 |
US Business Hours | 2019 | Feb | 10 | 93 | 92 | 2 | 0:04:34 |
US Business Hours | 2019 | Mar | 10 | 107 | 102 | 5 | 0:03:38 |
German Queue | 2019 | Jan | 10 | 10 | 8 | 2 | 0:04:30 |
Spain Queue | 2019 | Jan | 10 | 9 | 9 | 0 | 0:03:02 |
Portugal Queue | 2019 | Jan | 10 | 10 | 10 | 0 | 0:02:11 |
Mandarin Queue | 2019 | Jan | 10 | 17 | 16 | 1 | 0:01:23 |
Mandarin Queue | 2019 | Feb | 10 | 29 | 28 | 1 | 0:00:59 |
Mandarin Queue | 2019 | Mar | 10 | 6 | 6 | 0 | 0:00:08 |
French Queue | 2019 | Jan | 10 | 2 | 2 | 0 | 0:00:20 |
US Business Hours | 2019 | Jan | 11 | 653 | 599 | 50 | 0:07:28 |
US Business Hours | 2019 | Feb | 11 | 685 | 669 | 16 | 0:26:02 |
US Business Hours | 2019 | Mar | 11 | 557 | 554 | 3 | 0:03:20 |
German Queue | 2019 | Jan | 11 | 8 | 8 | 0 | 0:00:12 |
German Queue | 2019 | Feb | 11 | 7 | 7 | 0 | 0:00:23 |
German Queue | 2019 | Mar | 11 | 17 | 16 | 1 | 0:03:03 |