Spreadsheet: 772513d1647339304-conditional-selection-of-numbers-into-new-formula-example2
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
GROUP 2
GROUP 3
GROUP 4
GROUP 5
GROUP 6
GROUP 7
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.