dynamic named range


I have two columns, Name and Tag

Name    Tag


BBB       Yes


DDD      Yes       


I want formula which will create Named range where TAG = “Yes”

So In this example, Name Ranged would be TAG1 = BBB, DDD

I have thousands of rows and aginst them having 4 different TAG , so I would like to create 4 named range which is dynamic in range as this TAG is forumula and it will change as per the conditions.

By: PP

Leave a Reply

Your email address will not be published. Required fields are marked *