I'm trying to create a way so that new values are listed in a separate column.
If the value of FA(X) is equal to nothing, then nothing, otherwise display the number that corresponds to where it sits in the list.
In FB, if the value does equal to where it sits, then the count starts there (with a value of "1"). As we go down, the next would be a value of "2".
The formula in FB11 is: =IF(FA11<>E11,FB$7,SUM(FB$7:FB10+1)).
In the example shown, the value that SHOULD be in FB11 is "1", not "4". It's counting the "0's" as "1".
Subsequently, the next that SHOULD have a value is FB14 with a value of "2", not "11".
The formula in FB14 is: =IF(FA14<>E14,FB$7,SUM(FB$7:FB13+1)).
What I'm trying to do is get a column (which will likely be FC) that has listing/count from the small(k-th) of the new-found values, 1- however many there ends up being.
Why is this counting the "0's" as ones???
Thank you.
If the value of FA(X) is equal to nothing, then nothing, otherwise display the number that corresponds to where it sits in the list.
In FB, if the value does equal to where it sits, then the count starts there (with a value of "1"). As we go down, the next would be a value of "2".
The formula in FB11 is: =IF(FA11<>E11,FB$7,SUM(FB$7:FB10+1)).
In the example shown, the value that SHOULD be in FB11 is "1", not "4". It's counting the "0's" as "1".
Subsequently, the next that SHOULD have a value is FB14 with a value of "2", not "11".
The formula in FB14 is: =IF(FA14<>E14,FB$7,SUM(FB$7:FB13+1)).
What I'm trying to do is get a column (which will likely be FC) that has listing/count from the small(k-th) of the new-found values, 1- however many there ends up being.
Why is this counting the "0's" as ones???
Thank you.