Spreadsheet: 772525d1647342510-conditional-selection-of-numbers-into-new-formula-warren-cse-example-aligw
Sheet: Sheet1

UNITY | group 1 | 18.95292 | 14.28714 | 18.48924 | 20.568555 | 25.7922 | 27.18324 | 29.58858 | 23.53175999999999 | 27.20497499999999 | 30.566655 | 41.61527999999999 | 44.03511 | 47.09249999999999 | 31.16799 | 35.09477999999999 | 44.83206 | 49.693455 | 53.58402 | 41.02843499999999 | 43.54969499999999 | 36.88429499999999 | 48.22996499999999 | 18.308115 | 39.70984499999999 | 43.75979999999999 | 50.54836499999999 | 57.36591 | 52.62043499999999 | 52.62043499999999 | 60.75656999999999 | 68.93617499999999 | 74.25400499999999 | 59.93063999999999 | 79.934085 | 90.88127999999999 | 139.589415 | 0 | 0 | 0 | 0.3 | 1502.59851 | 47.24061999999999 | GROUP 4 |  | UNITY
PORTER DV,DG,GR,HB,PN,SG,WH | GROUP 2 | 7.175 | 5.656 | 6.86 | 7.601999999999999 | 9.5375 | 10.479 | 11.48 | 8.830499999999999 | 10.948 | 12.698 | 16.4325 | 18.1965 | 20.097 | 13.09 | 15.2915 | 19.873 | 22.085 | 24.4055 | 18.739 | 20.1425 | 16.1805 | 23.058 | 9.177 | 15.645 | 19.922 | 24.1955 | 28.504 | 18.9595 | 24.3005 | 29.666 | 35.0315 | 38.248 | 25.7915 | 40.663 | 48.132 | 53.4135 | 0 | 77.30799999999999 | 89.29899999999999 | 0.65 | 677.0925 | 22.06963888888889 | GROUP 2 |  | PORTER DV,DG,GR,HB,PN,SG,WH
PORTER OUTLINE | GROUP 4 | 22.5707625 | 17.7673275 | 24.340095 | 24.340095 | 29.452995 | 32.0296275 | 34.565895 | 26.9570925 | 24.89175 | 28.403505 | 35.4202875 | 38.9185875 | 42.4168875 | 28.8273375 | 32.9849325 | 41.33376 | 45.5249925 | 49.6825875 | 38.9858625 | 41.52213 | 34.55916749999999 | 46.5543 | 29.2848075 | 35.01663749999999 | 41.28666749999999 | 48.6330975 | 55.932435 | 41.6903175 | 49.66240499999999 | 58.67052749999999 | 66.60225 | 73.1884725 | 54.7013025 | 78.1937325 | 90.44451 | 105.3997425 | 0 | 0 | 0 | 0.35 | 1465.35714 | 45.984705 | GROUP 4 |  | PORTER OUTLINE
REMO RH,RV,RU,RG,RMB,RN,RS,RW | GROUP 3 | 8.435 | 9.1945 | 10.4825 | 11.452 | 15.0885 | 16.0965 | 17.0905 | 12.8555 | 17.2585 | 19.2045 | 23.1315 | 25.0775 | 27.048 | 19.733 | 22.1655 | 27.027 | 29.4665 | 31.892 | 26.061 | 27.853 | 22.1655 | 29.5015 | 15.267 | 22.505 | 26.005 | 29.981 | 36.939 | 26.3235 | 32.319 | 35.315 | 42.2065 | 47.8135 | 33.7505 | 47.971 | 57.617 | 0 | 0 | 0 | 0 | 0.65 | 902.2929999999998 | 28.42466666666667 | GROUP 3 |  | REMO RH,RV,RU,RG,RMB,RN,RS,RW
STANHOPE 1 | GROUP 3 | 21.626325 | 21.771225 | 20.988765 | 22.669605 | 26.44425 | 28.117845 | 29.871135 | 24.249015 | 23.756355 | 25.95159 | 31.83452999999999 | 34.18190999999999 | 36.565515 | 26.393535 | 29.55959999999999 | 35.754075 | 38.63758499999999 | 41.45589 | 33.96456 | 35.5005 | 30.131955 | 38.34054 | 31.92871499999999 | 29.95083 | 34.276095 | 39.26065499999999 | 44.13654 | 35.71784999999999 | 41.80365 | 47.19392999999999 | 53.44636499999999 | 57.11233499999999 | 44.00612999999999 | 60.20594999999999 | 68.49423 | 84.78098999999999 | 0 | 0 | 0 | 0.3 | 1245.29958 | 37.935625 | GROUP 3 |  | STANHOPE 1
STANHOPE 2 | GROUP 4 | 18.95292 | 14.28714 | 18.48924 | 20.568555 | 25.7922 | 27.175995 | 29.58858 | 23.53175999999999 | 27.20497499999999 | 30.566655 | 41.61527999999999 | 44.03511 | 47.09249999999999 | 31.16799 | 35.09477999999999 | 44.83206 | 49.693455 | 53.58402 | 41.02843499999999 | 43.54969499999999 | 36.88429499999999 | 48.22996499999999 | 18.308115 | 39.70984499999999 | 43.75979999999999 | 50.54836499999999 | 57.36591 | 52.62043499999999 | 52.62043499999999 | 60.75656999999999 | 68.93617499999999 | 74.25400499999999 | 59.93063999999999 | 79.934085 | 90.88127999999999 | 139.589415 | 0 | 0 | 0 | 0.3 | 1502.591265 | 47.24061999999999 | GROUP 4 |  | STANHOPE 2
UNITY | GROUP 4 | 22 | 14.28714 | 18.48924 | 20.568555 | 25.7922 | 27.18324 | 29.58858 | 23.53175999999999 | 27.20497499999999 | 30.566655 | 41.61527999999999 | 44.03511 | 47.09249999999999 | 31.16799 | 35.09477999999999 | 44.83206 | 49.693455 | 53.58402 | 41.02843499999999 | 43.54969499999999 | 36.88429499999999 | 48.22996499999999 | 18.308115 | 39.70984499999999 | 43.75979999999999 | 50.54836499999999 | 57.36591 | 52.62043499999999 | 52.62043499999999 | 60.75656999999999 | 68.93617499999999 | 74.25400499999999 | 59.93063999999999 | 79.934085 | 90.88127999999999 | 139.589415 | 0 | 0 | 0 | 0.3 | 1502.59851 | 47.24061999999999 | GROUP 4 |  | UNITY
 | group 1 | 8.435 | 9.1945 | 10.4825 | 11.452 | 15.0885 | 16.0965 | 17.0905 | 12.8555 | 17.2585 | 19.2045 | 23.1315 | 25.0775 | 27.048 | 19.733 | 22.1655 | 27.027 | 29.4665 | 31.892 | 26.061 | 27.853 | 22.1655 | 29.5015 | 15.267 | 22.505 | 26.005 | 29.981 | 36.939 | 26.3235 | 32.319 | 35.315 | 42.2065 | 47.8135 | 33.7505 | 47.971 | 57.617 | 0
GROUP 1 |  |  |  |  |  |  |  | 52.3855 | 38.5135 | 43.6475 | 51.8585 | 68.2975 | 76.55949999999999 | 84.745 | 49.5805 | 63.6565 | 83.8355 | 93.9675 | 104.0315 | 79.2455 | 85.765 | 67.507 | 98.821 | 35.122 | 64.277 | 83.7335 | 103.1815 | 122.604 | 79.7215 | 103.853 | 127.9845 | 152.082 | 165.6735 | 109.7605 | 176.222 | 209.3635 | 171.615 | 0 | 275.5615 | 327.403
GROUP 2 |  |  |  |  |  |  |  | 78.574 | 57.7745 | 65.4755 | 77.7835 | 102.442 | 114.8095 | 127.126 | 80.35900000000001 | 95.472 | 125.7405 | 140.947 | 156.026 | 118.8555 | 128.639 | 101.2435 | 148.2315 | 52.67449999999999 | 96.407 | 125.5875 | 154.768 | 183.9145 | 119.578 | 155.771 | 191.9725 | 228.1145 | 248.4975 | 164.6365 | 264.3245 | 314.075 | 257.4055 | 0 | 413.321 | 491.096
GROUP 3 |  |  |  |  |  |  |  | 34.565895 | 26.9570925 | 26.80425 | 29.41675 | 35.644 | 39.102 | 42.4168875 | 29.3645 | 32.9849325 | 41.33376 | 45.5249925 | 49.6825875 | 38.9858625 | 41.52213 | 34.55916749999999 | 46.5543 | 29.2848075 | 35.01663749999999 | 41.28666749999999 | 48.6330975 | 55.932435 | 41.6903175 | 49.66240499999999 | 58.67052749999999 | 66.60225 | 73.1884725 | 54.7013025 | 78.1937325 | 90.44451 | 105.3997425 | 0 | 78.934275 | 166.87225
GROUP 4 |  |  |  |  |  |  |  | 29.871135 | 24.249015 | 27.20497499999999 | 30.566655 | 41.61527999999999 | 44.03511 | 47.09249999999999 | 31.16799 | 35.09477999999999 | 44.83206 | 49.693455 | 53.58402 | 41.02843499999999 | 43.54969499999999 | 36.88429499999999 | 48.22996499999999 | 31.92871499999999 | 39.70984499999999 | 43.75979999999999 | 50.54836499999999 | 57.36591 | 52.62043499999999 | 52.62043499999999 | 60.75656999999999 | 68.93617499999999 | 74.25400499999999 | 59.93063999999999 | 79.934085 | 90.88127999999999 | 139.589415 | 0 | 0 | 0
GROUP 5 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GROUP 6 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GROUP 7 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GROUP 8
 | SIZES | 115 X 595 | 140x297 | 140 x 495 | 140 X 595 | 140x797 | 140x897 | 140x997 | 175 x 597 | 283x497 | 283 x 595 | 283 x 797 | 283 x 897 | 283 x 997 | 355 X 495 | 355 x 597 | 355 x 797 | 355 x 897 | 355 x 997 | 450 x 597 | 490x597 | 570 x 395 | 570 X 595 | 715X147 | 715 x 295 | 715 X 395 | 715 X 495 | 715 x 595 | 895X297 | 895 x 395 | 895 x 495 | 895 X 595 | 980 x 597 | 1245 x 295 | 1245 X 495 | 1245 x 595 | 1965x297 | 1965 x 397 | 1965x497 | 1965x597
 |  | the [NAME] formula needs only to select the figures in the column IF they are in a group 1 row.
 |  | In the next row it would need only to select MAX of the figures IF the row says [NAME]
 |  | Note that Headings in C2:C9 could change depending on price increases from suppliers.