Search results for query: *

Sounds good. Thanks for your help. I will let you know what I come up with. Chris

Still not quite working, this is what I am getting: 40 34, 39 34, 42 getvalues --> 34, 39, 42 should be 34 14 10, 11 11, 14 getvalues --> 10, 11,11, 14 should be 11,14 Thoughts? Is there no way to utilize excel's built in MODE function to get these values? Chris

Thanks for the reply Skip. I tried your code, however it isn't pulling out the common values, it just returns all the values. ex.) When I try it on these values: 40 34, 39 34, 42 GetValues() returns --> 40,34, 39,34, 42 In this instance, tt should only return 34. Any thoughts?

I had question regarding some code that I came across to obtain the 1st, 2nd, 3rd etc. MODE within a VBA UDF function. Specifically, I was wondering if anyone knows whether it is possible to pass a string of values to this function within a UDF; let me elaborate. I currently have a function...

Sorry about that. Would you mind posting the link for Forum 707? I am new to this board and am having some difficulty finding this particular forum. Much appreciated, Chris

I had question regarding some code that I came across to obtain the 1st, 2nd, 3rd etc. MODE within a VBA UDF function. Specifically, I was wondering if anyone knows whether it is possible to pass a string of values to this function within a UDF; let me elaborate. I currently have a function...