Forum Discussion
RSS_202260
Aug 12, 2022Copper Contributor
Excel database: services and service providers
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...
- Aug 15, 2022A very simple way is to have a small table which as only two columns:
Name Service
In the Name column you enter the name of a person and in the Service column you enter that person's service. Then if a person provides another service, add an additional row for that person. Enter the name in the name column and the service in the service column:
Name Service
Craig Lawn moving
Craig Dog walking
Craig House cleaning
Mary Dog walking
John Lawn moving
John Dog walking
Select any cell in this table and choose "Insert, Table" from Excel's menu.
Now you can use the filter drop-downs to filter for name, or to filter for service.
albertrowanhenry
Oct 04, 2024Copper Contributor
Thanks it helpfulhttps://www.pearllemoncleaners.co.uk/