New Posts For Thread: Excel help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23531894/excel-help-pleaseCan someone tell me how to ignore #N/A in Rank function??Can't see anything specific to rank on the net, and I cant work out where to put the "#N/A"Thanks!........Compoung Magic........Sorry C M; more haste less speed required on my part methinks.https://community.betfair.com/general_betting/go/thread/view/94082/23531894/excel-help-please?post_id=420817774#420817774........Compoung Magic........Sorry C M; more haste less speed required on my part methinks.Mon, 15 Mar 2010 04:04:16 -0500Thanks very much guys : nothing like that was coming up on googlehttps://community.betfair.com/general_betting/go/thread/view/94082/23531894/excel-help-please?post_id=420817766#420817766Thanks very much guys : nothing like that was coming up on googleMon, 15 Mar 2010 03:29:49 -0500I agree with bushy - you should use ISNA in the formula where the #N/A is being returned to convert it to a value or blanks.https://community.betfair.com/general_betting/go/thread/view/94082/23531894/excel-help-please?post_id=420817746#420817746I agree with bushy - you should use ISNA in the formula where the #N/A is being returned to convert it to a value or blanks.Mon, 15 Mar 2010 02:47:23 -0500You can also use =ISNA(...) to test whether a returned value is #N/A or not.https://community.betfair.com/general_betting/go/thread/view/94082/23531894/excel-help-please?post_id=420817742#420817742You can also use =ISNA(...) to test whether a returned value is #N/A or not.Mon, 15 Mar 2010 02:20:28 -0500starfish and coffeeI may be barking up the wrong tree but maybe your query is similar to one I had myself a while back. Fellow forumite Compound Magic came to my rescue. I have posted my original query and the eventual solution from Compoung Magichttps://community.betfair.com/general_betting/go/thread/view/94082/23531894/excel-help-please?post_id=420817734#420817734starfish and coffeeI may be barking up the wrong tree but maybe your query is similar to one I had myself a while back. Fellow forumite Compound Magic came to my rescue. I have posted my original query and the eventual solution from Compoung MagicSun, 14 Mar 2010 22:03:29 -0500TryAssuming numbers to rank are in Cells A4:A20=IF(ISNUMBER(A4),RANK(A4,$A$4:$A$20,1),"")https://community.betfair.com/general_betting/go/thread/view/94082/23531894/excel-help-please?post_id=420817726#420817726TryAssuming numbers to rank are in Cells A4:A20=IF(ISNUMBER(A4),RANK(A4,$A$4:$A$20,1),"")Sun, 14 Mar 2010 20:02:55 -0500Ok : i'll work out some usage of Isnumber. Tried your trick of adding .0001 to the source data but that didnt work too. Thanks.https://community.betfair.com/general_betting/go/thread/view/94082/23531894/excel-help-please?post_id=420817722#420817722Ok : i'll work out some usage of Isnumber. Tried your trick of adding .0001 to the source data but that didnt work too. Thanks.Sun, 14 Mar 2010 17:03:42 -0500Ah Lori : you'll have realised maybe that I tried to put in some symbols in my original post that weren't recognised by the forum programme, just noticed ithttps://community.betfair.com/general_betting/go/thread/view/94082/23531894/excel-help-please?post_id=420817718#420817718Ah Lori : you'll have realised maybe that I tried to put in some symbols in my original post that weren't recognised by the forum programme, just noticed itSun, 14 Mar 2010 16:58:40 -0500Incredibly I had to do this a few days ago.as usual, it's a botch job that others will improve on.There's a function "Isnumber" that allows you to get rid of the NA stuff.....So I somehow built a new column so I only had numbers or blanks =IF(isnumbehttps://community.betfair.com/general_betting/go/thread/view/94082/23531894/excel-help-please?post_id=420817714#420817714Incredibly I had to do this a few days ago.as usual, it's a botch job that others will improve on.There's a function "Isnumber" that allows you to get rid of the NA stuff.....So I somehow built a new column so I only had numbers or blanks =IF(isnumbeSun, 14 Mar 2010 16:47:48 -0500Can someone tell me how to ignore #N/A in Rank function??Can't see anything specific to rank on the net, and I cant work out where to put the "#N/A"Thanks!https://community.betfair.com/general_betting/go/thread/view/94082/23531894/excel-help-please?post_id=420817710#420817710Can someone tell me how to ignore #N/A in Rank function??Can't see anything specific to rank on the net, and I cant work out where to put the "#N/A"Thanks!Sun, 14 Mar 2010 16:39:57 -0500