Advanced search
 

I have a double column data set. Headed 'distance' and 'depth'. Distance is
in approximately 10m intervals (9.9999996578, 20.000004568, etc) next to this
is a corresponding 'depth' amount. I have tried using advanced search using
the following layout:
O P Q
3 Distance Depth
4 #VALUE!
5
6 Distance Depth
7 0.0 -732.575
8 10.0 -731.879
9 20.0 -731.183
10 30.0 -730.487
11 40.0 -729.791
12 50.0 -729.095
13 60.0 -728.394
14 70.0 -727.693
15 80.0 -726.992
16 90.0 -726.291
17 100.0 -725.590
etc.

VALUE# above is the formula...
=((INT(ROUND($O$7:$O$61,0)/30)-(ROUND($O$7:$O$61,0)/30))=0)

When I try the search which should paste depths 0, 30, 60, 90, etc. at
another location, all distances and depths are pasted....

Can anyone figure out what's going wrong?

Any help would be most welcome.

Rich

Advanced search
 

If you want the values 0,30,60,90 you have to manually put these numbers in a
table at the destinattion cells. Then use these numbers to perrform a LOOKUP
in the original table.

"Rich" wrote:

I have a double column data set. Headed 'distance' and 'depth'. Distance is
in approximately 10m intervals (9.9999996578, 20.000004568, etc) next to this
is a corresponding 'depth' amount. I have tried using advanced search using
the following layout:
O P Q
3 Distance Depth
4 #VALUE!
5
6 Distance Depth
7 0.0 -732.575
8 10.0 -731.879
9 20.0 -731.183
10 30.0 -730.487
11 40.0 -729.791
12 50.0 -729.095
13 60.0 -728.394
14 70.0 -727.693
15 80.0 -726.992
16 90.0 -726.291
17 100.0 -725.590
etc.

VALUE# above is the formula...
=((INT(ROUND($O$7:$O$61,0)/30)-(ROUND($O$7:$O$61,0)/30))=0)

When I try the search which should paste depths 0, 30, 60, 90, etc. at
another location, all distances and depths are pasted....

Can anyone figure out what's going wrong?

Any help would be most welcome.

Rich