This online utility quickly aggregates the lines pasted in the text box and shows you count of occurrences of each value. Use this to quickly aggregate the values to find duplicate lines, or to count the number of repeats.
If you have an Excel spreadsheet and want to get distinct values from a column, just copy and paste the column of data from your Excel sheet into the textbox below. You will get a list of the unique values along with the count of occurrences for each value.
Paste your text in the text box and then press the "Update Counts" button.