Eliminating Columns and Rows

[Philly2034]

I have a spreadsheet. Latitudes are across row 1. Latitudes are across row A. The lower case letters are values of some function. I would like to delete all the columns and rows in the spreadsheet except for those that are closest to .00, .25,.50, .75.
For example, this

	A	B	C	D	E
1		-91.5125	-91.5042	-91.4959	-91.4875
2	42.52124	a	b	c	d
3	42.5129	e	f	g	h
4	42.50457	i	j	k	l
5	42.49624	m	n	o	p

<colgroup><col><col width="*"><col width="*"><col width="*"><col width="*"><col width="*"></colgroup><tbody>
</tbody>

would turn out to this...

		-91.4959
	42.49624	o

<colgroup><col><col width="*"><col width="*"></colgroup><tbody>
</tbody>

 

[cyrilbrd]

Given in A1:

Excel 2010
	A	B	C	D	E
1		-91.5125	-91.5042	-91.496	-91.4875
2	42.52124	a	b	c	d
3	42.5129	e	f	g	h
4	42.50457	i	j	k	l
5	42.4962	m	n	o	p
6
7
8	-91.496
9	42.4962
10	o
Sheet3

Formula in A10 is =VLOOKUP(A9,A2:E5,MATCH(A8,A1:E1,0),0).
Would that work for you?