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
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.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
As always , you rock Fluff ! Works perfect ! Thank you very muchHow aboutExcel Formula:=TAKE(FILTER(Scopes[Scope Name],BYROW(Scopes[Scope Name],LAMBDA(br,SUBTOTAL(3,br)))),1)
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.As always , you rock Fluff ! Works perfect ! Thank you very much