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
[TABLE="width: 624"]
<colgroup><col><col width="*"><col width="*"><col width="*"><col width="*"><col width="*"></colgroup><tbody>[TR]
[TD="bgcolor: #efefef"][/TD]
[TD="bgcolor: #efefef"]A
[/TD]
[TD="bgcolor: #efefef"]B
[/TD]
[TD="bgcolor: #efefef"]C
[/TD]
[TD="bgcolor: #efefef"]D
[/TD]
[TD="bgcolor: #efefef"]E
[/TD]
[/TR]
[TR]
[TD="bgcolor: #efefef"]1
[/TD]
[TD][/TD]
[TD]-91.5125
[/TD]
[TD]-91.5042
[/TD]
[TD]-91.4959
[/TD]
[TD]-91.4875
[/TD]
[/TR]
[TR]
[TD="bgcolor: #efefef"]2
[/TD]
[TD]42.52124
[/TD]
[TD]a
[/TD]
[TD]b
[/TD]
[TD]c
[/TD]
[TD]d
[/TD]
[/TR]
[TR]
[TD="bgcolor: #efefef"]3
[/TD]
[TD]42.5129
[/TD]
[TD]e
[/TD]
[TD]f
[/TD]
[TD]g
[/TD]
[TD]h
[/TD]
[/TR]
[TR]
[TD="bgcolor: #efefef"]4
[/TD]
[TD]42.50457
[/TD]
[TD]i
[/TD]
[TD]j
[/TD]
[TD]k
[/TD]
[TD]l
[/TD]
[/TR]
[TR]
[TD="bgcolor: #efefef"]5
[/TD]
[TD]42.49624
[/TD]
[TD]m
[/TD]
[TD]n
[/TD]
[TD]o
[/TD]
[TD]p
[/TD]
[/TR]
</tbody>[/TABLE]






would turn out to this...
[TABLE="width: 624"]
<colgroup><col><col width="*"><col width="*"></colgroup><tbody>[TR]
[TD="bgcolor: #efefef"][/TD]
[TD="bgcolor: #efefef"][/TD]
[TD="bgcolor: #efefef"][/TD]
[/TR]
[TR]
[TD="bgcolor: #efefef"][/TD]
[TD][/TD]
[TD]-91.4959
[/TD]
[/TR]
[TR]
[TD="bgcolor: #efefef"][/TD]
[TD]42.49624
[/TD]
[TD]o
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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?