Move data to next cell and Replace this cell with a word

[Asheesh]

Hi All,

Require your help.. please see the attached

I have explained the issue in the file..

I know this can be done using macros but it being once off activity, i dont want to write codes...so thought you guys might have a formula or may know a quick way out..

Regards
Asheesh

 

[Somendra Misra]

Hi Asheesh,

See the file.

Regards,

 

[Asheesh]

Hi Som....

Thanks a lot mate...that was really cool..

Regards
Asheesh

 

[Khalid NGO]

Hi Asheesh,
See if it helps:

=IF(B2="b",IF(AND(B$1=H$1,B2="b"),"Open","N/A"),B2)

in H2, Copy down and across.
Regards,

 

[Asheesh]

Thanks Khalid...I already used Som's suggestion...but I am sure even your solution would be right...