Spreadsheet: 689842d1596699564-filter-based-on-a-value-form-a-table-column-items-excel
Sheet: Required

[NAME], Hill Rd & B'makers Ck ($11.9M) | The filter should go in cell [NAME] and the data should be displayed as per below  and should be filtered based on the A1 value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], Hill Rd & B'makers Ck ($11.9M)
PayItemCode | FilterRate | AcceptedRate | ProjectName |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
R11P7.P.9 | 24.3 | 24 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
G7P5.2.125.3.50.2 | 24.3 | 24 | [NAME]
R152P1.100x2 | 25 | 25 | [NAME]
R152P2 | 640.6 | 641 | [NAME]
G1P20.M.2 | 1939.67 | 2219 | [NAME]
G10P1 | 355085.67 | 279773 | [NAME]
[NAME] | 210.9 | 175 | [NAME]
R116P1.1 | 0.72 | 1 | [NAME]
R116P3.3 | 125.63 | 131 | [NAME]
R116P3.4 | 103.5 | 131 | [NAME]
R116P4.3 | 146.53 | 183 | [NAME]
[NAME] | 158.67 | 183 | [NAME]
R116P12.5 | 114 | 57 | [NAME]
R116P4.3.2 | 138.03 | 183 | [NAME]
R11P2 | 32.27 | 49 | [NAME]
R11P2c | 38.43 | 49 | [NAME]
R11P4 | 34.46 | 75 | [NAME]
R11P5.375.3.RRJ | 178 | 158 | [NAME]
R11P5.450.3.RRJ | 210 | 182 | [NAME]
R11P5.525.3.RRJ | 255 | 217 | [NAME]
R11P5.600.3.RRJ | 322 | 269 | [NAME]
R11P5.750.3.RRJ | 421 | 328 | [NAME]
R11P7.P.173 | 2482.33 | 1747 | [NAME]
R11P7.P.56 | 2565.33 | 1944 | [NAME]
R11P7.P.42 | 2383 | 1554 | [NAME]
R11P7.P.11 | 1964.33 | 1054 | [NAME]
R11P7.CP.15 | 1342.67 | 1078 | [NAME]
R11P7.M.7 | 525.67 | 327 | [NAME]
R11P7.C.P.PT | 343.67 | 461 | [NAME]
R11P7.P.20 | 2508.33 | 2086 | [NAME]
R11P7.P.46 | 1201.33 | 926 | [NAME]
R11P7.P.57 | 60925 | 114807 | [NAME]
R11P7.P.75 | 2855.33 | 2444 | [NAME]
R11P7.P.156 | 2481.87 | 1902 | [NAME]
G7P12.11.CE.ES | 555.67 | 427 | [NAME]
R132P1 | 8.56 | 7 | [NAME]
R132P2 | 185.33 | 48 | [NAME]
R132P4 | 118.9 | 121 | [NAME]
R132P5 | 146.57 | 161 | [NAME]
R141P10.E1 | 27.97 | 26 | [NAME]
[NAME] | 112.27 | 105 | [NAME]
[NAME] | 46.9 | 47 | [NAME]
R141P3.L1 | 0.8 | 1 | [NAME]
R141P4.TB.a | 9.4 | 4 | [NAME]
R141P3.BB | 2.63 | 4 | [NAME]
R141P3.L3 | 1.39 | 3 | [NAME]
R141P3.C1 | 1.59 | 3 | [NAME]
R141P3.E1 | 2.32 | 3 | [NAME]
R141P3.E3 | 3.65 | 4 | [NAME]
R141P4 | 60.93 | 100 | [NAME]
R142P3.n.W | 7.32 | 8 | [NAME]
R142P3.n.R | 7.32 | 8 | [NAME]
R142P3.n.Y | 7.33 | 8 | [NAME]
R142P3.n.YY | 7.36 | 8 | [NAME]
R143P2.a.1 | 251.93 | 33 | [NAME]
[NAME] | 120.78 | 140 | [NAME]
R143P6.a.R1-2 | 79.77 | 79 | [NAME]
R143P6.a.R2-3 | 89.23 | 107 | [NAME]
R143P6.a.R2-4 | 100.43 | 141 | [NAME]
R143P6.a.R2-6 | 102.1 | 146 | [NAME]
R143P6.a.R2-14 | 128.57 | 225 | [NAME]
R143P6.a.R5-13 | 63.13 | 29 | [NAME]
R143P6.a.R5-400 | 63.13 | 29 | [NAME]
R143P6.a.R5-420 | 62.97 | 29 | [NAME]
R143P6.a.R5-460 | 63 | 29 | [NAME]
R143P6.a.R8-2 | 63 | 29 | [NAME]
R143P6.a.R9-4 | 72.17 | 56 | [NAME]
R143P6.a.W6-3 | 90.93 | 112 | [NAME]
R143P6.a.W8-25B | 81.57 | 84 | [NAME]
R143P6.a.G9-60 | 75.87 | 67 | [NAME]
R143P6.a.D4-1-2 | 63 | 29 | [NAME]
R15P1.SM | 34.8 | 39 | [NAME]
R15P1.RT | 45.44 | 59 | [NAME]
[NAME] | 52.81 | 57 | [NAME]
R15P1.SA.2 | 81.87 | 95 | [NAME]
R15P1.SB | 57.73 | 65 | [NAME]
[NAME] | 58.5 | 63 | [NAME]
R15P1.SF | 25.71 | 34 | [NAME]
R15P1.PR | 420.57 | 563 | [NAME]
R15P1.VC.b | 69.9 | 73 | [NAME]
R201P9 | 658.37 | 460 | [NAME]
R201P8.3 | 36.53 | 46 | [NAME]
R201P15.2 | 821.87 | 846 | [NAME]
R201P13.16 | 50.2 | 54 | [NAME]
R178P18 | 2.17 | 2 | [NAME]
R178P2.1.a | 1.22 | 1 | [NAME]
R178P3 | 4.27 | 4 | [NAME]
R178P13.SD.1 | 0.14 | 0 | [NAME]
R173P1.100.20 | 62.23 | 52 | [NAME]
R173P1.150.F82.25 | 139.07 | 142 | [NAME]
R173P1.100.M.F82.32 | 79.23 | 65 | [NAME]
R173P1.75.20.1 | 54.77 | 47 | [NAME]
R173P1.75.20 | 56.38 | 47 | [NAME]
R33P1 | 36.21 | 20 | [NAME]
R33P6.2 | 263.17 | 494 | [NAME]
R33P2.2.100.1 | 15.17 | 8 | [NAME]
R33P2.1.65 | 8.88 | 8 | [NAME]
R33P3.1.A | 90.13 | 94 | [NAME]
R33P4 | 5.85 | 6 | [NAME]
R33P6.2.CIS.1 | 139.67 | 115 | [NAME]
G40P1.2.1 | 42784.67 | 20345 | [NAME]
R44P1.1 | 18.63 | 41 | [NAME]
R44P2 | 25.21 | 35 | [NAME]
R44P4 | 29.54 | 69 | [NAME]
R44P6.2.1 | 0.3 | 0 | [NAME]
R55P1 | 218.77 | 166 | [NAME]
R55P2 | 66.7 | 65 | [NAME]
R55P5 | 34.7 | 32 | [NAME]
R71P2.4 | 97.43 | 104 | [NAME]
R82P1 | 188.83 | 222 | [NAME]
R82P2 | 1.59 | 1 | [NAME]
R82P3 | 2.65 | 2 | [NAME]
R83P1.1 | 323.23 | 313 | [NAME]
R83P2 | 5.23 | 5 | [NAME]
R83P3 | 19.7 | 18 | [NAME]
R83P6 | 44.47 | 42 | [NAME]
R83P7 | 38.6 | 36 | [NAME]
CTO.01 |  | 5626000 | [NAME]
G7P10.5.100.4 | 12.06 | 12 | [NAME], Hill Rd & B'makers Ck ($11.9M)
G1P1.TCS | 112611.67 | 136955 | [NAME], Hill Rd & B'makers Ck ($11.9M)
G1P20.M.4 | 3462.3 | 1233 | [NAME], Hill Rd & B'makers Ck ($11.9M)
G1P20.M.3 | 3439.77 | 6166 | [NAME], Hill Rd & B'makers Ck ($11.9M)
G10P1 | 682350.07 | 739169 | [NAME], Hill Rd & B'makers Ck ($11.9M)
G7P5.2.50.2 | 6.64 | 6 | [NAME], Hill Rd & B'makers Ck ($11.9M)
G7P5.2.80.2 | 12.86 | 14 | [NAME], Hill Rd & B'makers Ck ($11.9M)
[NAME] | 112.67 | 64 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R204P1 | 24059.67 | 28495 | [NAME], Hill Rd & B'makers Ck ($11.9M)
G36P1 | 548.6 | 734 | [NAME], Hill Rd & B'makers Ck ($11.9M)
G36P2.2 | 6201.05 | 9248 | [NAME], Hill Rd & B'makers Ck ($11.9M)
G36P2.3 | 10414.52 | 15414 | [NAME], Hill Rd & B'makers Ck ($11.9M)
G36P2.1 | 8367.88 | 9248 | [NAME], Hill Rd & B'makers Ck ($11.9M)
G38P2.A | 17649.85 | 9248 | [NAME], Hill Rd & B'makers Ck ($11.9M)
G4P1 | 21904.68 | 26512 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R101P1.8 | 4.96 | 5 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R101P6.1 | 166.89 | 247 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R101P6.2 | 108.27 | 185 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R101P6.3 | 85.3 | 154 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R101P6.4 | 75.03 | 123 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R106P1.6 | 2 | 2 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R106P2 | 1.84 | 1 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R106P5 | 1.97 | 1 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R106P7.2 | 306.36 | 200 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R116P1 | 1.21 | 1 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R11P2c | 40.72 | 36 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R11P2a | 35.41 | 36 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R11P4 | 61.42 | 59 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R11P5.375.2.RRJ | 129.66 | 120 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R11P5.450.2.RRJ | 144.58 | 138 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R11P5.525.2.RRJ | 177.9 | 158 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R11P5.600.2.RRJ | 226.63 | 185 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R11P5.675.2.RRJ | 244.27 | 205 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R11P5.750.2.RRJ | 272.8 | 224 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R11P7.P.126 | 2277.01 | 2096 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R11P7.P.135 | 2406.76 | 2158 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R11P7.MP.8 | 1190.2 | 1171 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R11P7.P.168 | 2401.06 | 1973 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R132P1 | 20.22 | 19 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R132P2 | 442 | 555 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R132P3.1 | 106.93 | 148 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R132P4 | 85.6 | 74 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R132P8.20 | 1825.2 | 3699 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R141P3.L1 | 1.85 | 2 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R141P4.TB.a | 10.23 | 10 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R141P3.BB | 3.68 | 4 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R141P4.TF.a | 12.24 | 12 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R141P3.C1 | 2.72 | 2 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R141P3.E1 | 3.16 | 4 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R141P4.TF | 380.53 | 401 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R141P4.PX | 44.02 | 49 | [NAME], Hill Rd & B'makers Ck ($11.9M)
[NAME] | 88.74 | 111 | [NAME], Hill Rd & B'makers Ck ($11.9M)
[NAME] | 90.8 | 117 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R141P4.TB | 86.69 | 105 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R142P3.YY | 9.62 | 10 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R142P3.W | 9.62 | 10 | [NAME], Hill Rd & B'makers Ck ($11.9M)
[NAME] | 9.62 | 10 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R143P1.R1-2 | 76.28 | 117 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R143P1.R2-4B | 155.37 | 166 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R143P3 | 100.9 | 99 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R143P6 | 117.71 | 111 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R151P2 | 1155.37 | 1356 | [NAME], Hill Rd & B'makers Ck ($11.9M)
[NAME] | 48.32 | 46 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R15P1.SM | 29.18 | 29 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R15P1.SF | 33.83 | 28 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R201P9 | 406.7 | 203 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R178P1 | 0.43 | 1 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R178P18 | 5.58 | 6 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R178P3 | 6.46 | 8 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R178P19 | 52.73 | 62 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R178P7 | 1.01 | 1 | [NAME], Hill Rd & B'makers Ck ($11.9M)
[NAME] | 83.15 | 80 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R173P1.75.20.1 | 46.36 | 60 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R33P1 | 62.76 | 43 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R33P2.1.100 | 11.3 | 19 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R33P3.1.A | 116.54 | 73 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R33P4 | 3.99 | 4 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R33P6.2.CIS.1 | 130.15 | 117 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R38P1 | 89.63 | 43 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R38P2.4.GPS | 16.04 | 21 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R38P3 | 278.88 | 234 | [NAME], Hill Rd & B'makers Ck ($11.9M)
G40P1.2.1 | 8328.72 | 14181 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R44P1.1 | 20.35 | 8 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R44P2 | 41 | 40 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R44P3 | 35.79 | 49 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R44P4 | 58.85 | 62 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R44P5 | 54.84 | 51 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R44P7.3.a | 3.13 | 3 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R44P7.3.b | 8.94 | 10 | [NAME], Hill Rd & B'makers Ck ($11.9M)
[NAME] | 198.07 | 185 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R50P2 | 20.19 | 18 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R71P1.8 | 96.28 | 74 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R82P1 | 229.75 | 196 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R179P2 | 0.53 | 1 | [NAME], Hill Rd & B'makers Ck ($11.9M)
[NAME] | 0.47 | 1 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R179P17.1.1 | 52.73 | 62 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R179P10 | 1438.64 | 1110 | [NAME], Hill Rd & B'makers Ck ($11.9M)
[NAME]..NT.CL | 1603.02 | 1295 | [NAME], Hill Rd & B'makers Ck ($11.9M)
CTO.01 |  | 11942870 | [NAME], Hill Rd & B'makers Ck ($11.9M)
R132P7.F | 180.45 | 150 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
G1P8.AGT.1 | 15.51 | 7 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
G40Pa.R.CP | 89.29 | 63 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R44P7.1.1 | 8.88 | 6 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
G10P1 | 303245.18 | 263697 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R151P1(b) | 68.05 | 103 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
G4P1 | 37846.5 | 15540 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R106P1.2 | 1.29 | 1 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R106P2 | 1.31 | 1 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R106P7.3 | 81.37 | 77 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R116P1.1 | 0.21 | 0 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R116P2.3 | 112.93 | 105 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R116P3.3 | 112.48 | 105 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R116P3.4 | 112.8 | 106 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R116P4.3 | 126.97 | 127 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R116P7.2 | 127.13 | 127 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R11P2 | 21.67 | 14 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R11P5.375.2.RRJ | 114.05 | 89 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R11P5.375.3.RRJ | 119.01 | 98 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R11P5.600.2.RRJ | 188.62 | 162 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R11P5.750.2.RRJ | 294.94 | 349 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R11P7.MP.13 | 786.13 | 611 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R11P7.P.196 | 1493.06 | 2533 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R11P7.P.126 | 2520.05 | 2571 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R11P7.P.21 | 2043.67 | 2068 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R11P7.P.88 | 2421.7 | 2677 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R11P7.MP.3 | 1194.2 | 1748 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R132P3.1 | 88.12 | 60 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R132P4 | 64.17 | 40 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R132P7.F | 121.47 | 101 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R132P8.8 | 898.98 | 824 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R132P8.20 | 1808.9 | 1291 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R132P8.2 | 368.23 | 432 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R132P8.9 | 29898.88 | 34422 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R132P9 | 884.87 | 1456 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R141P8 | 22.53 | 10 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R141P3.L1 | 0.9 | 1 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R141P3.C1 | 1.01 | 1 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R141P3.E1 | 1.2 | 1 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)
R141P3.E3 | 1.21 | 1 | Syd - SH2 - Hume Hwy Roberts Rd ($13.8M)