Spreadsheet: 669845d1585627368-removing-duplicate-numbers-from-columns-remove-dup-postal-codes-in-radius
Sheet: Sheet1

50k Radius | [NAME] | [NAME] | 100 not 50 | 150 Not other |  | Add the 2 helper columns with formulas
2710 | 2710 | 2646 |  |  |  | Then sort by Col D Small to Large
2731 | 2713 | 2647 |  |  |  | If Count is 1 it is unique in that radius
3551 | 2714 | 2710 |  |  |  | Use all of 50k Radius below
3558 | 2731 | 2712 |  |  |  | Sort by Col D and only use D=1
3559 | 2732 | 2713 |  |  |  | Sort by Col E and only use E=1
3561 | 2735 | 2714
3562 | 3444 | 2716 |  |  |  | Answer after copy and paste after sorting
3563 | 3453 | 2731 |  |  |  | 50k Radius | [NAME] | [NAME]
3564 | 3515 | 2732 |  |  |  | 2710 | 2713 | 3581
3565 | 3516 | 2733 |  |  |  | 2731 | 2714 | 3583
3566 | 3517 | 2734 |  |  |  | 3551 | 2732 | 3584
3567 | 3518 | 2735 |  |  |  | 3558 | 2735 | 3585
3568 | 3520 | 3364 |  |  |  | 3559 | 3444 | 3586
3570 | 3523 | 3370 |  |  |  | 3561 | 3453 | 3588
3571 | 3525 | 3371 |  |  |  | 3562 | 3515 | 3589
3572 | 3537 | 3431 |  |  |  | 3563 | 3516 | 3658
3573 | 3550 | 3432 |  |  |  | 3564 | 3517 | 3659
3575 | 3551 | 3434 |  |  |  | 3565 | 3518 | 3670
3616 | 3555 | 3435 |  |  |  | 3566 | 3520 | 3672
3617 | 3556 | 3438 |  |  |  | 3567 | 3523 | 3673
3618 | 3557 | 3440 |  |  |  | 3568 | 3525 | 3675
3620 | 3558 | 3441 |  |  |  | 3570 | 3537 | 3677
3621 | 3559 | 3442 |  |  |  | 3571 | 3550 | 3678
3622 | 3561 | 3444 |  |  |  | 3572 | 3555 | 3682
3623 | 3562 | 3446 |  |  |  | 3573 | 3556 | 3685
3624 | 3563 | 3447 |  |  |  | 3575 | 3557 | 3714
3629 | 3564 | 3448 |  |  |  | 3616 | 3576 | 3715
3638 | 3565 | 3450 |  |  |  | 3617 | 3579 | 3717
3639 | 3566 | 3451 |  |  |  | 3618 | 3580 | 3718
 | 3567 | 3453 |  |  |  | 3620 | 3607 | 3719
 | 3568 | 3458 |  |  |  | 3621 | 3608 | 3720
 | 3570 | 3460 |  |  |  | 3622 | 3610 | 3723
 | 3571 | 3461 |  |  |  | 3623 | 3612 | 3726
 | 3572 | 3462 |  |  |  | 3624 | 3614 | 3756
 | 3573 | 3463 |  |  |  | 3629 | 3630 | 3758
 | 3575 | 3464 |  |  |  | 3638 | 3631 | 3764
 | 3576 | 3465 |  |  |  | 3639 | 3633 | 2647
 | 3579 | 3467 |  |  |  |  | 3634 | 2716
 | 3580 | 3472 |  |  |  |  | 3635 | 2733
 | 3607 | 3475 |  |  |  |  | 3636 | 2734
 | 3608 | 3478 |  |  |  |  | 3637 | 3364
 | 3610 | 3480 |  |  |  |  | 3640 | 3370
 | 3612 | 3515 |  |  |  |  | 3641 | 3371
 | 3614 | 3516 |  |  |  |  | 3644 | 3431
 | 3616 | 3517 |  |  |  |  | 3646 | 3432
 | 3617 | 3518 |  |  |  |  | 3649 | 3435
 | 3618 | 3520 |  |  |  |  | 3660 | 3438
 | 3620 | 3521 |  |  |  |  | 3663 | 3440
 | 3621 | 3522 |  |  |  |  | 3664 | 3465
 | 3622 | 3523 |  |  |  |  | 3665 | 3467
 | 3623 | 3525 |  |  |  |  | 3666 | 3472
 | 3624 | 3527 |  |  |  |  | 3669 | 3475
 | 3629 | 3529 |  |  |  |  | 3725 | 3478
 | 3630 | 3530 |  |  |  |  | 3727 | 3480
 | 3631 | 3537 |  |  |  |  | 3728 | 3530
 | 3633 | 3540 |  |  |  |  | 3730 | 3540
 | 3634 | 3542 |  |  |  |  |  | 3542
 | 3635 | 3544 |  |  |  |  |  | 3544
 | 3636 | 3550 |  |  |  |  |  | 2646
 | 3637 | 3551 |  |  |  |  |  | 2712
 | 3638 | 3555 |  |  |  |  |  | 3434
 | 3639 | 3556 |  |  |  |  |  | 3441
 | 3640 | 3557 |  |  |  |  |  | 3442
 | 3641 | 3558 |  |  |  |  |  | 3446
 | 3644 | 3559 |  |  |  |  |  | 3447
 | 3646 | 3561 |  |  |  |  |  | 3448
 | 3649 | 3562 |  |  |  |  |  | 3450
 | 3660 | 3563 |  |  |  |  |  | 3451
 | 3663 | 3564 |  |  |  |  |  | 3458
 | 3664 | 3565 |  |  |  |  |  | 3460
 | 3665 | 3566 |  |  |  |  |  | 3461
 | 3666 | 3567 |  |  |  |  |  | 3462
 | 3669 | 3568 |  |  |  |  |  | 3463
 | 3725 | 3570 |  |  |  |  |  | 3464
 | 3727 | 3571 |  |  |  |  |  | 3521
 | 3728 | 3572 |  |  |  |  |  | 3522
 | 3730 | 3573 |  |  |  |  |  | 3527
 |  | 3575 |  |  |  |  |  | 3529
 |  | 3576
 |  | 3579
 |  | 3580
 |  | 3581
 |  | 3583
 |  | 3584
 |  | 3585
 |  | 3586
 |  | 3588
 |  | 3589
 |  | 3607
 |  | 3608
 |  | 3610
 |  | 3612
 |  | 3614
 |  | 3616
 |  | 3617
 |  | 3618
 |  | 3620
 |  | 3621
 |  | 3622
 |  | 3623
 |  | 3624
 |  | 3629
 |  | 3630
 |  | 3631
 |  | 3633
 |  | 3634
 |  | 3635
 |  | 3636
 |  | 3637
 |  | 3638
 |  | 3639
 |  | 3640
 |  | 3641
 |  | 3644
 |  | 3646
 |  | 3649
 |  | 3658
 |  | 3659
 |  | 3660
 |  | 3663
 |  | 3664
 |  | 3665
 |  | 3666
 |  | 3669
 |  | 3670
 |  | 3672
 |  | 3673
 |  | 3675
 |  | 3677
 |  | 3678
 |  | 3682
 |  | 3685
 |  | 3714
 |  | 3715
 |  | 3717
 |  | 3718
 |  | 3719
 |  | 3720
 |  | 3723
 |  | 3725
 |  | 3726
 |  | 3727
 |  | 3728
 |  | 3730
 |  | 3756
 |  | 3758
 |  | 3764