Forum Discussion
Solved
Data organisation puzzle - creating a bespoke list from 3 criteria - read from a single set of data
Morning All! A "nearly Merry Xmas" to all members 🙂 I am seeking a little help, please. I have a set of data that identifies "Employees", their "Department" and their delegated financial "A...
It should be possible to do this using the FILTER function, but for some reason I couldn't get it to work.
So here is a solution using VBA which should work in all (desktop) versions of Excel. You'll have to allow macros when you open the workbook.
It should be possible to do this using the FILTER function, but for some reason I couldn't get it to work.
So here is a solution using VBA which should work in all (desktop) versions of Excel. You'll have to allow macros when you open the workbook.