Formula Condition based status update

[Dharmesh Kumar Srivastava]

I have "8 Step" wise cell, now I want to put any value in 1- step to 8- step then my status is "complete"
if I update the value in any mid of step that step are show in status…(like given exmpl)

date are less then & greater than both way are coming

[Mohit Sharma]

Hi Dharmesh,

Pfa..

[Dharmesh Kumar Srivastava]

Thanks Mohit..

But I want to put STEP name in status... which step is done after complete all step its show complete.

[Lovedeep sharma]

Hello Dharmesh,

please find below formula

=IF(COUNTA(B6:I6)=0,"NA",IF(COUNTA(B6:I6)>=8,"Complete",INDIRECT(ADDRESS(5,COUNTA(B6:I6)+1))))

[Dharmesh Kumar Srivastava]

Hello Dharmesh,

please find below formula

=IF(COUNTA(B6:I6)=0,"NA",IF(COUNTA(B6:I6)>=8,"Complete",INDIRECT(ADDRESS(5,COUNTA(B6:I6)+1))))

INDIRECT(ADDRESS(5,COUNTA(B6:I6)+1))))

Lovdeep can plz little bit brief over the INDIRECT use... I m little confuse of INDIRECT use..

[Lovedeep sharma]

Indirect is useful when you want to convert a text value into a valid cell reference.
For example, formula =INDIRECT(ADDRESS(5,COUNTA(B6:I6)+1)) will always refer last entry field name

[Dharmesh Kumar Srivastava]

and whats about the "ADDRESS(5"

I can't understand use of "5" if its row no so plz explain...
mai samjh nhi paya ki yha pr aap ne 5 kyo use kiya h

[Lovedeep sharma]

Please find attached SS

[HARIOMSINGH]

PFA...