Eliminating Columns and Rows

Philly2034

New Member
Joined
Jun 10, 2014
Messages
4
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>
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

cyrilbrd

Well-known Member
Joined
Feb 2, 2012
Messages
4,071
Office Version
365
Platform
Windows, Mobile
Given in A1:

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;"></td><td style="text-align: right;;">-91.5125</td><td style="text-align: right;;">-91.5042</td><td style="font-weight: bold;text-align: right;;">-91.496</td><td style="text-align: right;;">-91.4875</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">42.52124</td><td style=";">a</td><td style=";">b</td><td style=";">c</td><td style=";">d</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">42.5129</td><td style=";">e</td><td style=";">f</td><td style=";">g</td><td style=";">h</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">42.50457</td><td style=";">i</td><td style=";">j</td><td style=";">k</td><td style=";">l</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="font-weight: bold;text-align: right;;">42.4962</td><td style=";">m</td><td style=";">n</td><td style=";">o</td><td style=";">p</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="font-weight: bold;text-align: right;;">-91.496</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="font-weight: bold;text-align: right;;">42.4962</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">o</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet3</p><br /><br />

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

Watch MrExcel Video

Forum statistics

Threads
1,099,911
Messages
5,471,468
Members
406,764
Latest member
ExcelMaker007

This Week's Hot Topics

Top