Formula or Macro, match string,from 1 cell to a column,String use dash

Hi,

I know how to create a some Formulas and simple macro, but i need some help

on this Issue

If 2 or 3 (dynamically) Numbers from Cell Z8 Match any combination/Row
of Column G12 (down), then i need to noticed wherever i copy the Formula
(it can be column E12 to E1000)
of course, that i need to exclude these combination matched with min string, but then this post
it get complex (may be a macro?)

What i'm Adding:
============
CELL Z8
I need to Use In a single Cell Z8 to hold over 22 Numbers, with leading zero and with dash "-"
like : 01-02-03-04-05-06....

What already have
==============
COLUMN G12 to G1000
The sheet already have a Single Column that hold combinations with
Groups combination between 4 to 13 Numbers
and it already use the same Format (leading zero and with dash "-")

to make this formula is hard for me, because i ever work with :
a-.Combinations in Single Cell
b-.Combination comes with dash "-",
c-.Combination Numbers are with 2 Digits, example : 01-02-03, etc,etc..


Please, please.... :-(

Thank you so much!


Best Regards

David

Hi,

The difficult of this code (or formula) that see, is that each Combination Numbers to be match (target Column G)are together in a single Cell and separated by dash "-"

In Post #1, the Numbers to match,i ask from a Range of Cell Z6 to AU6 Cell,
and i think it can be possible, due that this range it also have to be in a single Cell with the "-",
other than that, what else can do?



Thank you in advance


David

Hi,

Problem solved, I had to Add a Code, few more formulas, But at the end I got
what i need.

This is what i did :

1-.I modified a Get Match Code that i have,

2-.Starting Cell E12, i Added the Getmatch Function that work with the code

3-.Starting Cell D12, I Added a LEN Function (to count how many numbers match Between Cell Z8 and G12 )
and
4-.then on Column D12, I Added The Excel Filter to Accept/Reject if 2 (3 or more) Numbers matched

Here the Code :

Please Login or Register  to view this content.

Getmatch Formula

Please Login or Register  to view this content.

LEN Fomula

Please Login or Register  to view this content.

And finally, Added the excel Filter located Tab DATA->Sort and Filter.

That's it.

Well, talk to you later or tomorrow, please everyone have wonderful evening

Thank you so much.



Best Regards From Miami

David.