Counting Duplicated Content
I have compiled the files from a server into a single data sheet. I want to check the server as a whole for duplicated content (based on the file name). I am trying to expand the forumal I am currently using "=if(countif(c:c,c2)>1,e2,0)" to include a check against both the date and folder name.
I only want to count the content as "duplicated" if it is within the same folder.
Also, I only want the formula to "count" all but the most recent files (as illustrated in the "desired duplication results" column).
Any help will be very appreciated. Thank you.
So you want if the file name AND the folder AND the date are the same, then return the file size? In your small example, you would get no matches.
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
I want file name and folder to be the same.
I want to ignore the most recent version of the file (thus counting the older versions as "duplicated")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks