Hi.I have two columns of numbers similar to that below in Excel.1 -62 -53 -34 -15 16 47 78 9I need to know a formula that will display the value in column A, when the value in column B turns to a positive (in this example, 5).Any ideas?
The value of what in column A?I see that your 5th row is positive so what value appears in column A?Koing
the numbers in the first column always be the same?Will the numbers in the second column always be Ascending?Will the numbers in the second column always begin with a negative number at the top?Regards,Simsy
i seem to recall from my ecdl training that the 'if' function would appear to meet your needs?johnny.
and the solution was?johnny.
This thread is now locked and can not be replied to.
Galaxy Note 8 vs iPhone X
Awful clip art from 1994 is being tweeted every hour by a bot
iPhone X vs Samsung Galaxy Note 8
Les meilleurs navigateurs internet 2017
© Copyright 2017 IDG UK. All Rights Reserved.