Hi,
I am using =OFFSET('IB BRANCHES'!$B$2,0,0,COUNTA('IB BRANCHES'!$B:$B)-1,1), but when I am entering any duplicate field, its showing on the Data Validation List. Can I modify the formula to prevent the duplicates from showing on the Validation List.
Please let me know.
I am using =OFFSET('IB BRANCHES'!$B$2,0,0,COUNTA('IB BRANCHES'!$B:$B)-1,1), but when I am entering any duplicate field, its showing on the Data Validation List. Can I modify the formula to prevent the duplicates from showing on the Validation List.
Please let me know.