Is there a way to make a referance the filter text applied to a table? For example I have an orders table filtered by customer name. I want to know by which customer the table is filtered and i need to show it on cell F1 which is outside the table. I want F1= [orderstable].currentfiltertext. In this case currentfiltertext is also the value of the first visible customer column. But there is no way to know which row is the first visible row when a filter is applied.

For example If the user applies the filter customer=Bruce then row 5 becames the first visible row

then: index([orderstable],1,1) always gives the first value which is Tom. If only I knew that row 5 is the first visible row index([orderstable],5,1) gives the correct answer.

Orders table
1 A=Customer B=Date C=product
2Tom ...........
3Tom ...........
4Hank ............
5Bruce ..............
6Hank ...............
7Bruce ............