Spreadsheet: 123113d1317352110-automatic-filter-abcfilter
Sheet: Sheet1

Name | No |  | Pivot Table Answer |  |  | Name | No | <<Advabced Filter Answer
abc | 47 |  |  |  |  | abc
def | 41 |  | Row Labels | Sum of No
ghi | 83 |  | abc | 3546 |  | Name | No
abc | 53 |  | def | 3711 |  | abc | 47
def | 89 |  | ghi | 3803 |  | abc | 53
ghi | 79 |  | Grand Total | 11060 |  | abc | 26
abc | 26 |  |  |  |  | abc | 96
def | 61 |  |  |  |  | abc | 39
ghi | 88 |  |  |  |  | abc | 67
abc | 96 |  |  |  |  | abc | 40
def | 93 |  |  |  |  | abc | 95
ghi | 67 |  |  |  |  | abc | 62
abc | 39 |  |  |  |  | abc | 96
def | 90 |  |  |  |  | abc | 82
ghi | 17 |  |  |  |  | abc | 26
abc | 67 |  |  |  |  | abc | 37
def | 75 |  |  |  |  | abc | 52
ghi | 32 |  |  |  |  | abc | 18
abc | 40 |  |  |  |  | abc | 92
def | 22 |  |  |  |  | abc | 17
ghi | 99 |  |  |  |  | abc | 61
abc | 95 |  |  |  |  | abc | 14
def | 69 |  |  |  |  | abc | 12
ghi | 83 |  |  |  |  | abc | 83
abc | 62 |  |  |  |  | abc | 85
def | 91 |  |  |  |  | abc | 48
ghi | 35 |  |  |  |  | abc | 45
abc | 96 |  |  |  |  | abc | 82
def | 45 |  |  |  |  | abc | 74
ghi | 20 |  |  |  |  | abc | 26
abc | 82 |  |  |  |  | abc | 77
def | 91 |  |  |  |  | abc | 28
ghi | 56 |  |  |  |  | abc | 47
abc | 26 |  |  |  |  | abc | 79
def | 28 |  |  |  |  | abc | 88
ghi | 51 |  |  |  |  | abc | 64
abc | 37 |  |  |  |  | abc | 17
def | 52 |  |  |  |  | abc | 61
ghi | 13 |  |  |  |  | abc | 21
abc | 52 |  |  |  |  | abc | 66
def | 10 |  |  |  |  | abc | 34
ghi | 15 |  |  |  |  | abc | 51
abc | 18 |  |  |  |  | abc | 12
def | 20 |  |  |  |  | abc | 14
ghi | 97 |  |  |  |  | abc | 83
abc | 92 |  |  |  |  | abc | 42
def | 70 |  |  |  |  | abc | 24
ghi | 86 |  |  |  |  | abc | 47
abc | 17 |  |  |  |  | abc | 85
def | 57 |  |  |  |  | abc | 46
ghi | 69 |  |  |  |  | abc | 42
abc | 61 |  |  |  |  | abc | 81
def | 11 |  |  |  |  | abc | 61
ghi | 73 |  |  |  |  | abc | 72
abc | 14 |  |  |  |  | abc | 61
def | 88 |  |  |  |  | abc | 36
ghi | 80 |  |  |  |  | abc | 89
abc | 12 |  |  |  |  | abc | 66
def | 85 |  |  |  |  | abc | 19
ghi | 75 |  |  |  |  | abc | 44
abc | 83 |  |  |  |  | abc | 21
def | 67 |  |  |  |  | abc | 67
ghi | 36 |  |  |  |  | abc | 76
abc | 85 |  |  |  |  | abc | 53
def | 40 |  |  |  |  | abc | 21
ghi | 33 |  |  |  |  | abc | 82
abc | 48 |  |  |  |  | abc | 28
def | 74 |  |  |  |  | abc | 51
ghi | 30 |  |  |  |  | abc | 19
abc | 45 |  |  |  |  | abc | 60
def | 16 |  |  |  |  | abc | 36
ghi | 24
abc | 82
def | 17
ghi | 99
abc | 74
def | 10
ghi | 94
abc | 26
def | 14
ghi | 23
abc | 77
def | 46
ghi | 56
abc | 28
def | 98
ghi | 79
abc | 47
def | 52
ghi | 72
abc | 79
def | 59
ghi | 44
abc | 88
def | 10
ghi | 72
abc | 64
def | 12
ghi | 98
abc | 17
def | 23
ghi | 12
abc | 61
def | 72
ghi | 68
abc | 21
def | 10
ghi | 25
abc | 66
def | 46
ghi | 14
abc | 34
def | 87
ghi | 68
abc | 51
def | 74
ghi | 21
abc | 12
def | 82
ghi | 97
abc | 14
def | 42
ghi | 32
abc | 83
def | 63
ghi | 11
abc | 42
def | 72
ghi | 49
abc | 24
def | 93
ghi | 38
abc | 47
def | 81
ghi | 98
abc | 85
def | 31
ghi | 22
abc | 46
def | 68
ghi | 36
abc | 42
def | 80
ghi | 84
abc | 81
def | 39
ghi | 81
abc | 61
def | 57
ghi | 76
abc | 72
def | 44
ghi | 24
abc | 61
def | 73
ghi | 21
abc | 36
def | 54
ghi | 55
abc | 89
def | 96
ghi | 82
abc | 66
def | 16
ghi | 92
abc | 19
def | 98
ghi | 56
abc | 44
def | 42
ghi | 14
abc | 21
def | 82
ghi | 48
abc | 67
def | 84
ghi | 39
abc | 76
def | 35
ghi | 94
abc | 53
def | 19
ghi | 71
abc | 21
def | 33
ghi | 67
abc | 82
def | 86
ghi | 54
abc | 28
def | 59
ghi | 66
abc | 51
def | 19
ghi | 70
abc | 19
def | 18
ghi | 10
abc | 60
def | 88
ghi | 49
abc | 36
def | 42
ghi | 81