Data Filter

%3CLINGO-SUB%20id%3D%22lingo-sub-2679741%22%20slang%3D%22en-US%22%3EData%20Filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2679741%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20new%20here%20and%20I%20have%20this%20doubt%3A%3C%2FP%3E%3CP%3EI%20have%2030%20cells%2C%20listed%20from%201%20to%2030%20and%20I%20wanted%20to%20select%20a%20cell%20from%207%20to%207%20cells.%20I%20mean%2C%20all%20the%20cells%20that%20are%20multiple%20of%207.%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20do%20this%3F%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2679741%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2679793%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2679793%22%20slang%3D%22en-US%22%3EYou%20could%20create%20a%20helper%20column%20next%20to%20your%20list%20(A%3AA%20in%20this%20case)%20like%20so%3A%20%3D%2BIF(MOD(A1%2C7)%3D0%2C%22Yes%22%2C%22No%22)%2C%20then%20just%20filter%20on%20Yes%20and%20select%20those%20numbers.%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20change%20the%20%227%22%20in%20the%20mod%20to%20whichever%20multiple%20you're%20looking%20for.%3C%2FLINGO-BODY%3E
Occasional Visitor

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

1 Reply
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.