Hi Guys,
I have a spreadsheet with thousands of image names, which contains the product code. I have managed to combine the image names into one row, but am sitting with up to 20 rows of image names per product due to the process used.
I need to only use the line with the most amount of image names per product, indicated by the highest number per product in Helper 3.
In other words use the highest number per product in Helper 3 and extract that corresponding information out of Helper 4.
I hope this makes sense. Attached is a sample with the highlighted information I need to extract.
Bookmarks