hi
I like to find or match numbers as follows:
7293 > 8922 = 2 matches![]()
simply how is this done!
remember double digits count as 1 match and each digit has its own cell....
thankx for reply![]()
hi
I like to find or match numbers as follows:
7293 > 8922 = 2 matches![]()
simply how is this done!
remember double digits count as 1 match and each digit has its own cell....
thankx for reply![]()
this will do it but its un-wieldy i'm sure someone else can simplify it but it should give you some idea
the test for match simply returns the position of the matched number,first instance only
so this effectively ignores duplicates
formula to count matches in cell N2 is an array formula and needs to be entered with ctrl+shift+enter
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks