Results 1 to 2 of 2

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

Threaded View

jeevesme Break data up into groups... 06-04-2019, 11:04 AM
dflak Re: Break data up into groups... 06-04-2019, 03:46 PM
  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

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