Windows cmd sort unique

If your supporting data is in an Excel Table , then the array will automatically resize as you add or remove data from your array range if you're using Structured References. For more details, see this article on Spilled Array Behavior.

Excel has limited support for dynamic arrays between workbooks, and this scenario is only supported when both workbooks are open. If you close the source workbook, any linked dynamic array formulas will return a REF! This can be useful if you want to identify people who have not returned for additional service, so you can contact them. Note that the formula references the entire range of names in A2:A12 and B2:B This allows Excel to return an array of all names. If you format the range of names as an Excel table , then the formula will automatically update when you add or remove names.

You can always ask an expert in the Excel Tech Community or get support in the Answers community. SORT function. Dynamic arrays and spilled array behavior. Implicit intersection operator:. TRUE will return all distinct rows or columns that occur exactly once from the range or array FALSE or omitted will return all distinct rows or columns from the range or array Notes: An array can be thought of as a row or column of values, or a combination of rows and columns of values.

Tips: If you format the range of names as an Excel table , then the formula will automatically update when you add or remove names. Need more help? Collectives on Stack Overflow. Learn more. Ask Question. Asked 9 years, 3 months ago. Active 1 year, 5 months ago. Viewed 18k times. Say I have a file like: apple pear lemon lemon pear orange lemon How do I make it so that I only keep the unique lines, so I get: apple pear lemon orange I can either modify the original file or create a new one.

Improve this question. Kache Kache Add a comment. Active Oldest Votes. Improve this answer. Awesome, thanks! I ended up writing an echo Kache Glad I could help. If you're open to powershell , you could also use simple 1 liners: unsorted gc uniqinput. Maybe mean something specifal for batch.

Anyway- my please take my vote : — user This is probably due to the fact that cmd tries a numeric comparison. I changed the comparison to be strictly strings by adding quotes, should be done anyway - that should fix it — wmz.

Note that, due to foibles of FOR it is up to you to only quote directories with special chars e. FOR normally prints each command before it runs it, the suppresses this. Download cygwin utility, it is simple Linux terminal under windows. It allow to execute any Linux command in Windows. And you have sort -u there. How are we doing? Please help us improve Stack Overflow. Take our short survey.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 7 years, 10 months ago. Active 11 months ago. Viewed 10k times. Improve this question. Add a comment. Active Oldest Votes.