Hi to All,
My example excel file is attached and details of my request is described inside. I need a few formulas which are checking multi values and skip to use duplicates in seperate Named Ranges. I also need to build Data Validations that blanks cells in Named ranges are removed. Please refer to attached file for further information.
Thanks in advance for kindest prompts.
Bookmarks