This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have 2 large spreadsheets of data with ~40 columns each. (essentially a before/after look at data) The columns are identically named/positioned. I'd like to create a workflow that compares all data for a given row in spreadsheet 1 with spreadsheet 2. The rows in each spreadsheet may not be the same. (i.e. row 5 in spreadsheet 1 might actually match row 7 in spreadsheet 2).
I thought I'd be able to do this relatively easily but I'm a bit of a novice and this is proving more difficult than I thought. I'm hoping that this is easy as I think it is but would appreciate any guidance you can provide.