Excel is there a way to eliminate search numbers from a block

Reply #4

AllenB — Mon, 16 Mar 2020 21:50:00 GMT

I did a quick worksheet that I think does what you need. In My previous response, I did not produce the correct list because my formula was backwards. Instead of excluding the numbers from Search, I included them. Sorry it was backwards.

If you PM me with your email contact I will send you the file

Reply #3

TasBob — Mon, 16 Mar 2020 21:09:52 GMT

Tks AllenB

Was not able to get it working , maybe some else could give another idea. TKS

Reply #2

Todd — Mon, 16 Mar 2020 19:39:32 GMT

Reply #1

AllenB — Mon, 16 Mar 2020 18:12:20 GMT

You can use the countif function to isolate numbers.

I would name two Ranges for the addresses.

Call your long list of numbers something like List . Call your search number something like Search

Place this formula in the column or columns adjacent to each cell in List

Use the formula: If(countif(Search,[adjacent cell in list })=1,[adjacent cell], )

IF your List is in Cells A2 to A100 and Your Search was in Cells B1 to D1

You would place this formula in cells B2 to B100 and ge... [ More ]

Excel is there a way to eliminate search numbers from a block

TasBob — Mon, 16 Mar 2020 14:10:17 GMT

Excel is there a way to eliminate search numbers from a block of numbers? A column of 1000 numbers?

Block Search Search for 018 025 865 I like to search 50 numbers or more

Then it would look like this

015 015

016 016

017 017

018 018

019 019

025 025

027 027

029 029

035

037

038

039

045

047

049

056

057

058

059

067

Both Block And Search are eliminated , This is used for my eliminating system.