Holly has attended:
PowerPoint Intermediate Advanced course
Power Automate Introduction course
Getting a filter to work on a dynamic table of data
Hi,
I've a table of data that has sumproducts etc that change based on drop down fields. I then have a column that calculates if there is a variance between 2 columns of the data being summarised (returning Y or N). I can filter on variance Y but when I change any of my dynamic dropdowns the filter is no longer relevant. Is there a way to set my Y/N filter to change dynamically also? I can send an example spreadsheet if needed.
RE: Getting a filter to work on a dynamic table of data
Hi Holly,
Thank you for your question. I have an idea that Excel's new FILTER function might work here.
If you could attach and send some sample data to
info@stl-training.co.uk
I could have a look to see if it will work.
I will look out for your email.
Kind regards
Marius Barnard
STL
