As i shall enter the heading name then his previous results should reflect in another column

[Ram Mher]

Dear Friends

Greetings !

As I shall enter the duplicate entry for a name then all his previous results should reflect in another column.

Detail sheet is attached for reference.

 

[Naresh Yadav]

Hi,

pls check highlighted formula in D column in excel attachment if it is ok for you.finish the formula with CTRL+Shift+Enter

 

[Ram Mher]

Dear

Hi,

pls check highlighted formula in D column in excel attachment if it is ok for you.finish the formula with CTRL+Shift+Enter

Dear Friend

Thanks a lot for nice cooperation.

Absolute reference is assigned therefore formula is not working in downward cells.

 

[Ram Mher]

De

Dear


Dear Friend

Thanks a lot for nice cooperation.

Absolute reference is assigned therefore formula is not working in downward cells.

Also formula is providing "blank" result if numeric value is inserted in column B