Comparing Spreadsheets
February 14, 2012 7:53 AM Subscribe
Subtracting 2 sheets in LibreOffice Calc
I have 2 sheets (can be 2 separate documents if that makes it easier)
I need to remove all rows from sheet 1 that exist in sheet 2 (each row has only 1 column). The only thing I've found from googling seems to expect the values in sheet 2 that would match sheet 1 to be in the same row... eg. it compares sheet1 a1 with sheet 2 a1. I need to compare a1 in sheet 2 with every row in sheet 1 and delete if its found.
I hope this makes sense
I have 2 sheets (can be 2 separate documents if that makes it easier)
I need to remove all rows from sheet 1 that exist in sheet 2 (each row has only 1 column). The only thing I've found from googling seems to expect the values in sheet 2 that would match sheet 1 to be in the same row... eg. it compares sheet1 a1 with sheet 2 a1. I need to compare a1 in sheet 2 with every row in sheet 1 and delete if its found.
I hope this makes sense
« Older How much notice is required when leaving a... | Tell me - what will surgery be like? Newer »
This thread is closed to new comments.
You need to compare cell A1 in sheet 2 with every row in sheet 1?
posted by hot soup at 11:06 AM on February 14, 2012