hi all good people
i have a spreadsheet with over 27000 rows of data and 11000+rows of reference data
My reference data all unique, however some of the cells have a string that is similar for example
c/dog/001/01, c/dog/001/02, c/dog/001/03, c/dog/002/01, c/cat/001/01, c/cat/001/02...