R Ram Mher Member Aug 24, 2017 #1 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. Attachments Previous results to be guided.xlsx 8.2 KB · Views: 4
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.
N Naresh Yadav Active Member Aug 24, 2017 #2 Hi, pls check highlighted formula in D column in excel attachment if it is ok for you.finish the formula with CTRL+Shift+Enter Attachments Previous results to be guided.xlsx 8.6 KB · Views: 7
Hi, pls check highlighted formula in D column in excel attachment if it is ok for you.finish the formula with CTRL+Shift+Enter
R Ram Mher Member Aug 24, 2017 #3 Dear Naresh Yadav said: Hi, pls check highlighted formula in D column in excel attachment if it is ok for you.finish the formula with CTRL+Shift+Enter Click to expand... Dear Friend Thanks a lot for nice cooperation. Absolute reference is assigned therefore formula is not working in downward cells.
Dear Naresh Yadav said: Hi, pls check highlighted formula in D column in excel attachment if it is ok for you.finish the formula with CTRL+Shift+Enter Click to expand... Dear Friend Thanks a lot for nice cooperation. Absolute reference is assigned therefore formula is not working in downward cells.
R Ram Mher Member Aug 24, 2017 #4 De Ram Mher said: Dear Dear Friend Thanks a lot for nice cooperation. Absolute reference is assigned therefore formula is not working in downward cells. Click to expand... Also formula is providing "blank" result if numeric value is inserted in column B
De Ram Mher said: Dear Dear Friend Thanks a lot for nice cooperation. Absolute reference is assigned therefore formula is not working in downward cells. Click to expand... Also formula is providing "blank" result if numeric value is inserted in column B
