I have a spreadsheet with a list of inventory. One of the columns has a file path for the picture of the particular item. Some items have multiple images and I have to change the file path slightly. The inventory is MTG cards. So what I have so far is:
Column B is the name of the card. It is also the file name of the card image. In the case of multiple images it would be, "cardname"1, "cardname"2 and so on.
Column C is the edition the card is from. It is also the subfolder the card images are in.
Column AN holds the image path.
The formula I'm using now is:
="C:\Program Files (x86)\Gatherer Extractor\pics\"&C2&"\"&B2&".full.jpg"
What I need is: When there are duplicate values in both column B and C, meaning same card from the same set with alternate pictures, I need excel to count them and put the corresponding number at the end of the file name. For example, one card is named Basal Thrull. There are 5 cards with that name. 4 of them are from the same set and have alternate images. So, excel needs to see the repeated name AND edition code, count the order each one is in and add it to the file name. So the first Basal Thrull out the 5 of them will return a file path of:
C:\Program Files (x86)\Gatherer Extractor\pics\FE\Basal Thrull1.full.jpg ("1" at end of file name)
The next will return:
C:\Program Files (x86)\Gatherer Extractor\pics\FE\Basal Thrull2.full.jpg ("2" at end of file name
And so on, untill the 5th one. The 5th one is from a different edition so that one should return to default:
C:\Program Files (x86)\Gatherer Extractor\pics\ME\Basal Thrull.full.jpg (no number in file name, different subfolder)
Bookmarks