freeze cells in filter

[barbora_smieskova]

Hi all,

I would like to ask you a question. I have one table in which I have two "general filters" (first is ditribution channel and the second is ***). Next to this one table I want to make some check using excel functions like min, max and so on. Is it possible to reffer on one distribution channel for example TA and *** male, and than TA and *** female that way the numbers will be freeze (I mean ....so when I choose TA and male, there will be this walues and than I change filter on female and male walues not change to female)?

Thank you for your help

[davesexcel]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[barbora_smieskova]

Hi,

This is example file. I just want to know if it is possible to reffer on "same rows" in different tables and concurrently use filter. You know what I mean ?

Thanks for help