Show only what is filtered

[benntw]

I am having a simple formula kicking my butt. I have a table called Scopes. The table header starts in A2. What I need is a formula to return the value of what is filtered in the column Scope Name. Thank you in advance

 

[SanjayGMusafir]

Check this and revert - This has some possible solution to your situation.

Set filtered column in a table as a defined range

Trying to see if it is possible to filter a column in a table and defined those visible filtered cells as a named range to copy to another range in another table (different workbook). Right now, I'm just curious to know how to name a filtered column range to use further down in my code. Let's...

www.mrexcel.com

 

[benntw]

Check this and revert - This has some possible solution to your situation.

Set filtered column in a table as a defined range

Trying to see if it is possible to filter a column in a table and defined those visible filtered cells as a named range to copy to another range in another table (different workbook). Right now, I'm just curious to know how to name a filtered column range to use further down in my code. Let's...

www.mrexcel.com

I appreciate it. That one did not work for this situation. I am looking to return only the value that is showing when the table is filtered. For what I am doing it will always be just one value showing for a dynamic result.

 

[Fluff]

How about

=TAKE(FILTER(Scopes[Scope Name],BYROW(Scopes[Scope Name],LAMBDA(br,SUBTOTAL(3,br)))),1)

 

[benntw]

How about

=TAKE(FILTER(Scopes[Scope Name],BYROW(Scopes[Scope Name],LAMBDA(br,SUBTOTAL(3,br)))),1)

As always , you rock Fluff ! Works perfect ! Thank you very much

 

[Fluff]

You're welcome & thanks for the feedback.

 

[smozgur]

As always , you rock Fluff ! Works perfect ! Thank you very much

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.