May 09 2023 10:30 AM
I want to create a spreadsheet to keep control of a machine's parts which some have the same part number but different serial numbers and they are constantly swapped. (one part is installed then replaced, then re-installed). Basically I wish to control whether a part is installed or not and the dates it was installed/removed.
May 09 2023 10:58 AM
Could you follow the guidelines in Welcome to your Excel discussion space! and provide at least:
- Excel version + OS
- A screenshot of what you have & what you expect. Idealy upload & share a representative workbook
May 09 2023 11:44 AM
May 09 2023 02:00 PM
I formed a table with a row for each distinct S/N to show its status. On reflection I do not think that is necessarily what you are looking for.