Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting | Excel Discussion (Misc queries) | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Sorting | Excel Discussion (Misc queries) | |||
Convert latitudes and longitudes to decimal | Excel Discussion (Misc queries) | |||
sorting | Excel Discussion (Misc queries) |