LinkBack URL
About LinkBacks
The following formula returns the values posted in column C:Formula:
=IF(IFERROR(AGGREGATE(14,6,ROW(B$1:B1)/(B$1:B1<=-50),1),0)>IFERROR(AGGREGATE(14,6,ROW(B$1:B1)/(B$1:B1=0),1),0),A1*10,A1)
Let us know if you have any questions.
The following formula returns the values posted in column C:Formula:=IF(IFERROR(AGGREGATE(14,6,ROW(B$1:B1)/(B$1:B1<=-50),1),0)>IFERROR(AGGREGATE(14,6,ROW(B$1:B1)/(B$1:B1=0),1),0),A1*10,A1)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks