Forum Discussion
Help!
Okay so I seem to be going round in circles (literally). I have an 'Input Sheet' to track holiday requests, when this request goes in, it has to be prioritised into which team gets asked to cover it ...
Creating a FILTER formula might be the way to go but it's difficult to draw one up without seeing the data or a scaled down sample workbook.
Patrick2788 thanks for the reply, the problem with the filter function is that it will be filtering 3000 rows between 5 separate sheets so it slows the sheet down significantly. I will try to get a sample made up to attach at some point.
If you have access to VSTACK, you could 3D stack then FILTER.