Key Numbers

[wd8ekd]

Key Numbers
Need formula or is a Macro needed in this excelsheet?...
OK I have in A-Column and B-Column around 50 3 digit numbers--
singles, doubles, triples,and reverse 3 digit numbers and
sometimes duplicates....
A-column-B-column
123------556
223------489
003------543
444------592
345------879
621------671
809------890
567------800
234------338
321------666
---ETC---
What I am trying to do in COLUMNS D_E_F_G_H_I_J_K_L_M
which are listed as---------------0-1-2-3-4-5-6-7-8-9
I want all the numbers that have a zero in them to be
under the D column which is zero--0..FROM Columns A-&-B--only.
Example ---
D-Column--E-Column
-0--------1-------
003------123
809------621
890------321
800------671
Hope I explained it right..and put this question in the right place.
Thank you
Bob in Michigan

[DonkeyOte]

Bob, questions...

a) if duplicates exist are all instances to be listed ?

b) is VBA viable ?

I mention b) as formula based approach is likely to prove inefficient.

[wd8ekd]

yes all numbers to be listed dups and all..

[DonkeyOte]

Well I'd opt for VBA ... this would be one approach (not particularly elegant though)

Please Login or Register  to view this content.

The above assumes numbers to be in A2:B50, 0-9 listed in C1 to L1 with numbers to be listed in rows beneath.

(it's not clear if A:B are numbers stored as text or numbers with 000 number format... the above should account for either)

[wd8ekd]

we will try it out in a couple of hours..
Thank you
Will let you know later..
And thanks again
Bob in Michigan

[wd8ekd]

It is working BUT it gives quite a few of extra numbers...
like I have only one 333 and it gives me three of them..
And in a few other columns it will list a number more than once...

I know that I have Dups in the columns BUT it will still
list a single number more than once....
hope I said it right...
Bob

[DonkeyOte]

I made some edits possibly after you took the code - try the version above as it stands now - it should account for 333 etc...

[wd8ekd]

DonkeyOte

Hey that did the trick. Thank you

Bob from Michigan