Getting error 'false'

[mso3]

Hi friends,

If the value in column 'D' is greater than previous value then I want a serial number start from 1. I'm getting formula error 'False' for each first greater value in column 'A'. The number 1 skips 1 entry showing 'False'.

Any help will be highly appreciated.

Thanking you in anticipation.

[Jonmo1]

Try this in A5 and filled down.

=COUNTIF(D$5:D5,D5)

[mso3]

Hi Jonmo1,

Perfect! Thank you.

[Jonmo1]

You're welcome.

Just FYI on what was happening with your formula.

First, FALSE is NOT an error. It's just the opposite of True, means a conditional expression was FALSE.

So take the first FALSE you see, in A12
=IF(D12="","",IF(D12>D11,A11=1,IF(D12>D11,A11,A11+1)))

D12 is NOT "", so it moves to
IF(D12>D11, this was TRUE, so it then moved to
A11=1, this is also an expression asking if A11 is equal to 1
Which was FALSE, so the formula returned FALSE

I think you probably meant that to be
=IF(D12="","",IF(D12>D11,1,IF(D12>D11,A11,A11+1)))

Hope that helps.

[mso3]

Thank you for explanation of the formula. I agree with you and one more drawback of my formula that after entering the title in row 4 it gives error '#value'.

Yours working fine after entering the title in row 4.

Thank you and have a nice time.