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

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

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

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

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

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

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

Quote:

Originally Posted by Wildcat2005

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

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

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

Quote:

Originally Posted by KC_Lee

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

Attached are my results in Sheet2.

**Rain Man** · 11-20-2013, 10:45 AM

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

11-20-2013, 07:43 AM	#2
scho63 Politically Incorrect Join Date: Feb 2009 Location: Scottsdale, AZ Casino cash: $-730000	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: $3800000	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,171

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	#9
KC_Lee You're CARICATURES, ALL of you Join Date: Sep 2006 Location: Kansas City, MO Casino cash: $-1699040	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,126

11-20-2013, 10:33 AM	#10
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

11-20-2013, 10:36 AM	#11
Wildcat2005 Starter Join Date: Nov 2012 Casino cash: $10005555	I don't know how to attach files but I got 86 unique numbers
Posts: 391

11-20-2013, 10:41 AM	#12
Wildcat2005 Starter Join Date: Nov 2012 Casino cash: $10005555	as was also suggested a pivot table could get you what you need as well
Posts: 391

11-20-2013, 10:45 AM	#15
Rain Man Seize life. Be an ermine. Join Date: Jul 2001 Location: My house Casino cash: $-472449 VARSITY	Data Menu - Remove Duplicates. It's almost as if it's designed specifically for this situation. __________________ Active fan of the greatest team in NFL history.
Posts: 145,272