Hi - just wondered if anyone can help me with filtering list information.
I've got a worksheet that will show a place in column B (from a Data Validation list - list is in Sheet 2), and then I want to filter column C to only list asset ID's that belong to that place (all assets are listed in sheet 2 with the places), for example, if I select Albertson Avenue as my place name, in column C, the list that would show would be all assets belonging to Albertson Avenue.
Is this possible using a formula? I've attached a copy of my spreadsheet for your information - please note that the data in sheet 2 is a lot less than there should be as I had to reduce this to reduce the file size!
Thanks!
Emma
Bookmarks