+ Reply to Thread
Results 1 to 2 of 2

Break data up into groups then highlight the lowest number in the group. Any suggestions?

  1. #1
    Registered User
    Join Date
    01-16-2015
    Location
    Bourbonnais,IL
    MS-Off Ver
    2010
    Posts
    1

    Break data up into groups then highlight the lowest number in the group. Any suggestions?

    I have A LOT of data that is exported from a measuring device. This scan device takes measurements every .093" which gives me thousands of readings even for a "small" scan. In order to make this data a bit easier to understand, i need to "break it up" into 1" squares and then highlight the lowest number in that 1" square. I'm decent with Excel but I'm not sure how to tackle this one. Any suggestions would be greatly appreciated. I've attached an example of the data that is compiled from the machine.
    Attached Files Attached Files

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Break data up into groups then highlight the lowest number in the group. Any suggesti

    What is a one-inch square? Could you work out an example or two so we can catch onto the logic? Thanks.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Lowest number of corresponding category that is part of a group
    By jrm0523 in forum Excel General
    Replies: 6
    Last Post: 04-14-2012, 07:55 PM
  2. Excel 2007 : Highlight the lowest whole number in a range
    By Martin Chamberlin in forum Excel General
    Replies: 4
    Last Post: 04-21-2011, 02:14 PM
  3. Replies: 6
    Last Post: 06-03-2010, 04:25 AM
  4. code to break a number down into groups
    By Traymond in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-10-2009, 10:57 PM
  5. Find lowest number in groups then lowest overall.
    By swieduwi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-24-2008, 01:00 PM
  6. [SOLVED] Change cell color if it is the lowest number of a group?
    By Anthony in forum Excel General
    Replies: 3
    Last Post: 10-19-2005, 10:05 PM
  7. Highlight lowest number
    By Amber M in forum Excel General
    Replies: 4
    Last Post: 01-11-2005, 09:06 PM

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