Good morning all!
I was wondering if someone can help me with a formula:
Logic: Add 1 to the last value that is greater than zero. So, for A5, the value should be 3 (A3+1)
Example:
A1 1
A2 0
A3 2
A4 0
A5 ?
Thank you,
Ghie
Good morning all!
I was wondering if someone can help me with a formula:
Logic: Add 1 to the last value that is greater than zero. So, for A5, the value should be 3 (A3+1)
Example:
A1 1
A2 0
A3 2
A4 0
A5 ?
Thank you,
Ghie
Formula:Please Login or Register to view this content.
Is that what you need?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Yes but how can I combine these 2 formulas?
=IF($A1=TRUE,"1","0")
So basically there's another field that has a 0 and 1. If true return with 1 otherwise 0 then your formula would come to play after that. Does it make sense?
Maybe
=IF(A2= TRUE, MAX($A$1:$A1)+1, 0)
You'd need to start your data in A2 so that the MAX function can look at previous rows.
thank you very very very much!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks