Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for multiple strings in a list (w/in 1 cell) w/ Advanced fi | Excel Discussion (Misc queries) | |||
Where is advanced search option? | Excel Discussion (Misc queries) | |||
Advanced filter search | Links and Linking in Excel | |||
advanced search | Excel Worksheet Functions | |||
Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) |