Hello Everyone,
I have data in range C1:D30, in which column c contains customer details and in column D location. I have require a code to fill the blank cells with the maximum used location in the range.
For Example:- if I filter for Cus 1 in customer detail then blank cells should be filled by the maximum repeated location which is appearing in filtered range.
Thanks in advance
Anil Kumar
Bookmarks