Computers Excel Help

**Dartgod** · 11-20-2013, 07:39 AM

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.

scho63 · 11-20-2013, 07:43 AM

I've used this tool for years

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

**HayWire** · 11-20-2013, 07:52 AM

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

**Dartgod** · 11-20-2013, 07:54 AM

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

**HayWire** · 11-20-2013, 08:01 AM

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

CleveSteve · 11-20-2013, 10:00 AM

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.

chiefzilla1501 · 11-20-2013, 10:09 AM

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."

58-4ever · 11-20-2013, 12:35 PM

Quote:

Originally Posted by CleveSteve

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.

This!

**Dartgod** · 11-20-2013, 10:16 AM

Quote:

Originally Posted by CleveSteve

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.

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

KC_Lee · 11-20-2013, 10:28 AM

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

Wildcat2005 · 11-20-2013, 10:33 AM

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.

**Dartgod** · 11-20-2013, 10:53 AM

Quote:

Originally Posted by Wildcat2005

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.

This is how I do it now. I don't want to take 5 minutes. I want to do it in seconds.

KC native · 11-20-2013, 10:55 AM

Quote:

Originally Posted by Dartgod

This is how I do it now. I don't want to take 5 minutes. I want to do it in seconds.

Learn VBA

**Dartgod** · 11-20-2013, 10:56 AM

Quote:

Originally Posted by Race Card native

Learn VBA

Thanks, I'll get right on that!

11-20-2013, 07:43 AM	#2
scho63 Politically Incorrect Join Date: Feb 2009 Location: Scottsdale, AZ Casino cash: $-740000	I've used this tool for years http://www.ablebits.com/excel-remove...ates/index.php __________________ *"The only difference between sex for free and sex for money is that sex for free costs you a WHOLE LOT more!"* ~Redd Foxx~ ~~2018 2019 2020 20212022 2023~~ 2024 Adopt a Chief - Clark Hunt and Brett Veach "The men who drafted Patrick Mahomes"
Posts: 54,937

11-20-2013, 07:52 AM	#3
HayWire Retired Bearcat Join Date: Dec 2011 Location: SWMO Casino cash: $4532400	Use the filter tool and it will highlight all the unique numbers
Posts: 7,587

11-20-2013, 07:54 AM	#4
Dartgod Wasted away again... Join Date: Aug 2000 Location: in Margaritaville Casino cash: $3790000	I want the output to be all the unique numbers in one column __________________ If you shed a tear for me, please make it a tear of joy. -Joe Tracy (Nzoner) . .
Posts: 52,172

11-20-2013, 08:01 AM	#5
HayWire Retired Bearcat Join Date: Dec 2011 Location: SWMO Casino cash: $4532400	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
Posts: 7,587

11-20-2013, 10:00 AM	#6
CleveSteve Veteran Join Date: Mar 2013 Location: Pflugerville, TX Casino cash: $10010636	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.
Posts: 1,150

11-20-2013, 10:09 AM	#7
chiefzilla1501 In Search of a Life Join Date: Aug 2008 Casino cash: $-1565503	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."
Posts: 51,560

11-20-2013, 10:28 AM	#11
KC_Lee You're CARICATURES, ALL of you Join Date: Sep 2006 Location: Kansas City, MO Casino cash: $-1709040	Do you only need unique numbers in a single columns or all columns? __________________ “There is no absolute knowledge. And those who claim it, whether they are scientists or dogmatists, open the door to tragedy.” - Jacob Bronowski, The Ascent of Man
Posts: 12,128

11-20-2013, 10:33 AM	#12
Wildcat2005 Starter Join Date: Nov 2012 Casino cash: $10005555	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.
Posts: 391