We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
17 Aug 10
10:29
Joined:
Date Joined:
22 Mar 04
In 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 values, the values go from row 1 to some row in which the last value appears. After the last value, all the cells in that column are blank but the column of values does increase on a daily basis.
additional information :- in the column of values, the values go from row 1 to some row in which the last value appears. After the last value, all the cells in that column are blank but the column of values does increase on a daily basis.
Show More
Say the populated column is column H, numbers start in cell H5 and continue down.
Let's do the formulas in column G
G1: =count(H5:H50000) .. counting the numbers in the column
G2: =offset(H5,G1-1,0) .. getting the last value in the column
G3: =if(G3>0,"positive","negative") .. obvious
you can also put all formulas in one:
=IF(OFFSET(H5,COUNT(H5:H50000)-1,0)>0,"positive","negative")
Let's do the formulas in column G
G1: =count(H5:H50000) .. counting the numbers in the column
G2: =offset(H5,G1-1,0) .. getting the last value in the column
G3: =if(G3>0,"positive","negative") .. obvious
you can also put all formulas in one:
=IF(OFFSET(H5,COUNT(H5:H50000)-1,0)>0,"positive","negative")
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539