New Posts For Thread: Excel question...https://community.betfair.com/general_betting/go/thread/view/94082/23869762/excel-questionIs there anyway to use the large function in combination with filters like you can with subtotal?Or in English, how do you find the best X results in a sample of data.Seems the easiest way is filtering with subtotalsFirst filter the player, then in the column that has the data X in you requirefilter, click select all, so no check boxes are tickedAnd if you want the highest figures scroll to the bottom and if you whttps://community.betfair.com/general_betting/go/thread/view/94082/23869762/excel-question?post_id=430334442#430334442Seems the easiest way is filtering with subtotalsFirst filter the player, then in the column that has the data X in you requirefilter, click select all, so no check boxes are tickedAnd if you want the highest figures scroll to the bottom and if you wSat, 17 Apr 2010 12:11:23 -0500Your right I work on it a bit morehttps://community.betfair.com/general_betting/go/thread/view/94082/23869762/excel-question?post_id=430334438#430334438Your right I work on it a bit moreSat, 17 Apr 2010 07:52:31 -0500If your data is in column C starting at row 6After you have filtered, your answers (sum,average etc) will be in the subtotal=SUBTOTAL(3,OFFSET($C$6,0,0,COUNT(OFFSET($C$6,0,0,9999)),1))https://community.betfair.com/general_betting/go/thread/view/94082/23869762/excel-question?post_id=430334434#430334434If your data is in column C starting at row 6After you have filtered, your answers (sum,average etc) will be in the subtotal=SUBTOTAL(3,OFFSET($C$6,0,0,COUNT(OFFSET($C$6,0,0,9999)),1))Sat, 17 Apr 2010 07:49:37 -0500filter numbers, top 10 then a box pops up and change to to 5 or top 15That filter has preference over every other filter so it returns the top X items and ties of the entire data rather than for the specific player.https://community.betfair.com/general_betting/go/thread/view/94082/23869762/excel-question?post_id=430334430#430334430filter numbers, top 10 then a box pops up and change to to 5 or top 15That filter has preference over every other filter so it returns the top X items and ties of the entire data rather than for the specific player.Sat, 17 Apr 2010 07:47:08 -0500Why not use just the filters thenFilter for the player thenfilter numbers, top 10 then a box pops up and change to to 5 or top 15or whatever you rquirehttps://community.betfair.com/general_betting/go/thread/view/94082/23869762/excel-question?post_id=430334426#430334426Why not use just the filters thenFilter for the player thenfilter numbers, top 10 then a box pops up and change to to 5 or top 15or whatever you rquireSat, 17 Apr 2010 07:40:40 -0500If you wanted to see what the actual numbers are Put a sequence numbers from 1 to whatever in a separate column (say column D)Put this in another column and fill down for number required=LARGE(Data,D1)https://community.betfair.com/general_betting/go/thread/view/94082/23869762/excel-question?post_id=430334422#430334422If you wanted to see what the actual numbers are Put a sequence numbers from 1 to whatever in a separate column (say column D)Put this in another column and fill down for number required=LARGE(Data,D1)Sat, 17 Apr 2010 07:32:42 -0500When you filter data and use the subtotal function only the filtered data is used in the summation where as with other sum functions it takes all data in the range even if it's been filtered.Every formula you gave me, as well as the ones I've tried ghttps://community.betfair.com/general_betting/go/thread/view/94082/23869762/excel-question?post_id=430334418#430334418When you filter data and use the subtotal function only the filtered data is used in the summation where as with other sum functions it takes all data in the range even if it's been filtered.Every formula you gave me, as well as the ones I've tried gSat, 17 Apr 2010 07:25:03 -0500This formula does the same ~ enter as an array formula=AVERAGE(LARGE(C6:C20,ROW(INDIRECT("1:5"))))=AVERAGE(LARGE(Data,ROW(INDIRECT("1:5")))) ~ Data being C6:C20 as aboveAs with Subtotals you can use average,sum etchttps://community.betfair.com/general_betting/go/thread/view/94082/23869762/excel-question?post_id=430334414#430334414This formula does the same ~ enter as an array formula=AVERAGE(LARGE(C6:C20,ROW(INDIRECT("1:5"))))=AVERAGE(LARGE(Data,ROW(INDIRECT("1:5")))) ~ Data being C6:C20 as aboveAs with Subtotals you can use average,sum etcSat, 17 Apr 2010 07:11:43 -0500Not sure what you require so I am guessing ~You can do a sum of data in an array formula like ~{=SUM(LARGE(Data,{1,2,3,4,5,6,7,8,9,10}))}This formula sums the 10 largest values in a range called Data.If you you only wanted to sum odd LARGEST ~{=SUM(Lhttps://community.betfair.com/general_betting/go/thread/view/94082/23869762/excel-question?post_id=430334410#430334410Not sure what you require so I am guessing ~You can do a sum of data in an array formula like ~{=SUM(LARGE(Data,{1,2,3,4,5,6,7,8,9,10}))}This formula sums the 10 largest values in a range called Data.If you you only wanted to sum odd LARGEST ~{=SUM(LSat, 17 Apr 2010 06:43:30 -0500Is there anyway to use the large function in combination with filters like you can with subtotal?Or in English, how do you find the best X results in a sample of data.https://community.betfair.com/general_betting/go/thread/view/94082/23869762/excel-question?post_id=430334406#430334406Is there anyway to use the large function in combination with filters like you can with subtotal?Or in English, how do you find the best X results in a sample of data.Sat, 17 Apr 2010 06:10:20 -0500