Aug 12 2022 08:02 AM
At our small society, we have members, who both use and supply services. The software we use is ancient (UNIX), so I'm trying to extract data for use in Excel 2016.
To give an example of what I'm trying to do, let's say the services are lawn mowing, dog walking and house cleaning. Not all members supply all services.
Craig provides all three.
Mary only walks dogs.
John walks dogs and mows lawns.
I don't even know what this would look like in Excel, but effectively I'd like to be able to do two things...
1. Type/click on a member and see the list of services they provide e.g. input "Mary" to get the result "dog walking".
2. Type/click on a service title and see a list of members that provide them e.g. input "lawn mowing" to get the results John and Craig.
I don't even know how I would use a search engine to find the answer to this, so any help much appreciated!
Aug 15 2022 07:46 AM
SolutionAug 15 2022 08:39 AM
Thank you very much! That's a nice neat solution and very simple to create. I really appreciate that you took the time to respond - having the data searchable like that will make my life much easier!
Aug 15 2022 08:40 AM
Aug 15 2022 07:46 AM
Solution