Results 1 to 7 of 7

Find Highest 3x3 Sum

Threaded View

  1. #1
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Find Highest 3x3 Sum

    I have a dataset containing 3264 rows and 7640 columns, and I need to find the sums of each 3x3 grid, and eventually determine which are the top 10, by row & column header of upper left cell.

    I've attached a scaled down version with values from B2:P29. What would an efficient approach to this be?


    It's being used in conjunction with Latitude and Longitude, where each cell represents .01 degrees; actual headers are Lat and Long.
    Normally I'd just use a visual heatmap but these people want data with granular detail.

    To clarify, I'm mostly just looking for the list of all 3x3 grids and respective totals.
    Attached Files Attached Files
    Last edited by daffodil11; 02-04-2015 at 07:50 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. find 3 out of 5 highest cell #s
    By geo777 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2013, 05:22 PM
  2. Find the highest value below 400
    By FallingDown in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-20-2012, 05:35 AM
  3. [SOLVED] Find highest value in a row and return a value from a different row
    By VT_2000 in forum Excel General
    Replies: 2
    Last Post: 05-04-2012, 03:06 PM
  4. VBA code to find highest and 2nd highest number based in criteria
    By Michael007 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-25-2011, 08:38 AM
  5. Replies: 2
    Last Post: 09-19-2008, 10:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1