+ Reply to Thread
Results 1 to 2 of 2

selecting divisible by a number

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    Nairobi, kenya
    MS-Off Ver
    windows7
    Posts
    1

    selecting divisible by a number

    Hallo I would wish to select and arrange all the heights (mm) that are divisible by 70 with their corresponding capacity (lts)
    Height Cap
    (MM) (Lts)
    0 70518
    70 125418
    140 189479
    210 253560
    280 317612
    340 372477
    410 436538
    480 500619
    540 555560
    610 619665
    611 620581
    612 621497
    613 622412
    614 623328
    615 624244
    616 625160
    617 626075
    618 626991
    619 627907
    620 628823
    621 629739
    622 630654
    623 631570
    624 632486
    625 633402
    626 634317
    627 635233
    628 636149
    629 637065
    630 637981
    631 638896
    632 639812
    633 640728
    634 641644
    635 642559
    636 643475
    637 644391
    638 645307
    639 646223
    640 647138
    641 648054
    642 648970
    643 649886
    644 650801
    645 651717
    646 652633
    647 653549
    648 654465
    649 655380
    650 656296
    651 657211
    652 658126
    653 659041
    654 659956
    655 660871
    656 661786
    657 662701
    658 663616
    659 664531
    660 665445
    661 666360
    662 667275
    663 668190
    664 669105
    665 670020
    666 670935
    667 671850
    668 672765
    669 673680
    670 674595
    671 675510
    672 676425
    673 677340
    674 678255
    675 679169
    676 680084
    677 680999
    678 681914
    679 682829
    680 683744
    681 684659
    682 685574
    683 686489
    684 687404
    685 688319
    686 689234
    687 690149
    688 691064
    689 691979
    690 692894
    691 693808
    692 694723
    693 695638
    694 696553
    695 697468
    696 698383
    697 699298
    698 700213
    699 701128
    700 702043
    701 702958
    702 703873
    703 704788
    704 705703
    705 706618
    706 707532
    707 708447
    708 709362
    709 710277
    710 711192
    711 712107
    712 713022
    713 713937
    714 714852
    715 715767
    716 716682
    717 717597
    718 718512
    719 719427
    720 720342
    721 721256
    722 722171
    723 723086
    724 724001
    725 724916
    726 725831
    727 726746
    728 727661
    729 728576
    730 729491
    731 730406
    732 731321
    733 732236
    734 733151
    735 734066
    736 734981
    737 735895
    738 736810
    739 737725
    740 738640
    741 739555
    742 740470
    743 741385
    744 742300
    745 743215
    746 744130
    747 745045
    748 745960
    749 746875
    750 747790
    751 748705
    752 749619
    753 750534
    754 751449
    755 752364

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: selecting divisible by a number

    in your example there are only 7 is that what you expect?
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. numbers divisible by 20%
    By sjc619 in forum Excel General
    Replies: 6
    Last Post: 11-17-2011, 02:35 PM
  2. Custom filter to select a value and values divisible by that number.
    By jad70 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-14-2009, 05:21 PM
  3. Showing if number is divisible...
    By njg2982 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-05-2007, 11:54 AM
  4. Help! Divisible by 75 Function?
    By japorms in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-22-2007, 04:06 PM
  5. [SOLVED] Rounding a Value to Make It Divisible by a Specified Number
    By John Nash in forum Tips and Tutorials
    Replies: 1
    Last Post: 08-29-2005, 10:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1