<?xml version="1.0"?>
<rss xmlns:media="http://search.yahoo.com/mrss/" version="2.0">
							<channel><title>New Posts For Thread: Excel help needed regarding ranking results</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25584277/excel-help-needed-regarding-ranking-results</link><description>The problem I have is this....I have a spreadsheet that produces several results based on simple calculations but it is unavoidable that the results will be all jumbled up.  It would simplify things for me greatly if there was a way of ranking these</description><item><title>thanks Artisan...that copy paste special solution did the trick.thanks again lori</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25584277/excel-help-needed-regarding-ranking-results?post_id=468414721#468414721</link><description>thanks Artisan...that copy paste special solution did the trick.thanks again lori</description><pubDate>Fri, 01 Oct 2010 13:06:10 -0500</pubDate></item><item><title>next line would be=LARGE($B$3:$B$34,31)</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25584277/excel-help-needed-regarding-ranking-results?post_id=468408673#468408673</link><description>next line would be=LARGE($B$3:$B$34,31)</description><pubDate>Fri, 01 Oct 2010 12:23:20 -0500</pubDate></item><item><title>I have a sheet where I input tennis players in draw order (so randomish for outright purposes) and have their outright odds next to their names.My last column shows me just the prices from smallest to largest (no names attatched) to give me a feel fo</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25584277/excel-help-needed-regarding-ranking-results?post_id=468408053#468408053</link><description>I have a sheet where I input tennis players in draw order (so randomish for outright purposes) and have their outright odds next to their names.My last column shows me just the prices from smallest to largest (no names attatched) to give me a feel fo</description><pubDate>Fri, 01 Oct 2010 12:18:30 -0500</pubDate></item><item><title>Without understanding a bit more about the spreadsheet, and how you've set the formulae up, it's a bit hard to say.  You might consider Copy, Paste Special, Values, for the earlier calculations, and then Sort on the values column.  But that might stu</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25584277/excel-help-needed-regarding-ranking-results?post_id=468407225#468407225</link><description>Without understanding a bit more about the spreadsheet, and how you've set the formulae up, it's a bit hard to say.  You might consider Copy, Paste Special, Values, for the earlier calculations, and then Sort on the values column.  But that might stu</description><pubDate>Fri, 01 Oct 2010 12:12:09 -0500</pubDate></item><item><title>cheers Artisan...that seems to work if i just type in numbers to different cells but the list of figures I have is based on earlier calculations so the cells have cell references in rather than just the numbers which doesnt seem to work for some reas</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25584277/excel-help-needed-regarding-ranking-results?post_id=468402245#468402245</link><description>cheers Artisan...that seems to work if i just type in numbers to different cells but the list of figures I have is based on earlier calculations so the cells have cell references in rather than just the numbers which doesnt seem to work for some reas</description><pubDate>Fri, 01 Oct 2010 11:26:01 -0500</pubDate></item><item><title>As Lori and Cosmic suggest use Sort.Highlight all populated columns and then select Data, and then Sort from the drop down menu.  Choose the column you want to sort by.</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25584277/excel-help-needed-regarding-ranking-results?post_id=468400041#468400041</link><description>As Lori and Cosmic suggest use Sort.Highlight all populated columns and then select Data, and then Sort from the drop down menu.  Choose the column you want to sort by.</description><pubDate>Fri, 01 Oct 2010 11:02:02 -0500</pubDate></item><item><title>Now I've actually got round to doing this I've realised that ranking the answers wasn't quite what I wanted...what I actually wanted was to rearrange them from highest to lowest.  Is that possible?</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25584277/excel-help-needed-regarding-ranking-results?post_id=468399605#468399605</link><description>Now I've actually got round to doing this I've realised that ranking the answers wasn't quite what I wanted...what I actually wanted was to rearrange them from highest to lowest.  Is that possible?</description><pubDate>Fri, 01 Oct 2010 10:57:31 -0500</pubDate></item><item><title>I'm probably not understanding but why not just use the sort command?</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25584277/excel-help-needed-regarding-ranking-results?post_id=461229529#461229529</link><description>I'm probably not understanding but why not just use the sort command?</description><pubDate>Tue, 10 Aug 2010 12:26:44 -0500</pubDate></item><item><title>ta</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25584277/excel-help-needed-regarding-ranking-results?post_id=461188773#461188773</link><description>ta</description><pubDate>Tue, 10 Aug 2010 06:51:59 -0500</pubDate></item><item><title>*but doesn't return where it came from, just the number</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25584277/excel-help-needed-regarding-ranking-results?post_id=461187613#461187613</link><description>*but doesn't return where it came from, just the number</description><pubDate>Tue, 10 Aug 2010 06:39:54 -0500</pubDate></item></channel></rss>
