Data Filter

[Catarina2040]

Dear all

I am new here and I have this doubt:

I have 30 cells, listed from 1 to 30 and I wanted to select a cell from 7 to 7 cells. I mean, all the cells that are multiple of 7. 

How can I do this?

Thank you in advance

[#2]

You could create a helper column next to your list (A:A in this case) like so: =+IF(MOD(A1,7)=0,"Yes","No"), then just filter on Yes and select those numbers.

You can change the "7" in the mod to whichever multiple you're looking for.