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.

I will push this to the other experts for you

where are the #####? the only ones i can see are where the dates are and thats because the column is not wide enough, make column w wider

Hi, this is david

This is the other Formulas the other way to find and display the Row Id where highlighted string it's located
using MIN/IF/ROW nested.
The Only difference is that in any unused Column and Row 1 it must enter Number 1,2,3..
till whatever range you wish to go.

Please Login or Register  to view this content.

Notes :
Among the A1 to A38 is where the 5 Numbers are highlighted.
The G1 to K1 are located the searched numbers (using conditional Formatting)
The AS1 to S41 are located the Digits that work together with the formulas
I Know that Function the MIN/IF/ROW Work together and
The No +1 in the Formula...., To be honest i don't know what function it does ( sorry, no explanation )


What i can't do is what i said on previous mail.

What i don't know is how to do the same as described above, But if meeting the Min/Max Criteria 1
of Cell Z1 & A1 and the other criteria in Cell Box Z2 & A2.
and Display the Total Rows (see Cell AA5) where Highlighted numbers where found (If 2 Criteria/Condition are meet)

Any help, please?


Thank you so much!


Best Regards

David