Column Data Comparison Count

[Ravi Rajendran]

Hi Guys...

i need some help with getting comparison count by comparing 6 different weeks status columns against the most recent week status. trying to figure out a simple way to find out how long the status has existed. pls see attachment.

i hope some guidance on this will be very helpful. thanks in advance.

Many thanks
Ravi

 

[prasaddn]

Hi Ravi,

See if this formula helps in H2, if yes, drag down the same:

=COUNTIF(B2:G2,G2)

Regards,
Prasad DN

 

[Ravi Rajendran]

Hello Prasad, thank you so much for this.
It was simple and very helpful.

Regards,
Ravi

 

[Ravi Rajendran]

One small trouble i noticed with my data just now is that.... the order of status from Not Started > In Progress > Completed can sometimes be jumbled which i didn't cover in my the scenario earlier.

Prasad's suggestion works just as perfect & fit if order of status is maintained.
Any suggestions on whether i can count only the similar status only from the previous columns?

ex:
Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Duration
Not Started Not Started In Progress Not Started Not Started Not Started 3 Wks

Sorry! any suggestions are highly appreciated.

Regards,
Ravi