04-09-2020 07:43 PM
04-09-2020 08:38 PM
04-09-2020 08:51 PM
If the image fits within the cell, it might actually sort with the row @Drin365
Just click in cell B2, go to the DATA tab, and select the easy sort icon for Z to A and see what happens.
You can also click undo or close the file without saving if the results are not as expected.
Again, as I mentioned, if you want to control the sort of the picture you may need to do some kind of formula if you can. Unless the row count is low enough for you to eyeball it (I would wait until after you sort so the similar images are together).
04-09-2020 09:12 PM - edited 04-09-2020 09:14 PM
agreed on the filter @Drin365
In my test, data filters does not identify the picture/image.
I also tried a pivot table, still does not recognize the picture/image.
I take it back, sort did not work when sorting on the image. Darn. I must have had my mouse in A2. Sorry,
That's all I got.
04-09-2020 09:22 PM
ok one more question @Drin365
That's a lot of records and probably a lot of images.
I wonder about the source of the data.
Was it pulled from somewhere that might have the option to export additional data that might include some other field related to the image name, or anything like a flag that might identify the items/products that have images on file?
I cringe at the thought that someone sat there and hit copy and paste to line it up for each.
04-09-2020 09:29 PM
04-09-2020 10:47 PM
by Chris_Hafstein on June 02, 2020
by shotgun-68 on June 02, 2020
by MS Excel Team on May 29, 2019
by Olaf Hubel on January 23, 2018
by Brian Jones (OFFICE) on December 18, 2017