Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I select the largest number in a list...
I have a list similar to the following:
DopOrder^14131^1^ DopOrder^14132^2^ DopOrder^14132^3^ DopOrder^14132^4^ DopOrder^14134^1^ DopOrder^14134^2^ DopOrder^14134^3^ DopOrder^14134^43^ I only want to work with the numbers that end with ^1^ and ^ (the largest number) ^ for each of the prefix nimbers, (14132 & 14134). Please note that the list will be several thousand numbers long. I can filter the numbers ending with ^1^ by using a wild card such as " DopOrder^*^1^ ". My question is; is there a wildcard for selcting the largest number in a list? Thanks, Darrell |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I select the largest number in a list...
A bit of a work-around:
Copy the column Do text to columns, using ^ as the delimeter Filter on the new columns HTH Bob "Dr. Darrell" wrote in message ... I have a list similar to the following: DopOrder^14131^1^ DopOrder^14132^2^ DopOrder^14132^3^ DopOrder^14132^4^ DopOrder^14134^1^ DopOrder^14134^2^ DopOrder^14134^3^ DopOrder^14134^43^ I only want to work with the numbers that end with ^1^ and ^ (the largest number) ^ for each of the prefix nimbers, (14132 & 14134). Please note that the list will be several thousand numbers long. I can filter the numbers ending with ^1^ by using a wild card such as " DopOrder^*^1^ ". My question is; is there a wildcard for selcting the largest number in a list? Thanks, Darrell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding largest number from list | Excel Discussion (Misc queries) | |||
Select Largest 5 in A, AVG values in B | Excel Worksheet Functions | |||
return largest number of a list of numbers in the same cell | Excel Worksheet Functions | |||
Finding the 3rd largest number in a list | Excel Worksheet Functions | |||
finding the second largest number in a list | Excel Discussion (Misc queries) |