Spreadsheet: 691216d1597571777-extract-information-from-a-table-trimmean-based-on-the-user-input-2020-08-16-oeldere-chaliseyp-691212d1597570543-extract-information-from-a-table-trimmean-base
Sheet: table

Pay Item | Filter Rate | group | subgroup
G7P9.1.1 | 25883
G2C2P1 | 132000
G4P1 | 179657.5
G4P2 | 763.13
G4P4 | 5225
G10P1 | 93025.63
G36P1 | 1553.75
G36P2.1 | 10587.5
G36P2.1 | 12237.5
G38P2.A | 15180
G36P2.1 | 20281.25
G36P1 | 39524.38
G36P2.1 | 60.5
G36P2.1 | 33.96
R44P2c | 33.69
G38P2.A | 41.8
R44P4 | 21445.92
[NAME] | 49562.11
[NAME] | 116659.68
[NAME] | 82003.08
R44P2c | 43980.06
R44P2b | 58717.86
R44P2c | 97182.8
G4P4 | 12.72
R44P7.HW.BC.94 | 26.62
G4P4 | 46.82
R44P6.21 | 32.46
R44P2c | 92.68
R44P3 | 108.63
R44P6.21 | 39.33
R44P7.W.BC.3 | 4.48
R44P1.1 | 109.18
R44P2 | 701.11
R44P8 | 33.55
R44P6.21 | 25.11
R44P7.W.BC.4 | 2352.08
R83P7.20 | 264
R44P7.W.BC.4 | 107.66
R44P8 | 39.88
R83P3 | 70.13
R83P6 | 30.59
R44P5.2 | 93.33
R44P1.1 | 1.66
R83P1.1 | 4.61
R44P8 | 2.42
R83P1.1 | 2.86
R44P7.HW.BC.94 | 28.19
R44P7.W.BC.4 | 5050539.59
R44P7.W.BC.4 | 80.94
R83P7.20 | 27.12
R44P7.W.BC.4 | 66.49
R83P12 | 1848000
R44P2 | 302843.21
R83P12 | 1214.15
R178P1 | 2718.99
R44P2 | 35220.1
R201P2 | 2792060.6
R44P7.HW | 860.3
R83P7.20 | 94728.42
R83P6 | 40643.6
R44P7.HW | 116618.61
R44P7.HW | 21030.63
G38P3.5 | 115.04
R178P19 | 467629.61
G2C2P1 | 288.58
R83P7.20 | 70.35
R178P19 | 41.54
G36P1 | 69.12
G2C2P1 | 63.35
G36P1 | 47.63
G40P2 | 43.6
R44P2b | 74.24
G40P1 | 205.08
G36P1 | 235.27
R83P12 | 282
R44P8.11 | 353.6
R44P8.11 | 479.55
R44P8.9.1 | 673.54
[NAME] | 823.56
G38P3.5 | 1045.08
[NAME] | 1436.59
R44P2a | 1911.3
G2C2P1 | 3827.18
[NAME] | 814.52
R44P2 | 874.15
G38P3.5 | 1251.55
R44P5.600.4. | 1207.47
G38P3.5 | 1895.09
R44P7.HW.PC.67 | 2006.92
R44P2 | 3644.41
[NAME]. | 30946.97
G40P1 | 13015.86
R44P5.2400.3. | 4166.38
R44P3 | 2635.46
R44P3 | 2483
R44P5.2400.3. | 1855.52
R44P3 | 2249.86
R44P5.600.4. | 1931.52
R44P5.1800.4. | 3514.44
R44P7.HW.PC.75 | 1498.02
R44P5.525.4. | 3467.66
R44P5.450.4. | 4381.69
G38P3.E | 4247.54
R44P5.600.4. | 4275.16
R44P5.750.4. | 3514.44
R44P5.750.4. | 2502.69
R44P7.P.109 | 2055.31
R44P7.P.120 | 2733
R44P5.525.4. | 363.14
R44P5.525.4. | 564.21
R44P5.1500.4. | 87.78
R44P5.1500.4. | 72.43
R44P7.HW.BC.106 | 41.11
R44P7.P.120 | 44.53
R44P5.1050.4. | 333.28
R44P5.1050.4. | 48.33
R44P7.P.172 | 1999.22
R44P7.P.126 | 103.28
R44P7.HW.BC.106 | 160.22
R44P7.P.109 | 262.81
R44P7.P.109 | 81.02
R44P7.P.109 | 225.16
R44P7.P.109 | 4.63
R44P7.P.109 | 8.6
R44P7.P.109 | 17.4
R44P7.HW.PC.69 | 27.24
[NAME] | 33.71
R44P7.HW.PC.69 | 27.49
R44P7.HW.PC.69 | 52.24
R44P7.P.109 | 59.58
R44P7.P.19 | 8.38
[NAME] | 5.48
[NAME] | 26.51
[NAME] | 3.3
R44P7.CP.9 | 16.12
R44P7.D.ACO.2 | 68.71
R44P7.CP.9 | 24.31
[NAME] | 48.21
R44P3 | 57.42
R15P1.T.SA.F | 233.07
R44P20.M.3 | 199.33
R44P7.3.a | 517.47
R44P20.M.3 | 24.67
R44P20.M.3 | 22.05
R44P5.4 | 202.76
R44P20.M.2 | 445.05
R50P1.2 | 74.21
R44P7.1 | 95.74
R33P1 | 124.77
R44P20.M.2 | 30.41
R55P2 | 146455.77
R23P3.300.UPVC | 397.71
R55P2.170 | 11.73
R55P2 | 54.89
R44P7.1 | 17.35
R33P1 | 14.09
R44P7.3.a | 111.88
R44P7.2.b | 144.95
R55P2 | 383.56
R50P1.4 | 4.52
R55P2.170 | 6.01
R44P4 | 346.63
R44P4 | 536.89
R44P7.1 | 894.08
R44P4 | 9.87
R55P5 | 15.6
R58P3.1 | 3473.4
R44P20.M.2 | 64.46
R55P5 | 48.78
R50P1.3 | 665.9
R55P5 | 18.74
R33P2.4.1 | 18.04
R83P3 | 6.48
[NAME] | 12.86
[NAME] | 10.61
R82P3 | 32.04
R55P5 | 161.77
R83P3 | 363.23
R83P2 | 2.24
R71P2.4 | 200.26
R83P6 | 365.85
R71P2.4 | 161.95
R55P2 | 215.41
R83P8 | 182.46
R55P5 | 206.75
R83P8 | 168.85
R58P3.1 | 225.03
R71P2.4 | 79.53
R446P2.5 | 22.09
R83P8 | 15.18
R55P5 | 518.29
R82P3 | 122.89
R83P8 | 163.06
R84P1.10 | 89.96
R101P1.2 | 57.13
R83P8 | 219.94
R71P2.4 | 4443.02
R71P2.4 | 1264.06
R71P2.4 | 2637.9
R132P1 | 29733.34
R83P7 | 24.31
R446P3.2 | 3.09
R132P1 | 0.85
R101P1.14 | 1.86
R83P7 | 1.75
R83P7 | 1.81
R446P3.2.3 | 2.34
R132P5 | 2.34
R132P3.1 | 3.21
R132P5 | 3.3
R141P3.E6 | 2.78
R132P3.1 | 117.12
R141P3.E6 | 38.33
R132P3.1 | 63.29
R132P3.1 | 8.48
R132P3.1 | 8.48
R446P4.3.5 | 8.48
R132P4 | 8.48
R132P4 | 4.4
R141P2.Ch | 224.13
R141P2.Ch | 224.13
R446P4.3.5 | 207.6
R141P3.L1 | 235.35
R141P3.C1 | 249.23
R141P2.Ch | 5625.73
R141P3.L1 | 41906.03
R141P3.L4 | 142.63
R141P3.E1 | 150.71
R132P8.9 | 141.96
R141P3.E1 | 183.89
R141P2.Ch | 302.08
R141P2.Ch | 318.2
R141P3.E5 | 7490.38
R143P1.R2-6B | 6046.46
R44P7.P.122 | 7490.4
R142P3.Y | 6046.46
R141P3.E5 | 7490.4
[NAME] | 7912.32
R44P7.P.102 | 6187.09
R142P3 | 6505.88
R142P3.Y | 5061.96
R44P5.375.6. | 439.2
R44P7.P.132 | 112.34
R44P7.P.102 | 166.49
[NAME] | 48.79
R44P7.P.132 | 56.46
R44P7.P.102 | 61.25
R142P3 | 142.05
G40Pa.R.KG.SF | 135.33
R142P3.W | 121.89
R44P3 | 95.74
R44P7.P.122 | 71.74
[NAME] | 88.63
R33P2.4.1 | 212.53
G40P1 | 15.98
[NAME] | 135.33
R44P5.375.3. | 35.76
R33P6.2.CIS.1 | 89.21
R44P2 | 298.16
G40P1 | 104.39
R44P7.CP.15 | 520.2
R44P7.CP.15 | 171.62
R44P2 | 21.67
R44P2 | 272.62
R33P2.2.100.1 | 54.3
R73P2 | 9.52
R44P7.P.135 | 653.88
R33P2.4.1 | 8.15
R44P7.CP.15 | 4.4
R33P2.2.100.1 | 37.91
R55P15.4 | 32.34
[NAME] | 11
R44P6.2.2 | 5.5
R44P7.CP.15 | 330
R44P7.CP.15 | 3.75
[NAME] | 330
R44P7.CP.15 | 286
R44P7.CP.15 | 253
R33P6.2.CIS.1 | 310.56
R33P3.1.A | 46.88
R55P1 | 31.88
R33P6.2.CIS.1 | 1.1
R15P1.SM | 2.82
R33P3.1.A | 4.69
R141P1.E1 | 1.87
R33P3.1.A | 2.82
R33P6.2.CIS.1 | 2.82
R33P6.2.CIS.1 | 2.82
R141P1.E1 | 2.82
R73P2 | 12.38
R446P3.2 | 4.69
R141P1.BB | 112.52
R33P6.2.CIS.1 | 35.63
R44P2 | 17.73
R141P1.L3 | 6.07
R141P1.E4 | 375.05
R141P1.C1 | 375.05
R101P1.9 | 375.05
R141P1.BB | 375.05
R44P6.2.2 | 375.08
R141P1.E4 | 375.05
R141P1.C1 | 375.06
R141P1.L3 | 375.03
R141P1.E4 | 375.1
R101P1.a.1 | 375.05
R143P1.R5.400.a | 375.03
R141P2.TB | 375.03
R141P2.TB | 375.05
R141P2.TB | 375.05
R82P2 | 3422.32
R143P1.R5.400.a | 168.77
R141P1.C1 | 6563.35
R101P1.a.1 | 281.28
[NAME] | 137.5
R141P2.TB | 82.5
R141P1.L3 | 147.63
R141P1.C1 | 179.31
R141P1.L3 | 305.48
R141P1.L3 | 112.06
R141P1.L3 | 74
R173P1.150.RAB.C.RF | 164.88
R141P1.L3 | 663.16
R143P1.W4-6 | 5.62
R143P1.R2-11.a | 9.37
R143P1.R2-11.a | 22
R143P6 | 2624421.86
R143P1.R5.400.a | 1985.01
R143P1.R1-3 | 521.57
 |  |  | G36
 |  |  |  |  |  | G36P1
 |  |  | G36P2.1 | 10587.5 |  | G36P2.1
 |  |  | G36P2.1 | 12237.5
 |  |  | G36P2.1 | 20281.25
 |  |  | G36P2.1 | 60.5
 |  |  | G36P2.1 | 33.96
 |  |  | G36P1 | 69.12
 |  |  | G36P1 | 47.63
 |  |  | G36P1 | 235.27
 |  |  | G36P1 | 1553.75
 |  |  | G36P1 | 39524.38
I have got a list of pay items - which are combination of letters and numbers always starting with letter preceded by letters. Like G7P9.1 But the users will only enter the value for G7  So, there can be several entries starting with [NAME] so, the user should be able to see the values starting from G7* or R44* or G38* and so on as shown in the attached table.  And, if there are lets say several values with same item code Say G36P1, then on the resultant table should show average (possibly trimmean average as some values can be reasonably high or low)  I have shown in example what end results is needed for a case (cell D332)