Home Discord Chat
Go Back   ChiefsPlanet > Nzoner's Game Room
Reload this Page Computers Excel Help
Register FAQDonate Members List Calendar Mark Forums Read

Reply
Page 3 of 3 12 3
 
Thread Tools Display Modes
Old 11-20-2013, 07:39 AM  
Dartgod Dartgod is offline
Wasted away again...
 
Dartgod's Avatar
 
Join Date: Aug 2000
Location: in Margaritaville
Casino cash: $3790000
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.
Attached Files
File Type: xls Book1.xls (36.5 KB, 115 views)
Posts: 52,172
Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.
     Reply With Quote
Old 11-20-2013, 02:07 PM   #31
Dartgod Dartgod is offline
Wasted away again...
 
Dartgod's Avatar
 

Join Date: Aug 2000
Location: in Margaritaville
Casino cash: $3790000
Quote:
Originally Posted by DaFace View Post
I should be able to edit the script for my purposes, but how do I get that to run in my spreadsheet?
__________________
If you shed a tear for me, please make it a tear of joy.
-Joe Tracy (Nzoner)
.
.
<a href=http://www.chiefsplanet.com/BB/showthread.php?t=275537 target=_blank><img src=http://www.chiefsplanet.com/BB/signaturepics/sigpic126_7.gif border=0 alt= /></a>
Posts: 52,172
Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.
     Reply With Quote
Old 11-20-2013, 02:50 PM   #32
Dartgod Dartgod is offline
Wasted away again...
 
Dartgod's Avatar
 

Join Date: Aug 2000
Location: in Margaritaville
Casino cash: $3790000
Quote:
Originally Posted by Dartgod View Post
I should be able to edit the script for my purposes, but how do I get that to run in my spreadsheet?
Never mind. I figured it out and it does exactly what I need.

Much rep to all who helped out!
__________________
If you shed a tear for me, please make it a tear of joy.
-Joe Tracy (Nzoner)
.
.
<a href=http://www.chiefsplanet.com/BB/showthread.php?t=275537 target=_blank><img src=http://www.chiefsplanet.com/BB/signaturepics/sigpic126_7.gif border=0 alt= /></a>
Posts: 52,172
Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.Dartgod is obviously part of the inner Circle.
     Reply With Quote
Old 11-20-2013, 03:50 PM   #33
DaFace DaFace is offline
Kind of a mod
 
DaFace's Avatar
 

Join Date: Aug 2005
Location: Donkey Land
Casino cash: $-1683101
Quote:
Originally Posted by Dartgod View Post
Never mind. I figured it out and it does exactly what I need.

Much rep to all who helped out!
Awesome. Glad it worked!
Posts: 53,132
DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.DaFace is obviously part of the inner Circle.
     Reply With Quote
Old 11-20-2013, 04:54 PM   #34
Valiant Valiant is offline
Valiant 'The Thread Killer'
 
Valiant's Avatar
 

Join Date: Jun 2001
Location: Kansas City
Casino cash: $4572380
Highlight and use remove duplicates in data tab.

On my phone so not downloading the file to look at.
Posts: 18,550
Valiant threw an interception on a screen pass.Valiant threw an interception on a screen pass.Valiant threw an interception on a screen pass.Valiant threw an interception on a screen pass.Valiant threw an interception on a screen pass.Valiant threw an interception on a screen pass.Valiant threw an interception on a screen pass.Valiant threw an interception on a screen pass.Valiant threw an interception on a screen pass.Valiant threw an interception on a screen pass.Valiant threw an interception on a screen pass.
     Reply With Quote
Reply
Page 3 of 3 12 3

« Previous Thread | > Nzoner's Game Room < | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump




All times are GMT -6. The time now is 05:27 AM.

Contact Us - ChiefsPlanet - Archive - Top

This is a test for a client's site.
Fort Worth Texas Process Servers
Covering Arlington, Fort Worth, Grand Prairie and surrounding communities.
Tarrant County, Texas and Johnson County, Texas.
Advertise with us!
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.