tbourner Posted June 13, 2010 Share Posted June 13, 2010 Is it possible to auto arrange something in excel or do you have to manually do it? I know there are several ways to do it manually but ideally what I want is column A to have numbers in, and I want to somehow be able to change the numbers in column A (whether manually typing or with drop down menus or something) and it update the rest of the numbers in column A so there's no duplicates, and re-order them in descending order with the remaining columns moving as well. Like an auto data-sort kind of thing? Quote Link to comment Share on other sites More sharing options...
Jake Posted June 13, 2010 Share Posted June 13, 2010 Yeah it's possible. I have our footy spreadsheet doing an auto sorting leaderboard thing, based on data from elsewhere on the sheet. I don't have time to explain in detail at the mo but I could attach it if you want a look at it? Quote Link to comment Share on other sites More sharing options...
Jake Posted June 13, 2010 Share Posted June 13, 2010 ... Quote Link to comment Share on other sites More sharing options...
tbourner Posted June 14, 2010 Author Share Posted June 14, 2010 Thanks mate, it's a bit of a roundabout way of doing it for what I want though. I could have a seperate table with the info in and do lookups to that for the 'display' table, but I'd need to adjust the figures on the data table which then wouldn't be in order (if that makes sense). Basically, for my use; it would be easier to just grab the table and sort each time, I was just wondering if there was some command or function that could do it easily. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.