|
05-29-2015, 10:58 PM
|
|
Novice
|
|
Join Date: May 2015
Posts: 8
|
|
Thanks, Mandy, for your reply.
I have 1,000's of digital images scattered in different locations on my computer.Many are duplicates.Most have unique names but because of editing some have different file sizes.Usually my filename "prefix" changed after editing, but not always.Most are grouped in similar folders with similar names.My ultimate goal is to eliminate the duplicates and store in yearly folders & subfolders.
Roughly, I plan to copy 2 "similar" folders into a work folder, with the matching filenames getting a (2) suffix.Then use DOS (yes, DOS) command DIR |clip & paste into a text file, which will then be imported into Excel.
I want to compare file sizes and filename "prefixes".I'll do that by comparing fields in Row (n-1) & Row (n).For conflicts, I will look at the images to make a final decision.Actually, while typing this it dawned on me I probably should use Row (n) & Row (n+1).Row (1), not having (n-1) presented a problem.
Anyway, in the attached sheet, I inserted a "dummy" Row2 (after headers).I was able to use the same formula for each row.I couldn't however do it all in a single cell for a given row.Therefore, I use 3 columns.Cols D & E will be hidden and "ok" is shown only for testing.
I still had the problem of filling the entire column with the formulae.See solution at http://answers.microsoft.com/en-us/o...5-e57a921c1985
It looks like my original problem disappeared.It would still be cleaner if formulae in Cols D,E.F were combined.
|