Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hi Could you please help?
I have the following situation
Column A Column B Column C M Project# R Project# M0001 R133 M0002 R0060 M0003 R0096 M0004 R0113 M0005 R0153 M0006 R0157 M0007 R0279 M0008 R0280 How do I build a formula on Column C where each time the digits match (A,B) to return the value existing on column B? Ex: Column A Column B Column C M0008 = R0008 repeat R0008 Thank you so much in advance for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hi Could you please help?
=IF(LOOKUP(99^99,--("0"&MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A2&"0 123456789")),ROW(INDIRECT("1:"&LEN(A2))))))
=LOOKUP(99^99,--("0"&MID(B2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},B2&"0 123456789")),ROW(INDIRECT("1:"&LEN(B2)))))),B2,"") -- __________________________________ HTH Bob "Cazumel" wrote in message ... I have the following situation Column A Column B Column C M Project# R Project# M0001 R133 M0002 R0060 M0003 R0096 M0004 R0113 M0005 R0153 M0006 R0157 M0007 R0279 M0008 R0280 How do I build a formula on Column C where each time the digits match (A,B) to return the value existing on column B? Ex: Column A Column B Column C M0008 = R0008 repeat R0008 Thank you so much in advance for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hi Could you please help?
Thank you for your help and prompt response, but it doenst work because the
numbers may not repeat itself in a much lower cell Instance: R0060 is on row number 1 M0060 is on row number 60: M0002 R0060 M0003 R0096 M0004 R0113 M0001 R133 M0005 R0153 M0006 R0157 M0007 R0279 M0008 R0280 M0009 R0349 M0010 R0359 M0011 R0400 M0012 R0500 M0013 R1225 M0014 R1226 M0015 R1228 M0016 R1229 M0017 R1230 M0018 R1231 M0019 R1232 M0020 R1233 M0021 R1234 M0022 R1235 M0023 R1236 M0024 R1238 M0025 R1239 M0026 R1240 M0027 R1241 M0028 R1242 M0029 R1243 M0030 R1244 M0031 R1245 M0032 R1246 M0033 R1247 M0034 R1248 M0035 R1249 M0036 R1250 M0037 R1251 M0038 R1252 M0039 R1253 M0040 R1254 M0041 R1255 M0042 R1256 M0043 R1257 M0044 R1258 M0045 R1259 M0046 R1260 M0047 R1261 M0048 R1262 M0049 R1263 M0050 R1264 M0051 R1265 M0052 R1266 M0053 R1267 M0054 R1268 M0056 R1269 M0057 R1270 M0058 R1271 M0059 R1272 M0060 R1273 "Cazumel" wrote: I have the following situation Column A Column B Column C M Project# R Project# M0001 R133 M0002 R0060 M0003 R0096 M0004 R0113 M0005 R0153 M0006 R0157 M0007 R0279 M0008 R0280 How do I build a formula on Column C where each time the digits match (A,B) to return the value existing on column B? Ex: Column A Column B Column C M0008 = R0008 repeat R0008 Thank you so much in advance for your help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hi Could you please help?
Try this:
=IF(MID(A2,2,99)=MID(B2,2,99),B2,"") copy down "Cazumel" wrote: I have the following situation Column A Column B Column C M Project# R Project# M0001 R133 M0002 R0060 M0003 R0096 M0004 R0113 M0005 R0153 M0006 R0157 M0007 R0279 M0008 R0280 How do I build a formula on Column C where each time the digits match (A,B) to return the value existing on column B? Ex: Column A Column B Column C M0008 = R0008 repeat R0008 Thank you so much in advance for your help. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hi Could you please help?
Here is the whole list :
M Project# R Project# M0002 R0060 M0003 R0096 M0004 R0113 M0001 R133 M0005 R0153 M0006 R0157 M0007 R0279 M0008 R0280 M0009 R0349 M0010 R0359 M0011 R0400 M0012 R0500 M0013 R1225 M0014 R1226 M0015 R1228 M0016 R1229 M0017 R1230 M0018 R1231 M0019 R1232 M0020 R1233 M0021 R1234 M0022 R1235 M0023 R1236 M0024 R1238 M0025 R1239 M0026 R1240 M0027 R1241 M0028 R1242 M0029 R1243 M0030 R1244 M0031 R1245 M0032 R1246 M0033 R1247 M0034 R1248 M0035 R1249 M0036 R1250 M0037 R1251 M0038 R1252 M0039 R1253 M0040 R1254 M0041 R1255 M0042 R1256 M0043 R1257 M0044 R1258 M0045 R1259 M0046 R1260 M0047 R1261 M0048 R1262 M0049 R1263 M0050 R1264 M0051 R1265 M0052 R1266 M0053 R1267 M0054 R1268 M0056 R1269 M0057 R1270 M0058 R1271 M0059 R1272 M0060 R1273 M0061 R1274 M0062 R1276 M0063 R1277 M0064 R1278 M0065 R1279 M0066 R1280 M0067 R1281 M0068 R1282 M0077 R1283 M0077 R1284 M0078 R1286 M0078 R1287 M0087 R1288 M0088 R1289 M0089 R1290 M0090 R1291 M0091 R1292 M0092 R1295 M0096 R1296 M0114 R1297 M0121 R1298 M0140 R1299 M0141 R1300 M0142 R1302 M0146 R1303 M0153 R1304 M0156 R1305 M0157 R1306 M0158 R1308 M0159 R1309 M1232 R1310 M1236 R1311 M1280 R1312 M1282 R1313 M1329 R1314 M1339 R1315 M1380 R1316 M1396 R1317 M1411 R1318 M1425 R1319 M1444 R1320 M1459 R1321 M1511 R1323 M1513 R1325 M1516 R1326 M1523 R1327 M1549 R1328 M1555 R1329 M1557 R1331 M1587 R1332 M1599 R1333 M1601 R1334 M1622 R1335 M1646 R1336 M1665 R1337 M1722 R1339 M1741 R1340 M1752 R1341 M1754 R1342 M1755 R1343 M1756 R1344 M2148 R1345 M2149 R1346 M2152 R1347 M2155 R1348 M2156 R1349 M2157 R1350 M2159 R1351 M2160 R1352 M2161 R1353 M2164 R1354 M2166 R1355 M2167 R1356 M2168 R1357 M2169 R1358 M2170 R1359 M2171 R1360 M2175 R1361 M2176 R1362 M2178 R1363 M2180 R1365 M2185 R1366 M2186 R1367 M2194 R1368 M2196 R1369 M2197 R1370 M2198 R1371 M2199 R1372 M2202 R1373 M2203 R1374 M2204 R1375 M2205 R1376 M2207 R1377 M2208 R1378 M2210 R1379 M2212 R1380 M2213 R1381 M2214 R1382 M2215 R1383 M2217 R1384 M2218 R1385 M2219 R1386 M2220 R1387 M2221 R1388 M2223 R1389 M2224 R1390 M2228 R1391 M2229 R1392 M2230 R1393 M2231 R1394 M2232 R1395 M2234 R1396 M2235 R1397 M2238 R1398 M2240 R1399 M2241 R1400 M2242 R1401 M2247 R1402 M2249 R1403 M2250 R1404 M2251 R1405 M2252 R1407 M2253 R1408 M2255 R1409 M2256 R1410 M2258 R1411 M2260 R1412 M2261 R1413 M2262 R1414 M2265 R1415 M2266 R1416 M2267 R1417 M2269 R1418 M2270 R1420 M2271 R1421 M2272 R1422 M2273 R1423 M2274 R1424 M2276 R1425 M2277 R1426 M2280 R1427 M2281 R1428 M2282 R1429 M2285 R1431 M2286 R1432 M2289 R1433 M2290 R1434 M2291 R1435 M2292 R1437 M2296 R1438 M2298 R1439 M2303 R1440 M2305 R1441 M2306 R1444 M2308 R1445 M2311 R1446 M2314 R1447 M2322 R1448 M2324 R1449 M2325 R1450 M2327 R1451 M2328 R1452 M2329 R1453 M2333 R1454 M2335 R1455 M2338 R1456 M2339 R1457 M2341 R1458 M2343 R1459 M2344 R1460 M2345 R1461 M2347 R1462 M2351 R1463 M2353 R1464 M2354 R1465 M2355 R1466 M2356 R1468 M2359 R1469 M2360 R1470 M2361 R1472 M2362 R1473 M2363 R1474 M2365 R1476 M2366 R1477 M2367 R1479 M2371 R1480 M2372 R1481 M2373 R1482 M2374 R1484 M2376 R1485 M2381 R1486 M2383 R1487 M2384 R1488 M2385 R1489 M2386 R1490 M2387 R1491 M2388 R1492 M2391 R1493 M2394 R1494 M2395 R1495 M2397 R1497 M2398 R1498 M2399 R1499 M2400 R1500 M2401 R1501 M2403 R1502 M2404 R1504 M2408 R1505 M2411 R1506 M2414 R1508 M2415 R1509 M2419 R1510 M2420 R1511 M2424 R1513 M2425 R1514 M2427 R1515 M2428 R1516 M2430 R1518 M2431 R1520 M2433 R1521 M2434 R1522 M2466 R1523 M2467 R1524 M2469 R1525 M2556 R1526 M2570 R1527 M2573 R1528 M2574 R1529 M2577 R1530 M2595 R1531 M2597 R1532 M2649 R1533 M2662 R1534 M2974 R1535 M3052 R1536 M3053 R1537 M3092 R1538 M3175 R1539 M3176 R1540 M3198 R1541 M3207 R1542 M3290 R1545 M3291 R1546 M3304 R1547 M3382 R1548 M3383 R1549 M3426 R1550 M3429 R1551 M3498 R1552 M3558 R1553 M3639 R1554 M3760 R1555 M3782 R1556 M3788 R1557 M5098 R1558 M5211 R1559 M5355 R1560 M5379 R1561 M5431 R1562 M5440 R1565 M5447 R1568 M5512 R1569 M5524 R1570 M5541 R1571 M5634 R1572 M5685 R1573 M5686 R1574 M5746 R1575 M5768 R1577 M5769 R1578 M5776 R1579 M5894 R1581 M6000 R1582 M6064 R1583 M6091 R1584 M6121 R1585 M6122 R1586 M6155 R1587 M6156 R1588 M6195 R1589 M6216 R1590 M6230 R1591 M6231 R1592 M6298 R1593 M6302 R1594 M6320 R1595 M6428 R1596 M6434 R1598 M6568 R1599 M6571 R1600 M6637 R1601 M6638 R1602 M6740 R1603 M6741 R1604 M6886 R1605 M6887 R1607 M6945 R1608 M7128 R1609 M7142 R1610 M7221 R1611 M7435 R1612 M7441 R1613 M7442 R1615 M7443 R1616 M7444 R1618 M7445 R1620 M7446 R1621 M7447 R1622 M7448 R1623 M7449 R1624 M7450 R1626 M7451 R1627 M7452 R1628 M7453 R1629 M7454 R1630 M7455 R1631 M7456 R1632 M7457 R1633 M7458 R1634 M7459 R1635 M7460 R1638 M7461 R1639 M7462 R1640 M7463 R1642 M7464 R1643 M7465 R1644 M7466 R1646 M7467 R1647 M7467 R1648 M7468 R1649 M7469 R1650 M7470 R1651 M7471 R1652 M7472 R1653 M7473 R1654 M7474 R1655 M7475 R1656 M7476 R1657 M7477 R1658 M7478 R1659 M7479 R1660 M7480 R1661 M7481 R1662 M7482 R1663 M7483 R1665 M7484 R1666 M7485 R1667 M7486 R1668 M7487 R1669 M7488 R1670 M7489 R1671 M7490 R1675 M7491 R1679 M7492 R1680 M7493 R1681 M7494 R1682 M7495 R1683 M7496 R1684 M7497 R1685 M7498 R1686 M7499 R1687 M7500 R1688 M7501 R1689 M7502 R1690 M7503 R1691 M7504 R1692 M7505 R1693 M7506 R1694 M7507 R1695 M7508 R1696 M7509 R1697 M7510 R1700 M7511 R1701 M7512 R1702 M7513 R1703 M7514 R1704 M7515 R1705 M7516 R1706 M7517 R1707 M7518 R1708 M7519 R1709 M7520 R1711 M7521 R1712 M7522 R1714 M7523 R1715 M7524 R1716 M7525 R1717 M7526 R1718 M7527 R1719 M7528 R1722 M7529 R1723 M7530 R1724 M7531 R1725 M7532 R1726 M7533 R1727 M7534 R1728 M7535 R1729 M7536 R1730 M7537 R1731 M7538 R1732 M7539 R1733 M7540 R1734 M7541 R1735 M7542 R1736 M7543 R1737 M7551 R1738 M7552 R1739 M7558 R1740 M7559 R1741 M7560 R1742 M7561 R1743 M7562 R1744 M7565 R1746 M7566 R1747 M7567 R1748 M7568 R1749 M7570 R1750 M7571 R1751 M7573 R1752 M7574 R1753 M7575 R1754 M7576 R1755 M7577 R1756 M7578 R1757 M7579 R2129 M7580 R2148 M7581 R2149 M7582 R2150 M7583 R2151 M7584 R2152 M7585 R2153 M7586 R2154 M7589 R2155 M7590 R2156 M7591 R2157 M7592 R2158 M7593 R2159 M7594 R2160 M7595 R2161 M7596 R2162 M7597 R2163 M7598 R2164 M7599 R2165 M7600 R2166 M7601 R2167 M7602 R2168 M7603 R2169 M7604 R2170 M7605 R2171 M7606 R2172 M7607 R2173 M7608 R2174 M7609 R2175 M7610 R2176 M7611 R2177 M7612 R2178 M7613 R2179 M7614 R2180 M7615 R2181 M7616 R2182 M7617 R2183 M7618 R2184 M7619 R2185 M7620 R2186 M7621 R2187 M7622 R2188 M7623 R2189 M7624 R2190 M7625 R2191 M7626 R2192 M7627 R2193 M7628 R2194 M7629 R2195 M7630 R2196 M7631 R2197 M7632 R2198 M7633 R2199 M7634 R2200 M7635 R2201 M7636 R2202 M7637 R2203 M7638 R2204 M7639 R2205 M7640 R2206 M7641 R2207 M7642 R2208 M7643 R2209 M7644 R2210 M7645 R2211 M7650 R2212 M7651 R2213 M7654 R2214 M7664 R2215 M7665 R2216 M7666 R2217 M7667 R2218 M7668 R2219 M7669 R2220 M7670 R2221 M7671 R2222 M7672 R2223 M7673 R2224 M7677 R2225 M7681 R2226 M7682 R2227 M7683 R2228 M7690 R2229 M7694 R2230 M7697 R2231 M7698 R2232 M7699 R2233 M7700 R2234 M7701 R2235 M7702 R2237 M7703 R2238 M7704 R2239 M7707 R2240 M7709 R2241 M7718 R2242 M7725 R2243 M7730 R2244 M7733 R2245 M7737 R2246 M7742 R2247 M7746 R2248 M7747 R2249 M7749 R2250 M7767 R2251 M7781 R2252 M7782 R2253 M7785 R2254 M7788 R2255 M7789 R2256 M7790 R2257 M7791 R2258 M7792 R2259 M7793 R2260 M7795 R2261 M7796 R2262 M7797 R2263 M7798 R2264 M7799 R2265 M7800 R2266 M7801 R2267 M7802 R2268 M7803 R2269 M7804 R2270 M7805 R2271 M7806 R2272 M7807 R2273 M7808 R2274 M7809 R2275 M7810 R2276 M7811 R2277 M7812 R2278 M7813 R2279 M7814 R2280 M7815 R2281 M7816 R2282 M7817 R2283 M7818 R2284 M7819 R2285 M7820 R2286 M7821 R2287 M7822 R2288 M7823 R2289 M7824 R2290 M7825 R2291 M7826 R2292 M7827 R2293 M7828 R2294 M7829 R2295 M7830 R2296 M7831 R2297 M7832 R2298 M7833 R2299 M7834 R2300 M7835 R2301 M7836 R2302 M7837 R2303 M7838 R2304 M7839 R2305 M7840 R2306 M7840 R2307 M7841 R2308 M7842 R2309 M7843 R2310 M7844 R2311 M7845 R2312 M7846 R2313 M7847 R2314 M7848 R2315 M7849 R2316 M7850 R2317 M7851 R2318 M7852 R2319 M7853 R2320 M7854 R2321 M7855 R2322 M7856 R2323 M7857 R2324 M7858 R2325 M7859 R2326 M7860 R2327 M7861 R2328 M7862 R2329 M7863 R2330 M7864 R2331 M7865 R2332 M7866 R2333 M7867 R2334 M7868 R2335 M7869 R2336 M7870 R2337 M7874 R2338 M7876 R2339 M7877 R2340 M7878 R2341 M7879 R2342 M7880 R2343 M7881 R2344 M7882 R2345 M7884 R2346 M7885 R2347 M7890 R2348 M7891 R2349 M7892 R2351 M7894 R2352 M7895 R2353 M7896 R2354 M7897 R2355 M7899 R2356 M7900 R2357 M7901 R2358 M7908 R2359 M7914 R2360 M7915 R2361 M7916 R2362 M7917 R2363 M7920 R2364 M7923 R2365 M7924 R2366 M7925 R2367 M7926 R2368 M7927 R2369 M7934 R2370 M7937 R2371 M7938 R2372 M7943 R2373 M7944 R2374 M7948 R2375 M7952 R2376 M7953 R2377 M7966 R2378 M7967 R2380 M7969 R2381 M7977 R2382 M7978 R2383 M7979 R2384 M7980 R2385 M7981 R2386 M7985 R2387 M7988 R2388 M7997 R2389 M7998 R2390 M8000 R2391 M8001 R2392 M8005 R2393 M8006 R2394 M8007 R2395 M8011 R2396 M8013 R2397 M8014 R2398 M8015 R2399 M8018 R2400 M8019 R2401 M8020 R2402 M8023 R2403 M8024 R2404 M8025 R2405 M8027 R2406 M8028 R2407 M8036 R2408 M8037 R2409 M8038 R2410 M8039 R2411 M8040 R2412 M8041 R2413 M8042 R2414 M8043 R2415 M8044 R2416 M8047 R2417 M8049 R2418 M8051 R2419 M8052 R2420 M8054 R2421 M8056 R2422 M8057 R2423 M8058 R2424 M8059 R2425 M8060 R2426 M8061 R2427 M8062 R2428 M8063 R2429 M8064 R2430 M8065 R2431 M8068 R2432 M8069 R2433 M8074 R2434 M8077 R2435 M8082 R2459 M8083 R2465 M8084 R2466 M8085 R2467 M8086 R2468 M8088 R2469 M8089 R2470 M8090 R2471 M8091 R2472 M8092 R2473 M8093 R2475 M8094 R2477 M8095 R2478 M8096 R2493 M8104 R2502 M8108 R2530 M8109 R2532 M8110 R2535 M8111 R2536 M8112 R2537 M8114 R2539 M8116 R2540 M8118 R2549 M8119 R2550 M8120 R2551 M8123 R2553 M8125 R2554 M8126 R2556 M8127 R2570 M8128 R2571 M8130 R2572 M8132 R2573 M8135 R2574 M8137 R2575 M8138 R2576 M8140 R2577 M8141 R2578 M8142 R2595 M8143 R2596 M8144 R2597 M8146 R2604 M8147 R2607 M8148 R2630 M8150 R2631 M8151 R2632 M8155 R2633 M8156 R2635 M8158 R2636 M8159 R2648 M8160 R2649 M8161 R2650 M8162 R2651 M8164 R2652 M8165 R2653 M8166 R2654 M8167 R2656 M8168 R2659 M8169 R2662 M8171 R2664 M8173 R2668 M8174 R2669 M8175 R2674 M8176 R2781 M8183 R2954 M8184 R2955 M8185 R2956 M8186 R2967 M8187 R2974 M8188 R2975 M8190 R2979 M8191 R2980 M8192 R2988 M8194 R2999 M8195 R3002 M8196 R3005 M8199 R3007 M8200 R3008 M8201 R3011 M8202 R3015 M8204 R3016 M8205 R3017 M8207 R3026 M8208 R3028 M8209 R3034 M8211 R3038 M8212 R3039 M8213 R3043 M8214 R3045 M8215 R3049 M8216 R3051 M8218 R3052 M8219 R3053 M8220 R3054 M8221 R3070 M8222 R3073 M8224 R3074 M8225 R3080 M8227 R3083 M8228 R3086 M8229 R3087 M8230 R3089 M8235 R3092 M8236 R3101 M8237 R3103 M8239 R3104 M8240 R3106 M8241 R3107 M8244 R3112 M8245 R3113 M8246 R3125 M8247 R3126 M8248 R3127 M8250 R3139 M8251 R3140 M8252 R3141 M8253 R3143 M8254 R3144 M8255 R3158 M8256 R3159 M8257 R3160 M8258 R3162 M8260 R3167 M8261 R3171 M8262 R3172 M8263 R3175 M8265 R3176 M8266 R3189 M8267 R3194 M8268 R3195 M8269 R3196 M8270 R3197 M8272 R3198 M8273 R3206 M8274 R3207 M8275 R3208 M8276 R3209 M8277 R3210 M8278 R3211 M8279 R3217 M8280 R3218 M8281 R3222 M8282 R3225 M8283 R3226 M8284 R3229 M8285 R3233 M8286 R3244 M8287 R3249 M8289 R3250 M8290 R3251 M8292 R3252 M8293 R3257 M8296 R3260 M8299 R3261 M8303 R3262 M8304 R3267 M8305 R3268 M8308 R3270 M8309 R3278 M8311 R3281 M8312 R3283 M8313 R3284 M8314 R3290 M8315 R3291 M8316 R3292 M8317 R3293 M8318 R3295 M8320 R3297 M8323 R3303 M8324 R3304 M8325 R3305 M8326 R3306 M8328 R3314 M8329 R3318 M8330 R3321 M8331 R3338 M8332 R3342 M8334 R3343 M8335 R3346 M8336 R3348 M8337 R3349 M8340 R3353 M8341 R3356 M8342 R3357 M8343 R3358 M8344 R3362 M8345 R3364 M8346 R3365 M8347 R3369 M8348 R3379 M8349 R3380 M8350 R3381 M8351 R3382 M8354 R3383 M8357 R3387 M8360 R3388 M8361 R3389 M8362 R3400 M8363 R3409 M8364 R3415 M8365 R3416 M8366 R3417 M8367 R3418 M8368 R3419 M8369 R3424 M8371 R3426 M8372 R3429 M8373 R3434 M8374 R3437 M8376 R3440 M8377 R3442 M8378 R3443 M8379 R3444 M8381 R3448 M8382 R3452 M8383 R3456 M8384 R3457 M8385 R3458 M8387 R3461 M8388 R3465 M8389 R3466 M8390 R3471 M8392 R3473 M8393 R3474 M8394 R3475 M8395 R3486 M8396 R3489 M8397 R3490 M8398 R3492 M8399 R3498 M8400 R3518 M8401 R3528 M8402 R3530 M8403 R3531 M8404 R3532 M8405 R3537 M8406 R3538 M8407 R3549 M8408 R3553 M8409 R3554 M8410 R3555 M8411 R3556 M8412 R3557 M8414 R3558 M8416 R3560 M8418 R3563 M8419 R3564 M8420 R3566 M8421 R3570 M8422 R3571 M8423 R3572 M8424 R3573 M8425 R3574 M8426 R3575 M8427 R3576 M8428 R3577 M8429 R3578 M8430 R3579 M8431 R3582 M8433 R3583 M8434 R3584 M8435 R3596 M8436 R3597 M8437 R3598 M8438 R3606 M8439 R3607 M8440 R3608 M8441 R3610 M8442 R3611 M8445 R3619 M8446 R3621 M8447 R3633 M8448 R3639 M8450 R3644 M8454 R3646 M8455 R3672 M8456 R3673 M8457 R3676 M8458 R3679 M8459 R3692 M8460 R3696 M8462 R3701 M8463 R3709 M8464 R3724 M8465 R3725 M8466 R3726 M8467 R3727 M8468 R3733 M8469 R3754 M8470 R3755 M8471 R3760 M8472 R3762 M8473 R3763 M8474 R3764 M8475 R3767 M8476 R3773 M8477 R3774 M8478 R3775 M8479 R3776 M8480 R3777 M8481 R3782 M8483 R3783 M8484 R3784 M8485 R3785 M8486 R3786 M8487 R3787 M8489 R3788 M8490 R3807 M8491 R3808 M8492 R3820 M8493 R3824 M8496 R3837 M8497 R3839 M8498 R3840 M8499 R4001 M8500 R4004 M8502 R4006 M8504 R4013 M8505 R5002 M8506 R5003 M8507 R5010 M8508 R5015 M8509 R5016 M8510 R5017 M8512 R5020 M8513 R5021 M8515 R5033 M8516 R5034 M8517 R5035 M8518 R5037 M8519 R5066 M8520 R5080 M8521 R5081 M8522 R5088 M8523 R5092 M8525 R5097 M8526 R5098 M8527 R5103 M8528 R5118 M8529 R5131 M8530 R5132 M8531 R5133 M8532 R5154 M8534 R5155 M8535 R5156 M8537 R5157 M8538 R5169 M8539 R5199 M8540 R5202 M8541 R5204 M8543 R5207 M8544 R5209 M8545 R5211 M8546 R5214 M8547 R5220 M8548 R5221 M8549 R5232 M8550 R5241 M8551 R5243 M8552 R5247 M8553 R5252 M8554 R5253 M8555 R5254 M8556 R5257 M8557 R5260 M8558 R5262 M8560 R5263 M8561 R5279 M8562 R5280 M8563 R5286 M8564 R5291 M8565 R5306 M8566 R5355 M8567 R5359 M8568 R5360 M8569 R5367 M8570 R5368 M8571 R5379 M8572 R5396 M8573 R5400 M8574 R5401 M8575 R5402 M8576 R5403 M8577 R5404 M8578 R5406 M8579 R5419 M8580 R5423 M8581 R5427 M8582 R5429 M8583 R5430 M8584 R5431 M8585 R5440 M8586 R5447 M8587 R5457 M8588 R5471 M8589 R5472 M8591 R5481 M8592 R5494 M8593 R5496 M8594 R5497 M8597 R5501 M8601 R5502 M8602 R5512 M8603 R5517 M8604 R5524 M8605 R5525 M8606 R5526 M8607 R5528 M8608 R5529 M8609 R5535 M8611 R5539 M8614 R5540 M8615 R5541 M8626 R5542 M8627 R5545 M8627 R5548 M8628 R5550 M8629 R5555 M8635 R5557 M8636 R5561 M8637 R5570 M8638 R5579 M8639 R5581 M8645 R5584 M8646 R5607 M8647 R5619 M8648 R5620 M8649 R5621 M8660 R5622 M8661 R5632 M8662 R5633 M8663 R5634 M8665 R5644 M8666 R5655 M8667 R5663 M8668 R5665 M8669 R5685 M8670 R5686 M8673 R5698 M8674 R5722 M8681 R5737 M8682 R5746 M8683 R5747 M8684 R5749 M8685 R5752 M8686 R5764 M8691 R5768 M8692 R5769 M8693 R5773 M8694 R5774 M8697 R5775 M8698 R5776 M8699 R5777 M8700 R5787 M8705 R5799 M8706 R5802 M8707 R5815 M8708 R5818 M8709 R5819 M8710 R5843 M8711 R5851 M8713 R5852 M8714 R5865 M8715 R5889 M8719 R5894 M8720 R5900 M8721 R5909 M8722 R5911 M8723 R5913 M8724 R5918 M8729 R5919 M8730 R5920 M8734 R5925 M8735 R5930 M8736 R5935 M8738 R5959 M9000 R5961 M9001 R5966 M9002 R5971 M9004 R5972 M9005 R5976 M9006 R5983 M9008 R6000 M9009 R6001 M9010 R6009 M9011 R6011 M9012 R6012 M9013 R6013 M9015 R6034 M9016 R6037 M9018 R6040 M9019 R6041 M9021 R6045 M9023 R6049 M9024 R6050 M9025 R6052 M9026 R6053 M9027 R6064 M9028 R6067 M9029 R6085 M9030 R6088 M9031 R6091 M9032 R6102 M9033 R6109 M9035 R6120 M9036 R6121 M9037 R6122 M9038 R6129 M9039 R6138 M9040 R6146 M9041 R6147 M9042 R6155 M9043 R6156 M9044 R6158 M9045 R6160 M9046 R6161 M9047 R6166 M9048 R6167 M9049 R6172 M9050 R6177 M9051 R6178 M9053 R6195 M9054 R6196 M9055 R6213 M9056 R6214 M9057 R6215 M9058 R6216 M9060 R6229 M9061 R6230 M9062 R6231 M9063 R6238 M9064 R6243 M9065 R6289 M9066 R6293 M9067 R6294 M9068 R6295 M9069 R6298 M9070 R6302 M9071 R6308 M9072 R6312 M9073 R6319 M9074 R6320 M9075 R6322 M9076 R6344 M9078 R6347 M9079 R6352 M9080 R6353 M9081 R6360 M9082 R6363 M9083 R6365 M9084 R6366 M9086 R6388 M9087 R6394 M9088 R6397 M9089 R6398 M9090 R6421 M9091 R6428 M9092 R6429 M9093 R6432 M9094 R6441 M9099 R6442 M9100 R6463 M9101 R6470 M9102 R6484 N5358 R6485 N5374 R6486 N5392 R6491 N5505 R6498 N5569 R6499 N5570 R6501 N5571 R6505 N5572 R6507 N5573 R6512 N5574 R6513 N5575 R6523 N5576 R6539 N5577 R6540 N5578 R6544 N5803 R6557 N5994 R6564 N5999 R6566 N6000 R6568 N6009 R6569 R1231 R6571 R1254 R6572 R1353 R6585 R1705 R6596 R2129 R6617 R2153 R6621 R2154 R6627 R2158 R6631 R2159 R6632 R2160 R6633 R2162 R6634 R2163 R6636 R2165 R6637 R2169 R6638 R2172 R6647 R2173 R6653 R2174 R6677 R2177 R6701 R2179 R6707 R2181 R6709 R2182 R6730 R2184 R6734 R2188 R6740 R2189 R6741 R2190 R6745 R2191 R6748 R2192 R6759 R2193 R6762 R2195 R6764 R2200 R6773 R2201 R6782 R2206 R6786 R2209 R6787 R2211 R6790 R2216 R6820 R2222 R6828 R2225 R6839 R2226 R6840 R2227 R6841 R2233 R6843 R2237 R6857 R2238 R6870 R2239 R6872 R2243 R6874 R2244 R6875 R2245 R6885 R2246 R6886 R2248 R6887 R2254 R6902 R2257 R6908 R2259 R6920 R2263 R6932 R2264 R6943 R2268 R6945 R2275 R6952 R2278 R6956 R2279 R6957 R2283 R6966 R2284 R6967 R2285 R6993 R2287 R6996 R2288 R7038 R2293 R7060 R2294 R7065 R2295 R7078 R2297 R7082 R2299 R7086 R2300 R7088 R2301 R7091 R2302 R7095 R2304 R7099 R2307 R7112 R2309 R7123 R2310 R7128 R2312 R7130 R2313 R7131 R2315 R7132 R2316 R7135 R2317 R7139 R2318 R7141 R2319 R7142 R2320 R7162 R2321 R7193 R2323 R7215 R2326 R7216 R2328 R7219 R2330 R7221 R2331 R7222 R2332 R7223 R2334 R7228 R2336 R7229 R2337 R7243 R2340 R7244 R2342 R7246 R2346 R7249 R2348 R7262 R2349 R7268 R2352 R7270 R2357 R7280 R2358 R7281 R2364 R7284 R2368 R7285 R2369 R7286 R2370 R7287 R2375 R7288 R2377 R7289 R2378 R7290 R2380 R7292 R2382 R7307 R2389 R7308 R2390 R7314 R2392 R7316 R2393 R7322 R2396 R7324 R2402 R7334 R2406 R7336 R2407 R7337 R2409 R7355 R2410 R7358 R2412 R7383 R2413 R7387 R2417 R7391 R2418 R7394 R2421 R7407 R2422 R7438 R2435 R7443 R2502 R7451 R2570 R7455 R2571 R7456 R2572 R7472 R2575 R7482 R2576 R7513 R2578 R7519 R2596 R7529 R2979 R7537 R3005 R7545 R3211 R7548 R3646 R7549 R5581 R7592 R5787 R7698 R5909 R7772 R6102 R7774 R6147 R7780 R6158 R7781 R6160 R7785 R6161 R7788 R6178 R7789 R6213 R7795 R6214 R7797 R6215 R7813 R6238 R7814 R6298 R7817 R6441 R7818 R6470 R7819 R6491 R7837 R6631 R7841 R6632 R7842 R7060 R7851 R7082 R7854 R8002 R7855 R8003 R7859 R8008 R7861 R8009 R7863 R8010 R7870 R8012 R7874 R8016 R7876 R8017 R7881 R8021 R7884 R8022 R7886 R8026 R7888 R8029 R8000 R8030 R8001 R8034 R8002 R8035 R8003 R8045 R8005 R8046 R8006 R8048 R8007 R8050 R8008 R8055 R8009 R8059 R8010 R8066 R8011 R8067 R8012 R8073 R8013 R8075 R8014 R8076 R8015 R8078 R8016 R8079 R8017 R8087 R8018 R8097 R8019 R8098 R8020 R8100 R8021 R8101 R8022 R8102 R8023 R8103 R8024 R8105 R8025 R8106 R8026 R8107 R8027 R8113 R8028 R8115 R8029 R8117 R8030 R8122 R8031 R8124 R8032 R8129 R8033 R8131 R8034 R8133 R8035 R8134 R8036 R8136 R8037 R8139 R8038 R8149 R8039 R8153 R8040 R8157 R8041 R8160 R8042 R8163 R8043 R8170 R8044 R8172 R8045 R8177 R8046 R8178 R8047 R8179 R8048 R8181 R8049 R8182 R8050 R8189 R8051 R8192 R8052 R8193 R8053 R8194 R8054 R8197 R8055 R8198 R8056 R8199 R8057 R8201 R8058 R8202 R8059 R8203 R8060 R8204 R8061 R8205 R8062 R8206 R8063 R8208 R8064 R8209 R8065 R8210 R8066 R8211 R8067 R8212 R8068 R8213 R8069 R8215 R8070 R8216 R8073 R8217 R8074 R8218 R8075 R8219 R8076 R8220 R8077 R8221 R8078 R8222 R8079 R8223 R8080 R8224 R8081 R8226 R8082 R8227 R8083 R8229 R8084 R8230 R8085 R8235 R8086 R8236 R8087 R8237 R8088 R8238 R8089 R8239 R8090 R8240 R8091 R8241 R8092 R8242 R8093 R8243 R8094 R8244 R8095 R8245 R8096 R8246 R8097 R8247 R8098 R8248 R8099 R8264 R8100 R8271 R8101 R8288 R8102 R8294 R8103 R8295 R8104 R8298 R8105 R8300 R8106 R8302 R8107 R8306 R8108 R8307 R8109 R8310 R8110 R8319 R8111 R8321 R8112 R8322 R8113 R8327 R8114 R8333 R8115 R8341 R8116 R8352 R8117 R8353 R8118 R8355 R8119 R8356 R8120 R8358 R8121 R8370 R8122 R8375 R8123 R8380 R8124 R8382 R8125 R8386 R8126 R8391 R8127 R8413 R8128 R8415 R8129 R8417 R8130 R8428 R8131 R8429 R8132 R8431 R8133 R8432 R8134 R8439 R8135 R8443 R8136 R8444 R8137 R8452 R8138 R8453 R8139 R8461 R8140 R8472 R8141 R8475 R8142 R8488 R8143 R8494 R8144 R8495 R8145 R8501 R8146 R8503 R8147 R8505 R8148 R8506 R8149 R8511 R8150 R8514 R8151 R8527 R8152 R8536 R8153 R8542 R8154 R8554 R8155 R8570 R8156 R8586 R8157 R9003 R8158 R9007 R8159 R9014 R8160 R9017 R8161 R9018 R8162 R9020 R8163 R9022 R8164 R9033 R8165 R9034 R8166 R9039 R8167 R9046 R8168 R9051 R8169 R9053 R8170 R9054 R8171 R9056 R8172 R9059 R8173 R9062 R8174 R9063 R8175 R9077 R8176 R9079 R8177 R9080 R8178 R9085 R8179 WSQPJ R8181 R8182 R8183 R8184 R8185 R8186 R8187 R8188 R8189 R8190 R8191 R8192 R8193 R8194 R8195 R8196 R8197 R8198 R8199 R8200 R8201 R8202 R8203 R8204 R8205 R8206 R8207 R8208 R8209 R8210 R8211 R8212 R8213 R8214 R8215 R8216 R8217 R8218 R8219 R8220 R8221 R8222 R8223 R8224 R8225 R8226 R8227 R8228 R8229 R8230 R8232 R8233 R8235 R8236 R8237 R8238 R8239 R8240 R8241 R8242 R8243 R8244 R8245 R8246 R8247 R8248 R8250 R8251 R8252 R8253 R8254 R8255 R8256 R8257 R8258 R8260 R8261 R8262 R8263 R8264 R8265 R8266 R8267 R8268 R8269 R8270 R8271 R8272 R8273 R8274 R8275 R8276 R8277 R8278 R8279 R8280 R8281 R8282 R8283 R8284 R8285 R8286 R8287 R8288 R8289 R8290 R8292 R8293 R8294 R8295 R8296 R8298 R8299 R8300 R8302 R8303 R8304 R8305 R8306 R8307 R8308 R8309 R8310 R8311 R8312 R8313 R8314 R8315 R8316 R8317 R8318 R8319 R8320 R8321 R8322 R8323 R8324 R8325 R8326 R8327 R8328 R8329 R8330 R8331 R8332 R8333 R8334 R8335 R8336 R8337 R8338 R8339 R8340 R8341 R8342 R8343 R8344 R8345 R8346 R8347 R8348 R8349 R8350 R8351 R8352 R8353 R8354 R8355 R8356 R8357 R8358 R8359 R8360 R8361 R8362 R8363 R8364 R8365 R8366 R8367 R8368 R8369 R8370 R8371 R8372 R8373 R8374 R8375 R8376 R8377 R8378 R8379 R8380 R8381 R8382 R8383 R8384 R8385 R8386 R8387 R8388 R8389 R8390 R8391 R8392 R8393 R8394 R8395 R8396 R8397 R8398 R8399 R8400 R8401 R8402 R8403 R8404 R8405 R8406 R8407 R8408 R8409 R8410 R8411 R8412 R8413 R8414 R8415 R8416 R8417 R8418 R8419 R8420 R8421 R8422 R8423 R8424 R8425 R8426 R8427 R8428 R8429 R8430 R8431 R8432 R8433 R8434 R8435 R8436 R8437 R8438 R8439 R8440 R8441 R8442 R8443 R8444 R8445 R8446 R8447 R8448 R8449 R8450 R8451 R8452 R8453 R8454 R8455 R8456 R8457 R8458 R8459 R8460 R8461 R8462 R8463 R8464 R8465 R8466 R8467 R8468 R8469 R8470 R8471 R8472 R8473 R8474 R8475 R8476 R8477 R8478 R8479 R8480 R8481 R8482 R8483 R8484 R8485 R8486 R8487 R8488 R8489 R8490 R8491 R8492 R8493 R8494 R8495 R8496 R8497 R8498 R8499 R8500 R8501 R8502 R8503 R8504 R8505 R8506 R8507 R8508 R8509 R8510 R8511 R8512 R8513 R8514 R8515 R8516 R8517 R8518 R8519 R8520 R8521 R8522 R8523 R8524 R8525 R8526 R8527 R8528 R8529 R8530 R8531 R8532 R8533 R8534 R8535 R8536 R8537 R8538 R8539 R8540 R8541 R8542 R8543 R8544 R8545 R8546 R8547 R8548 R8549 R8550 R8551 R8552 R8553 R8554 R8555 R8556 R8557 R8558 R8559 R8560 R8561 R8562 R8563 R8564 R8565 R8566 R8567 R8568 R8569 R8570 R8571 R8572 R8573 R8574 R8575 R8576 R8577 R8578 R8579 R8580 R8581 R8582 R8583 R8584 R8585 R8586 R8587 R8588 R8589 R9000 R9001 R9002 R9003 R9004 R9005 R9006 R9007 R9008 R9009 R9010 R9011 R9012 R9013 R9014 R9015 R9016 R9017 R9018 R9019 R9020 R9021 R9022 R9023 R9024 R9025 R9026 R9027 R9028 R9029 R9030 R9031 R9032 R9033 R9034 R9035 R9036 R9037 R9038 R9039 R9040 R9041 R9042 R9043 R9044 R9045 R9046 R9047 R9048 R9049 R9050 R9051 R9053 R9054 R9055 R9056 R9057 R9058 R9059 R9060 R9061 R9062 R9063 R9064 R9065 R9066 R9067 R9068 R9069 R9070 R9071 R9072 R9073 R9074 R9075 R9076 R9077 R9078 R9079 R9080 R9081 R9082 R9083 R9084 R9085 R9086 R9087 R9088 R9089 R9090 R9091 R9092 R9093 R9094 R9095 R9096 R9106 R9108 R9114 R9121 R9125 R9131 R9134 R9138 R9139 R9140 R9145 R9146 R9147 R9901 R9999 How could I look up colum A on Column B and return the repeated digits Thank you "Cazumel" wrote: I have the following situation Column A Column B Column C M Project# R Project# M0001 R133 M0002 R0060 M0003 R0096 M0004 R0113 M0005 R0153 M0006 R0157 M0007 R0279 M0008 R0280 How do I build a formula on Column C where each time the digits match (A,B) to return the value existing on column B? Ex: Column A Column B Column C M0008 = R0008 repeat R0008 Thank you so much in advance for your help. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hi Could you please help?
=IF(SUMPRODUCT(--(MID($A$1:$A$59,2,99)=MID(B1,2,99))),B1,"")
"Cazumel" wrote: Thank you for your help and prompt response, but it doenst work because the numbers may not repeat itself in a much lower cell Instance: R0060 is on row number 1 M0060 is on row number 60: M0002 R0060 M0003 R0096 M0004 R0113 M0001 R133 M0005 R0153 M0006 R0157 M0007 R0279 M0008 R0280 M0009 R0349 M0010 R0359 M0011 R0400 M0012 R0500 M0013 R1225 M0014 R1226 M0015 R1228 M0016 R1229 M0017 R1230 M0018 R1231 M0019 R1232 M0020 R1233 M0021 R1234 M0022 R1235 M0023 R1236 M0024 R1238 M0025 R1239 M0026 R1240 M0027 R1241 M0028 R1242 M0029 R1243 M0030 R1244 M0031 R1245 M0032 R1246 M0033 R1247 M0034 R1248 M0035 R1249 M0036 R1250 M0037 R1251 M0038 R1252 M0039 R1253 M0040 R1254 M0041 R1255 M0042 R1256 M0043 R1257 M0044 R1258 M0045 R1259 M0046 R1260 M0047 R1261 M0048 R1262 M0049 R1263 M0050 R1264 M0051 R1265 M0052 R1266 M0053 R1267 M0054 R1268 M0056 R1269 M0057 R1270 M0058 R1271 M0059 R1272 M0060 R1273 "Cazumel" wrote: I have the following situation Column A Column B Column C M Project# R Project# M0001 R133 M0002 R0060 M0003 R0096 M0004 R0113 M0005 R0153 M0006 R0157 M0007 R0279 M0008 R0280 How do I build a formula on Column C where each time the digits match (A,B) to return the value existing on column B? Ex: Column A Column B Column C M0008 = R0008 repeat R0008 Thank you so much in advance for your help. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hi Could you please help?
Beautiful, you are all the best, thank you so much
"Cazumel" wrote: I have the following situation Column A Column B Column C M Project# R Project# M0001 R133 M0002 R0060 M0003 R0096 M0004 R0113 M0005 R0153 M0006 R0157 M0007 R0279 M0008 R0280 How do I build a formula on Column C where each time the digits match (A,B) to return the value existing on column B? Ex: Column A Column B Column C M0008 = R0008 repeat R0008 Thank you so much in advance for your help. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hi Could you please help?
You're Welcome!
"Cazumel" wrote: Beautiful, you are all the best, thank you so much "Cazumel" wrote: I have the following situation Column A Column B Column C M Project# R Project# M0001 R133 M0002 R0060 M0003 R0096 M0004 R0113 M0005 R0153 M0006 R0157 M0007 R0279 M0008 R0280 How do I build a formula on Column C where each time the digits match (A,B) to return the value existing on column B? Ex: Column A Column B Column C M0008 = R0008 repeat R0008 Thank you so much in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|