Filtering: whole numbers only

[Aaron Borbora]

Hi,

I've got a number of spreadsheets of data from some experimental work. The
format is:
Column A: time of measurement (0, 0.5, 1, 1.5, 2, 2.5, 3, etc)
subsequent columns: Measurement values.

I would like to filter the data so that only measurements taken each second
(0, 1, 2, 3, etc) are kept and other measurements (at 0.5, 1.5, 2.5, etc)
are excluded.

Any idea how to set the filter up?

Thanks.

Aaron

 

[Ken Wright]

Personally I wouldn't want to actually lose the data, so I would just hide
it. Add another column that says Hide/Show and use a formula such as:-

=INT(A2)=A2

Copy it down as far as necessary and then just filter on TRUE, or Throw a
Pivot table at it and then throw the Hide/Show field into the Page Fields and
select TRUE

If you really want to get rid of the data then filter on FALSE, select all
and do Edit / Go To / Special / Visible cells only, and then Edit / Delete /
Entire Row.

 

[Aaron Borbora]

Personally I wouldn't want to actually lose the data, so I would just hide
it. Add another column that says Hide/Show and use a formula such as:-

=INT(A2)=A2

Copy it down as far as necessary and then just filter on TRUE, or Throw a
Pivot table at it and then throw the Hide/Show field into the Page Fields
and
select TRUE

If you really want to get rid of the data then filter on FALSE, select all
and do Edit / Go To / Special / Visible cells only, and then Edit / Delete
/
Entire Row.

Thanks so much, Ken! It works fine and has save me hours of work!

Best,

Aaron

 

[Ken Wright]

Excellent, and thanks for the feedback

Regards
Ken.............