convert in the three possible pairs and then detect in the three groups.

[jorel]

convert in the three possible pairs and then detect in the three groups the inverted double is worth ex = 24 42 is worth
objective=identify the pairs in each segment
and see delays you can create the list next to the delays for each segment
https://www.excelforum.com/attachmen...1&d=1632769877

[bsalv]

Please Login or Register  to view this content.

ascending order

Please Login or Register  to view this content.

[jorel]

hello BSALV ! I only managed to do the 1st part, the part of the three segments, I couldn't help? please

[bsalv]

suppose you have 3, 2 and 1
with the 1st 3 formulas you get 32, 31 and 21
with the 2nd 3 formulas you get 12, 13 and 23, but this solution wasn't part of the original question
if the "$"-signs bother, delete them.

[kvsrinivasamurthy]

Pl see file.
In I6 then copied to full range

=IF(COUNTIF($E7:$G7,TEXT(I$5,"00"))=1,"X","")

[bsalv]

the 2nd formulas of post #2 for the columns E:G

[jorel]

hello KVS and bsalv, corret , perfect conglatulations, thank you!