Notices

Overclockers Forums > Software > Microsoft Operating Systems
Microsoft Operating Systems Microsoft Operating Systems and Applications
Forum Jump

quickie excel question

Post Reply New Thread Subscribe Search this Thread
 
 
Thread Tools
Old 09-06-07, 10:16 AM Thread Starter   #1
invictius
Disabled



Join Date: Oct 2005
Location: 4 hrs from where all these goodies are made, yet they cost double here than on newegg(which isn't on my continent)!

 
quickie excel question


Not sure how to sort the data from most to least km (in column J without affecting the data relative to the other columns. here she is
invictius is offline   QUOTE Thanks
Old 09-06-07, 12:26 PM   #2
seadave77

 
seadave77's Avatar 

Join Date: Jul 2002
Location: Newnan, GA

 
Select all your data then goto Data - Sort. Sort by column J descending. If you do it wrong just undo.
seadave77 is offline   QUOTE Thanks
Old 09-06-07, 08:51 PM Thread Starter   #3
invictius
Disabled



Join Date: Oct 2005
Location: 4 hrs from where all these goodies are made, yet they cost double here than on newegg(which isn't on my continent)!

 
Quote:
Originally Posted by seadave77 View Post
Select all your data then goto Data - Sort. Sort by column J descending. If you do it wrong just undo.
"this removes the subtotals and sorts again. if you want to sort the subtotaled groups, choose the cancel button; then collapse the outline and try again."

Needless to say, I lose all info relative to the other columns...
invictius is offline   QUOTE Thanks
Old 09-07-07, 09:10 AM   #4
Omsion
Member

 
Omsion's Avatar 

Join Date: Mar 2006
Location: Chicago and/or NJ

 
You only lose the subtotals in this case.
Can't sort individual values freely with subtotals involved.
If you want to be able to sort freely, then I would get rid of the subtotals (which does remove the nesting, unfortunently) and use SUMIF.

SUMIF(<cell range>,<condition to check cell range on>,<actual cells to sum>)
<cell range> and <actual cells to sum> would be the entire range of all your data. Repeat for the different labels.

__________________
Current
2500K | ASRock Z68 Pro3-M | TR Venomous X
EVGA GTX 460 768MB | 2x4GB G.Skill (F3-12800CL9D-8GBSR2)
Seasonic X650 | Fractal Design Define Mini
Omsion is offline Heatware Profile   QUOTE Thanks

Post Reply New Thread Subscribe


Overclockers Forums > Software > Microsoft Operating Systems
Microsoft Operating Systems Microsoft Operating Systems and Applications
Forum Jump

Thread Tools Search this Thread
Search this Thread:

Advanced Search


Mobile Skin
All times are GMT -5. The time now is 02:31 AM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
You can add these icons by updating your profile information to include your Heatware ID, Benching Profile ID or your Folding/SETI profile ID. Edit your profile!
X

Welcome to Overclockers.com

Create your username to jump into the discussion!

New members like you have made this the best community on the Internet since 1998!


(4 digit year)

Why Join Us?

  • Share experience
  • Max out your hardware
  • Best forum members anywhere
  • Customized forum experience

Already a member?