Apr 09 2020 07:43 PM
Hi all,
I have an excel sheet some cells have picture others don't is there a quick way to sort or filter the items which have pictures?
Thanks in advance.
Apr 09 2020 08:38 PM
Apr 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).
Apr 09 2020 09:03 PM
First of all thanks for your replay. Yes, I tried with the filter but I have nothing to sort with. I’m attaching part file perhaps it is more useful it. The file itself contains around 20,000 rows so it is quite time-consuming.
Apr 09 2020 09:12 PM - edited Apr 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.
Apr 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.
Apr 09 2020 09:29 PM
Apr 09 2020 10:47 PM