F
Free Rider
I have a list of numbers, each entry containing four numbers. I would like
to sort them by finding 3 common numbers.
to sort them by finding 3 common numbers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
Give an example of before and after, so that we might understand your
requirements better.
Pete
requirements better.
Pete
F
Free Rider
ok, example:
a list of entries, four random digits, such as 1234, 2347, 8134, 8247, 5743,
etc.
how could i arrange them so that all entries that have for example the
numbers 347 in it (in any order) would be grouped.
Does this help?
Thanks
a list of entries, four random digits, such as 1234, 2347, 8134, 8247, 5743,
etc.
how could i arrange them so that all entries that have for example the
numbers 347 in it (in any order) would be grouped.
Does this help?
Thanks
P
Pete_UK
Well, I still don't know what you want to end up with, but if you put
those numbers in, say, A1:A5 and put 347 in D1, then you can put this
formula in B1:
=SUMPRODUCT(--(ISNUMBER(SEARCH(MID(A1,ROW(A$1:A$4),1),""&D$1))))
and copy it down to B5 and you will have this:
1234 2 347
2347 3
8134 2
8247 2
5743 3
Then I suppose you could sort A1:B5 using column B in descending order
and column A in ascending order to get this:
2347 3
5743 3
1234 2
8134 2
8247 2
Is that what you had in mind?
Hope this helps.
Pete
those numbers in, say, A1:A5 and put 347 in D1, then you can put this
formula in B1:
=SUMPRODUCT(--(ISNUMBER(SEARCH(MID(A1,ROW(A$1:A$4),1),""&D$1))))
and copy it down to B5 and you will have this:
1234 2 347
2347 3
8134 2
8247 2
5743 3
Then I suppose you could sort A1:B5 using column B in descending order
and column A in ascending order to get this:
2347 3
5743 3
1234 2
8134 2
8247 2
Is that what you had in mind?
Hope this helps.
Pete