Results 1 to 11 of 11

display Row# where Highlighted strings Start/End, using Min/Max Criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-21-2012
    Location
    miami, florida usa
    MS-Off Ver
    Excel 2007
    Posts
    260

    Unhappy display Row# where Highlighted strings Start/End, using Min/Max Criteria

    Hi friends, !

    i don't know how or which right formula to use on the following problem.
    Might is a complex or might is easy, tbh i cant' find a closed example to start solving..
    Sorry, need some help.

    I'm using a sheet w/ Conditional format. using Countif in Cell I2:M2, I search and Highlight 5 numbers in 9 Column.
    what i need to do is the following :
    on the sheet i would like to get a mini report of a small database using the Conditional formatting Search (that is done)
    and based on 2 new criteria.

    Please find the sample File Attached

    Function that i'm using
    =================
    a-. I have 9 Columns with 36 Numbers (Column A,C,E,G,I,K,M,O,Q )
    b-.Each Column Numbers have another Column displaying an Score (of each number)
    c-.In Cell I2:M2 I input 5 or 6 numbers, (conditional formatting)
    d-.When Input Numbers in Cell (12:M2) Then each column Numbers (searched) get Highlighted.

    At this point everything its alright.

    So i would like to get a mini report from the small 9 column databease using 2 criteria


    Criteria 1
    =======
    Search/Count Min/Max Range of Highlighted string (Min 4 Max 5) in each in Column

    Criteria 2
    =======
    If Highlighted (Min 4 Max 5) String are in Min/Max Rows Limit (here the limit can be 5 to 11 Rows),
    then
    -.Display the ROW Number where Highlighted String start and display the ROW Number where Highlighted String End..
    -.Display Total ROWS where highlighted string where found.
    (total between 1st and 4th Highlighted)

    The Report it might look like this:
    ___________________________________Highlighted
    _______Start___End_________Total____String
    DATE___Row___Row___Col____Rows____Found__Sort
    21-May__ 8 ____15____A_____8_________4_____L2M
    21-May__ 8 ____16____A_____9_________5_____L2M
    21-May__ 10____16____A_____7_________4_____L2M
    21-May__ 19____23____E_____5_________4_____L2M
    21-May__ 20____29____E_____11________4_____L2M
    21-May__ 19____29____E_____11________5_____L2M
    21-May__ 8 ____15____G_____8_________4_____L2M
    21-May__ 8 ____16____G_____9_________5_____L2M
    21-May__ 10____16____G_____7_________4_____L2M


    Thank you

    Best regards

    David.
    Attached Files Attached Files
    Last edited by david gonzalez; 06-16-2014 at 07:47 PM. Reason: Replace Numbers word for Total and Align Text,bold,post wasn't clear, I ask Mr FDibbins regarding this edit

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Loop through strings stop when strings change and start looping in the next column...?
    By Prexcel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-18-2013, 03:31 AM
  2. Need to pull all strings that start with <> and...
    By antedenise in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2013, 02:29 AM
  3. Finding Start Position of string in list of strings
    By longfisher in forum Excel General
    Replies: 5
    Last Post: 05-25-2007, 10:34 PM
  4. Replies: 3
    Last Post: 01-26-2006, 01:55 PM
  5. [SOLVED] Control cursor direction in highlighted group of cells/Page setup
    By George Tung in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 09-06-2005, 07:05 AM

Tags for this Thread

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