dynamic named range

Hello, 

I have two columns, Name and Tag

Name    Tag

AAA

BBB       Yes

CCC

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 *