Hello
We have an inventory program that we use in our library to check for lost books. But I was wondering if we could use the spreadsheet results as a way to check that books were correctly shelved. The columns of interest are the call number column and the other is the time inventoried.
The time inventoried includes the year month day minute and second the item was inventoried. The call number field has the Dewey call number (e.g., 813.5 M4505 1990, 813.5 M5046 2016).
Assuming workers scan books exactly as they are arranged on the shelves, I wanted to arrange results by one of the two columns, probably by call number, and somehow an inserted formula would flag individual cell results in the other column if it was not in numerical order down to the second. How could I do that?
We have an inventory program that we use in our library to check for lost books. But I was wondering if we could use the spreadsheet results as a way to check that books were correctly shelved. The columns of interest are the call number column and the other is the time inventoried.
The time inventoried includes the year month day minute and second the item was inventoried. The call number field has the Dewey call number (e.g., 813.5 M4505 1990, 813.5 M5046 2016).
Assuming workers scan books exactly as they are arranged on the shelves, I wanted to arrange results by one of the two columns, probably by call number, and somehow an inserted formula would flag individual cell results in the other column if it was not in numerical order down to the second. How could I do that?
