Excel question - Chicagoland Sportbikes
Chicagoland Sportbikes
 
Geek Squad to the rescue! fucken computer crashing on you again? another porn site infected your computer? tierd of your wife seeing your anal fisting videos and want to lock her out of the external HD? get the answers you need from our local computer experts.

 
LinkBack Thread Tools Display Modes
post #1 of 7 (permalink) Old 06-27-2010, 01:55 PM Thread Starter
Model citizen
 
Maynard's Avatar
 
Join Date: Oct 2005
Location: Rockford
Posts: 10,025
Location: Rockford
Sportbike: ktm
Years Riding: a few
How you found us: SBN
           
Excel question

I have a mountain of data that I need to orginize. Any help is appreciated!

I have a table like this. I need to hide or delete the rows that are duplicates in Column C.

I only want one row that has "2.6" in Column C
One row that has "2.7" in Column C
One row that has "2.8" in Column C

etc....

Current Table



I want the above table to look like this....



Eric

Last edited by Maynard; 06-27-2010 at 02:01 PM.
Maynard is offline  
Sponsored Links
Advertisement
 
post #2 of 7 (permalink) Old 06-27-2010, 02:01 PM
TERRAdactyl
 
catwlights's Avatar
 
Join Date: Feb 2007
Location: Aurora, IL
Posts: 6,648
Location: Aurora, IL
Sportbike: 07 600RR
Years Riding: on the street since 01
How you found us: accidentally stepped in it
           
Send a message via Yahoo to catwlights
Do you know how to create pivot tables?

Terra
STT Staff
Midwest Instructor
www.sportbiketracktime.com


Pushing the Limits of Life's Opportunities
catwlights is offline  
post #3 of 7 (permalink) Old 06-27-2010, 02:02 PM
TERRAdactyl
 
catwlights's Avatar
 
Join Date: Feb 2007
Location: Aurora, IL
Posts: 6,648
Location: Aurora, IL
Sportbike: 07 600RR
Years Riding: on the street since 01
How you found us: accidentally stepped in it
           
Send a message via Yahoo to catwlights
You can also use filters for simple sort.

Terra
STT Staff
Midwest Instructor
www.sportbiketracktime.com


Pushing the Limits of Life's Opportunities
catwlights is offline  
Sponsored Links
Advertisement
 
post #4 of 7 (permalink) Old 06-27-2010, 02:23 PM Thread Starter
Model citizen
 
Maynard's Avatar
 
Join Date: Oct 2005
Location: Rockford
Posts: 10,025
Location: Rockford
Sportbike: ktm
Years Riding: a few
How you found us: SBN
           
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

Eric
Maynard is offline  
post #5 of 7 (permalink) Old 06-27-2010, 02:28 PM
yo quiero su taco
 
whiteSeatEnvy's Avatar
 
Join Date: Dec 2002
Location: Woodridge
Posts: 12,745
Location: Woodridge
Sportbike: Honda CBR 954 blk/slvr
Years Riding: 10 years
How you found us: They found me. Follow the white rabbit.
           
I got it. Select your column C. Go to Data -> Filters -> Advanced Filters and put a check mark in the box "unique records only".

Last edited by whiteSeatEnvy; 06-27-2010 at 02:31 PM.
whiteSeatEnvy is offline  
post #6 of 7 (permalink) Old 06-27-2010, 02:34 PM
yo quiero su taco
 
whiteSeatEnvy's Avatar
 
Join Date: Dec 2002
Location: Woodridge
Posts: 12,745
Location: Woodridge
Sportbike: Honda CBR 954 blk/slvr
Years Riding: 10 years
How you found us: They found me. Follow the white rabbit.
           
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.
whiteSeatEnvy is offline  
post #7 of 7 (permalink) Old 06-27-2010, 02:58 PM Thread Starter
Model citizen
 
Maynard's Avatar
 
Join Date: Oct 2005
Location: Rockford
Posts: 10,025
Location: Rockford
Sportbike: ktm
Years Riding: a few
How you found us: SBN
           
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!

Eric
Maynard is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the Chicagoland Sportbikes forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may 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
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome