Forum Discussion

Drin365's avatar
Drin365
Copper Contributor
Apr 10, 2020

Sort/filter cells with picture

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.
excel
Drin365's avatar
Drin365
Copper Contributor
Apr 10, 2020

HCole718 

 

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.

HCole718's avatar
HCole718
Copper Contributor
Apr 10, 2020

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. 

Resources