remove duplicates and sort

[rcahayag1925]

hello,

i am using an old version of excel Windows, 2013.

Whats best solution alternative for Unique and Filter formulas.

I have list of data, and wanted to get the list of names once and arrange it in alphabetical order.

Example:

Bananas
Apple
Bananas
Mango
Mango
Guava
Apple
Bananas


Result:
Apple
Bananas
Guava
Mango


Also, whats the best solution if you want to get the maximum number for the following data:

29-1
29-2
30-3

result 30-3


Thanks

[sintek]

For first part...

Please Login or Register  to view this content.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[rcahayag1925]

thank you sintek it works well,however i failed to realize other information attached to those items

what I wanted is to delete duplicates and then sort them, then get the highest numbers in Column B and Column C, relating to items in Column A. The final result to be shown in Sheet2

Sheet 1
Column A Column B Column C
Bananas 29-1 13,000
Apple 17-2 17,500
Bananas 29-3 17,000
Mango 30-1 20,000
Mango 30-2 21,500
Guava 11-1 8,000
Apple 18-5 9,500
Bananas 7-2 5,000

Result to be shown in Sheet2
Apple 18-5 17,500
Bananas 29-3 17,000
Guava 11-1 8,000
Mango 30-2 21,500

[rcahayag1925]

thank you for the reminder AliGW

[jindon]

Please Login or Register  to view this content.

[rcahayag1925]

Thank you jindon,
-
It works well except for one criteria. The result of Apple, instead of 18-5, the formula resulted to 17-2

Is it possible,when we run the VBA code, the result be posted on another sheet?

Thank you

[jindon]

Then that one is out of logic.
Can you explain why it should be so?

[rcahayag1925]

thank you jindon, I think I made a wrong data input. It corrected the data and it works fine.

what if i wanted the result to be on another sheet?

thank you again

[jindon]

Hummm, see if this is how you want it.

Please Login or Register  to view this content.

[rcahayag1925]

thanks for the help jindon