Welcome to our forums! Please login or register to get access to all our forums!
Welcome to our forums! Please login or register to get access to all our forums!
Would you like to react to this message? Create an account in a few clicks or log in to continue.



 
HomePortalSearchRegisterLog in

 :: GENERAL :: Discussions
 

 WTF Excel

Go down 
3 posters
AuthorMessage
[TmX]Terekhov

[TmX]Terekhov


Posts : 280
Join date : 2014-03-29
Age : 33
Location : United States

WTF Excel Empty
PostSubject: WTF Excel   WTF Excel EmptyTue Apr 15, 2014 10:59 am
Anyone here good with Excel? I'm trying to create a spreadsheet that duplicates the sorting behavior of the Wiki table on this page: http://en.wikipedia.org/wiki/AFI%27s_100_Years...100_Movies

...and having a hell of a time doing it. I figured out how to group rows (in theory), but can't get the columns to sort how the Wikipedia ones do.
Back to top Go down
P4iN-Ox-
Full Moderator
P4iN-Ox-


Posts : 496
Join date : 2013-07-09
Age : 29
Location : Germany

WTF Excel Empty
PostSubject: Re: WTF Excel   WTF Excel EmptyTue Apr 15, 2014 3:35 pm
I dont think i got what you meant there but i tried it anyways :D
http://1drv.ms/1gATvwN
Back to top Go down
BillieJoe67
Full Moderator



Posts : 547
Join date : 2012-04-15
Age : 28

WTF Excel Empty
PostSubject: Re: WTF Excel   WTF Excel EmptyTue Apr 15, 2014 4:24 pm
Highlight column, it's under data->sort I think
Back to top Go down
Sponsored content





WTF Excel Empty
PostSubject: Re: WTF Excel   WTF Excel Empty
Back to top Go down
 
WTF Excel
Back to top 
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
 :: GENERAL :: Discussions-
Jump to: