The Virtual Pub

Come Inside... => The Computer Room => Topic started by: Nick on August 12, 2012, 07:54:52 PM

Title: EXCEL SPREADSHEET HELP
Post by: Nick on August 12, 2012, 07:54:52 PM: Anybody skilled with Excel??? Need help!!!!!!
Title: Re: EXCEL SPREADSHEET HELP
Post by: apc2010 on August 12, 2012, 07:55:44 PM: Fluffy is well.......... :thumbsup:
Title: Re: EXCEL SPREADSHEET HELP
Post by: Barman on August 13, 2012, 05:13:58 AM: Quote from: Nick (GC First Class) on August 12, 2012, 07:54:52 PM
Anybody skilled with Excel??? Need help!!!!!!

Go on.... Popcorn:
Title: Re: EXCEL SPREADSHEET HELP
Post by: Nick on August 13, 2012, 06:12:44 AM: Trying to sort a column in a spready into figures in descending order, but it's a "pivot table" and won't let me perform the action
Title: Re: EXCEL SPREADSHEET HELP
Post by: Barman on August 13, 2012, 06:30:56 AM: Quote from: Nick (GC First Class) on August 13, 2012, 06:12:44 AM
Trying to sort a column in a spready into figures in descending order, but it's a "pivot table" and won't let me perform the action

A column you say....? rubschin:
Title: Re: EXCEL SPREADSHEET HELP
Post by: Nick on August 13, 2012, 06:33:21 AM: Sort the whole spready into a sequence dictated by ONE column cussing:
Title: Re: EXCEL SPREADSHEET HELP
Post by: Barman on August 13, 2012, 06:36:57 AM: (https://www.virtual-pub.com/SMF/proxy.php?request=http%3A%2F%2Fwww.photo-dictionary.com%2Fphotofiles%2Flist%2F455%2F831column.jpg&hash=651e37390e3b279d8ad004d58b10ff312ce9dca8)

Shrugs:
Title: Re: EXCEL SPREADSHEET HELP
Post by: Nick on August 13, 2012, 06:38:11 AM: Can you help or not? Angry9:
Title: Re: EXCEL SPREADSHEET HELP
Post by: Miss Demeanour on August 13, 2012, 06:40:16 AM: Can you delete any descriptive rows and then just highlight the data and sort ?
Title: Re: EXCEL SPREADSHEET HELP
Post by: Nick on August 13, 2012, 06:41:33 AM: Do what now? Shrugs:
Title: Re: EXCEL SPREADSHEET HELP
Post by: Barman on August 13, 2012, 06:42:13 AM: Quote from: Nick (GC First Class) on August 13, 2012, 06:38:11 AM
Can you help or not? Angry9:

Prolly not.... redface:

I know a man who can tho! (http://www.dummies.com/how-to/content/filtering-and-sorting-an-excel-2010-pivot-table.html)
Title: Re: EXCEL SPREADSHEET HELP
Post by: Nick on August 13, 2012, 06:45:06 AM: rubschin:
Title: Re: EXCEL SPREADSHEET HELP
Post by: Barman on August 13, 2012, 06:46:23 AM: Quote from: Nick (GC First Class) on August 13, 2012, 06:45:06 AM
rubschin:

No need to thank me! angel1
Title: Re: EXCEL SPREADSHEET HELP
Post by: Nick on August 13, 2012, 06:53:16 AM: Yay Party001: Party001: Party001: Party001: Party001:
Title: Re: EXCEL SPREADSHEET HELP
Post by: Barman on August 13, 2012, 07:01:15 AM: angel1
Title: Re: EXCEL SPREADSHEET HELP
Post by: Nick on August 13, 2012, 07:03:03 AM: Big sloppy kisses for Poo Poo :thumbsup:
Title: Re: EXCEL SPREADSHEET HELP
Post by: Barman on August 13, 2012, 07:13:42 AM: Quote from: Nick (GC First Class) on August 13, 2012, 07:03:03 AM
Big sloppy kisses for Poo Poo :thumbsup:

Gayer:
Title: Re: EXCEL SPREADSHEET HELP
Post by: Barman on August 13, 2012, 07:15:28 AM: See also here (http://lmgtfy.com/?q=how+to+sort+column+in+pivot+table). whistle:
Title: Re: EXCEL SPREADSHEET HELP
Post by: Nick on August 13, 2012, 07:16:44 AM: evil:
Title: Re: EXCEL SPREADSHEET HELP
Post by: Barman on August 13, 2012, 07:19:15 AM: Quote from: Nick (GC First Class) on August 13, 2012, 07:16:44 AM
evil:

point: