frank265
New Member
- Joined
- Feb 5, 2013
- Messages
- 33
- Office Version
- 365
- Platform
- MacOS
Hi, I was hoping someone smarter than me might be able to help me with this excel conundrum...
I have some software which can look for duplicate images on a hard drive and then export the results into a csv file. As you will see from the spreadsheet below it pairs the duplicates into what it calls groups as shown in column A. So A1 and A2 are a close match in duplication and they are both found in the folder called NAS FILES on drive E. The results I am interested in is where there is a reference to a folder called Book Images. In that case I want to take the corresponding image in the matching group. As an example in row 30 and row 31, there is a match in Group 15 and the images are found in the folders Book Images and Web recipe images low res. I would like rows 30 and 31 (and all other matches like that) to be marked in the spreadsheet somehow so that they could be filtered and all other groups that do not contain the Book Images folder to be ignored. I hope this makes sense...
I have some software which can look for duplicate images on a hard drive and then export the results into a csv file. As you will see from the spreadsheet below it pairs the duplicates into what it calls groups as shown in column A. So A1 and A2 are a close match in duplication and they are both found in the folder called NAS FILES on drive E. The results I am interested in is where there is a reference to a folder called Book Images. In that case I want to take the corresponding image in the matching group. As an example in row 30 and row 31, there is a match in Group 15 and the images are found in the folders Book Images and Web recipe images low res. I would like rows 30 and 31 (and all other matches like that) to be marked in the spreadsheet somehow so that they could be filtered and all other groups that do not contain the Book Images folder to be ignored. I hope this makes sense...
| Recipe Dupes.xlsx | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Group Num | Picture Filename | Similarity | ||
| 2 | 1 | E:\NAS FILES\Jessica- Jul2017\0611_ljusare.jpg | 72 | ||
| 3 | 1 | E:\NAS FILES\Jessica- Jul2017\0611.jpg | 72 | ||
| 4 | 2 | E:\NAS FILES\Jessica- Jul2017\0633_ljusare.jpg | 74 | ||
| 5 | 2 | E:\NAS FILES\Jessica- Jul2017\0633.jpg | 74 | ||
| 6 | 3 | E:\NAS FILES\Jessica- Jul2017\0664_snabbfri-ko.jpg | 83 | ||
| 7 | 3 | E:\NAS FILES\Jessica- Jul2017\0664.jpg | 83 | ||
| 8 | 4 | E:\NAS FILES\Jessica- Jul2017\0674-ljusare.jpg | 69 | ||
| 9 | 4 | E:\NAS FILES\Jessica- Jul2017\0674.jpg | 69 | ||
| 10 | 5 | E:\NAS FILES\Jessica- Jul2017\0681_ljusare.jpg | 85 | ||
| 11 | 5 | E:\NAS FILES\Jessica- Jul2017\0681.jpg | 85 | ||
| 12 | 6 | E:\NAS FILES\Jessica- Jul2017\0701_ljjusare.jpg | 69 | ||
| 13 | 6 | E:\NAS FILES\Jessica- Jul2017\0701.jpg | 69 | ||
| 14 | 7 | E:\NAS FILES\Jessica- Jul2017\2540.jpg | 99 | ||
| 15 | 7 | E:\NAS FILES\Jessica- Jul2017\Glögg drink recept.jpg | 99 | ||
| 16 | 8 | E:\NAS FILES\Jessica- Jul2017\Glögg drink recept.jpg | 83 | ||
| 17 | 8 | E:\NAS FILES\Jessica- Jul2017\Glögg drink recept web .jpg | 83 | ||
| 18 | 9 | E:\NAS FILES\Jessica- Jul2017\jessica mörkgrön tröja utan fönster_ret.jpg | 86 | ||
| 19 | 9 | E:\NAS FILES\Jessica- Jul2017\jessica mörkgrön tröja utan fönster.jpg | 86 | ||
| 20 | 10 | E:\NAS FILES\Jessica- Jul2017\jessica mörkgrön tröja utan fönster.jpg | 86 | ||
| 21 | 10 | E:\NAS FILES\Jessica- Jul2017\jessica mörkgrön tröja.jpg | 86 | ||
| 22 | 11 | E:\NAS FILES\Jessica- Jul2017\jessica mörkgrön tröja.jpg | 76 | ||
| 23 | 11 | E:\NAS FILES\Jessica- Jul2017\jessica.jpg | 76 | ||
| 24 | 12 | E:\NAS FILES\Jessica Frej - receptbilder sommar för Web\0107.jpg | 100 | ||
| 25 | 12 | E:\NAS FILES\Jessica Frej - receptbilder sommar för Web\minipizzor med tryffelfeta.jpg | 100 | ||
| 26 | 13 | E:\Book Images\2018-02-09_2386.jpg | 85 | ||
| 27 | 13 | E:\Book Images\klassiska röror.jpg | 85 | ||
| 28 | 14 | E:\NAS FILES\Jessica- Jul2017\0611.jpg | 62 | ||
| 29 | 14 | E:\Web Recipe Images Low Res\Agghalvor-med-oliver.jpg | 62 | ||
| 30 | 15 | E:\Book Images\psari me fasolia 1 1.jpg | 82 | ||
| 31 | 15 | E:\Web Recipe Images Low Res\Black-eye-bonor-med-seabream.jpg | 82 | ||
| 32 | 16 | E:\Book Images\kalamarakia.jpg | 79 | ||
| 33 | 16 | E:\Web Recipe Images Low Res\Blackfisk-med-gronsaker-och-grilloumi.jpg | 79 | ||
| 34 | 17 | E:\Book Images\pizza xoriatiki.jpg | 80 | ||
| 35 | 17 | E:\Web Recipe Images Low Res\Bondpizza.jpg | 80 | ||
| 36 | 18 | E:\Book Images\psomia 1 1.jpg | 74 | ||
| 37 | 18 | E:\Web Recipe Images Low Res\Brod-fran-Xiliato.jpg | 74 | ||
| 38 | 19 | E:\NAS FILES\Jessica Frej - receptbilder sommar för Web\0092.jpg | 82 | ||
| 39 | 19 | E:\Web Recipe Images Low Res\Burgare-med-halloumi.jpg | 82 | ||
| 40 | 20 | E:\NAS FILES\Jessica- Jul2017\0701.jpg | 66 | ||
| 41 | 20 | E:\Web Recipe Images Low Res\Dadelbollar.jpg | 66 | ||
Sheet 1 - Recipe Dupes | |||||
