https://community.betfair.com/general_betting/go/thread/view/94082/25643681/excel-help-pleaseIn excel if you have a column of values, some positive, some negative, is there a way of doing a formula in another cell elswhere on the same sheet to decide if the last value in the column is negative.additional information :- in the column of valuehttps://community.betfair.com/general_betting/go/thread/view/94082/25643681/excel-help-please?post_id=462245269#462245269thanks very muchTue, 17 Aug 2010 05:07:47 -0500https://community.betfair.com/general_betting/go/thread/view/94082/25643681/excel-help-please?post_id=462245041#462245041G3: =if(G2>0,"positive","negative")Tue, 17 Aug 2010 05:03:55 -0500https://community.betfair.com/general_betting/go/thread/view/94082/25643681/excel-help-please?post_id=462244681#462244681Say the populated column is column H, numbers start in cell H5 and continue down.Let's do the formulas in column GG1: =count(H5:H50000) .. counting the numbers in the columnG2: =offset(H5,G1-1,0) .. getting the last value in the columnG3: =if(G3>0,Tue, 17 Aug 2010 04:58:20 -0500https://community.betfair.com/general_betting/go/thread/view/94082/25643681/excel-help-please?post_id=462243037#462243037In excel if you have a column of values, some positive, some negative, is there a way of doing a formula in another cell elswhere on the same sheet to decide if the last value in the column is negative.additional information :- in the column of valueTue, 17 Aug 2010 04:29:19 -0500