Forum Discussion

Copper Contributor

Aug 16, 2023

Duplicate Row if any data in particular cell

Hello, I have a spreadsheet of books. Roughly 3000 rows. Columns A to E are ISBN, Author etc. Columns F to N are Barcodes. Not all cells have barcodes. If the title has one copy then there ...

excel

office 365

mathetes

Silver Contributor

Aug 16, 2023

crankcaller

Sorry if this is too much info - I've been at this a while today and my head is fried!

I understand. Reading what you've written, my head is spinning. But I have a question, based on the following two statements:

I wish to scan the ISBN and barcode from each physical item into a file. This will give me the correct info.
I then wish to compare that to the system and original spreadsheet.

Once you have the correct info, after scanning each physical item, what's the purpose of comparing with the system and the original spreadsheet? You have the correct info; why not stop there? What additional value is achieved by comparing the correct info with info you know not to be fully reliable?

crankcaller

Copper Contributor

Aug 16, 2023

As I typed my previous response I realised that myself. I would like to know if they are all wrong - or what percentage. If they are all wrong then a new load will be required which will cost money. If it's say 25% of items then staff can manually alter the records.

mathetes
Silver Contributor
Aug 16, 2023
So you seem to be suggesting that the records--official library records?--won't automatically get corrected by the scanning process; is that right? There still seem to be a lot of moving parts here, and it's difficult to get the full picture "remotely."