Do you know how to create pivot tables?

 

You can also use filters for simple sort.

 

I filtered to get down to what I have now. But thats as far as it got me. I thougth I could filter and "remove duplicates" but its not that simple, (I don't think)

Pivot tables might be the way to go. But I never have been able to figure them out very well. I'll read more and see if I can figure it out with the pivot tables.

If anyone else can help with the PT's, I'm all ears

 

I got it. Select your column C. Go to Data -> Filters -> Advanced Filters and put a check mark in the box "unique records only".

 

Just click OK if you get a warning about column labels. On the next menu below the range info is the box. Put a check in it.

 

I think that works!

I tried that before but the problem is I'm retarded.

That Column C really goes out to 4 decimal places and I changed the cell format to show them to 1 place. Thats what fucked me up. It wouldn't pull the unique records out becuse the numbers weren't unique. I should have rounded them to 1 decimal place and then pulled out the unique records.

I think thats gonna save me literally 15 hours worth of work

Thanks both of you! :bow