First 3 section output after running Sub SpltTests() from last post ( http://www.excelfox.com/forum/showth...0881#post10881 , https://tinyurl.com/yd95w5v2 )
_____ Workbook: Sample.xlsm ( Using Excel 2007 32 bit )
Worksheet: Result
Row\Col A B C D E F G H 1 S1 S2 S1 S2 S1 S2 2 1 1377 41 1417 81 1457 3 2 1378 42 1418 82 1458 4 3 1379 43 1419 83 1459 5 4 1380 44 1420 84 1460 6 5 1381 45 1421 85 1461 7 6 1382 46 1422 86 1462 8 7 1383 47 1423 87 1463 9 8 1384 48 1424 88 1464 10 9 1385 49 1425 89 1465 11 10 1386 50 1426 90 1466 12 11 1387 51 1427 91 1467 13 12 1388 52 1428 92 1468 14 13 1389 53 1429 93 1469 15 14 1390 54 1430 94 1470 16 15 1391 55 1431 95 1471 17 16 1392 56 1432 96 1472 18 17 1393 57 1433 97 1473 19 18 1394 58 1434 98 1474 20 19 1395 59 1435 99 1475 21 20 1396 60 1436 100 1476 22 21 1397 61 1437 101 1477 23 22 1398 62 1438 102 1478 24 23 1399 63 1439 103 1479 25 24 1400 64 1440 104 1480 26 25 1401 65 1441 105 1481 27 26 1402 66 1442 106 1482 28 27 1403 67 1443 107 1483 29 28 1404 68 1444 108 1484 30 29 1405 69 1445 109 1485 31 30 1406 70 1446 110 1486 32 31 1407 71 1447 111 1487 33 32 1408 72 1448 112 1488 34 33 1409 73 1449 113 1489 35 34 1410 74 1450 114 1490 36 35 1411 75 1451 115 1491 37 36 1412 76 1452 116 1492 38 37 1413 77 1453 117 1493 39 38 1414 78 1454 118 1494 40 39 1415 79 1455 119 1495 41 40 1416 80 1456 120 1496 42 S1 S2 S1 S2 S1 S2 43 121 1497 161 1537 201 1577




Reply With Quote
Bookmarks