detect only between triplets on both lines
they are trios in sequences, the second line are trios in a column, which is why it seems that they are not followed
but in the 5x5 matrix they are,
the macro will only detect the trios in the groups of each color
https://www.excelforum.com/attachmen...1&d=1706644363
No macros needed. Simple formula is enough.
in Q5:
in R5:Formula:
Please Login or Register to view this content.and in S5 also:Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
copy these 3 cells to next 3, and repeat it along the row
Then copy all Q5:BN5 down to the end of the data (I did it for some first 100 rows only, so copy down yourself)
Best Regards,
Kaper
By the way: I think it is better to arrange triplets vertically, not horizontally, as I did in Planilha2
Then there is only one formula, to be copied down and right
Formula:Please Login or Register to view this content.
hello kaper thanks for posting the macro
but it has an error message
runtime error 1004
the activate method of the worksheet class
failed
Try. Macro code :
Please Login or Register to view this content.
Last edited by kvsrinivasamurthy; 01-31-2024 at 09:42 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
??? I've posted no macro at all. It is purely worksheet formula solution.Originally Posted by jorel
Have you downloaded a worrkbook attached to my post #2?
There are the formulas already inside. You only shall copy them down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks