How can I select the largest number in a list...

D

Dr. Darrell

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
 
B

Bob Alhat

A bit of a work-around:
Copy the column
Do text to columns, using ^ as the delimeter
Filter on the new columns

HTH
Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding a folder with the largest number. 1
finding the second largest number in a list 1
Index/Match for the largest value that matches 1
Formula help 1
Can I change the color of the largest number in a column? 3
Order numbers from smallest to largest 6
Finding Next Largest Number Based on Criteria 3
FInding the largest number in a range meeting a criteria 4

Top