Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort numbers
I have a list of numbers, each entry containing four numbers. I would like
to sort them by finding 3 common numbers. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort numbers
Give an example of before and after, so that we might understand your
requirements better. Pete On Sep 16, 4:05*pm, Free Rider <Free wrote: I have a list of numbers, each entry containing four numbers. *I would like to sort them by finding 3 common numbers. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort numbers
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 "Pete_UK" wrote: Give an example of before and after, so that we might understand your requirements better. Pete On Sep 16, 4:05 pm, Free Rider <Free wrote: I have a list of numbers, each entry containing four numbers. I would like to sort them by finding 3 common numbers. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort numbers
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 On Sep 16, 8:36*pm, Free Rider wrote: 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 "Pete_UK" wrote: Give an example of before and after, so that we might understand your requirements better. Pete On Sep 16, 4:05 pm, Free Rider <Free wrote: I have a list of numbers, each entry containing four numbers. *I would like to sort them by finding 3 common numbers.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort "text" numbers with and without leading zeros as numbers | Excel Discussion (Misc queries) | |||
Sort by last two numbers | Excel Discussion (Misc queries) | |||
All numbers won't sort | Excel Discussion (Misc queries) | |||
Sort numbers | Excel Discussion (Misc queries) | |||
sort + & - numbers together | Excel Worksheet Functions |