Excel Help
 

I need some help with excel that could save me quite a bit of time.

I have a spreadsheet of numbers, in 19 columns and over 200 rows. There are many duplicates in both columns and rows. I need a quick way to give me only the unique numbers.

EDIT: I have attached an example.

I've used this tool for years

http://www.ablebits.com/excel-remove...ates/index.php

Use the filter tool and it will highlight all the unique numbers

I want the output to be all the unique numbers in one column

Use the filter tool to find the unique numbers and then use an "if then" statement to move them. Im on a tablet and cant see your example but that should work

Select your data set

Insert a Pivot Table on a new sheet.

Drag your field which you need to be unique into the "Row labels" column.

That's it.

Be careful using filters. If you use filters and copy cut paste it into another sheet, your data is going to be all messed up if you don't hit "visible cells only."

This is very confusing. I have no idea what I am doing or how to use pivot tables.

Do you only need unique numbers in a single columns or all columns?

Have you tried moving all the numbers into one column and then removing duplicates?

Just cut/paste a column of numbers in into the next column. Just work your way down until all of them have been pasted into the first column.
I would start on the far right column and work that way, it will be easier.

ctrl+shift will be your friend here to highlight all the numbers in a column quickly

I just did this and it took less than 5 min.

I don't know how to attach files but I got 86 unique numbers

as was also suggested a pivot table could get you what you need as well

Hmmm, I imported the file into Access and ran a simple grouped query and got 60 unique rows.

Attached are my results in Sheet2.

Data Menu - Remove Duplicates. It's almost as if it's designed specifically for this situation.