LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default Sorting latitudes and longitudes

I have a large dataset (~5000 rows) that is tied to latitdue and longitude
(small portion below). For each latitude/longitude reading I have between 8
and 10 columns of other data (not shown). I would like to sort the data into
latitude/longitude bins and then analyze it. The bin size I'm looking for is
2 degrees latitude (from -90 to 90) and 4 degrees longitude (-180 to 180).
This will produce 8100 bins. Only about 1/5 of these bins will have data (I'm
interested in data over continents only). In each bin I plan to average
numbers in the other columns to come up with standard values for each bin.

latitude longitude
-38.35 141.6
-38.27 144.67
-25.63 118.72
49.05 51.87
28.63 121.42
25.85 -81.38
29.75 -81.53
29.92 -90.13
34.42 -119.68
38.57 -76.07
43.42 -124.25

Thank you!
Ian
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Teethless mama Excel Discussion (Misc queries) 1 March 28th 07 12:22 AM
Sorting: Sorting by the First Character dzuy Excel Discussion (Misc queries) 2 June 22nd 06 08:27 PM
Sorting texansgal Excel Discussion (Misc queries) 1 May 16th 06 04:08 PM
Convert latitudes and longitudes to decimal Demi Excel Discussion (Misc queries) 7 March 29th 06 09:43 PM
sorting frank Excel Discussion (Misc queries) 1 January 28th 05 11:28 PM


All times are GMT +1. The time now is 11:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"