Excel 2010 filtering dynamic
I have a large data table that has dates across the top. This has filters turned on. I need to sort this data (Largest to smallest) based on the date entered into a user defined field. But I dont know how to make this dynamic. Any help please
I have a large data table that has dates across the top. This has filters turned on. I need to sort this data (Largest to smallest) based on the date entered into a user defined field. But I dont know how to make this dynamic. Any help please
with a header name across each column select any one and press Alt+D, F, F and your dynamic filters will be applied. Pressing same sequence turns them off. Then choose the drop down choices for each column with ascending and descending and filter ranges or custom
ReplyDelete