Hi there,
Is there any other more advance way to check the most frequent numbers for 4D and 3D number. As per attach file...
Example 4D number :
3389 and 8393 - both consider as same number
Example 3D number :
9378 and 6873 - 378 consider as same number
Regards,
Merson
Last edited by Merson78; 06-07-2014 at 09:32 AM.
Irregardless of the MOD comment, I do not understand a 4D and 3D number?
As to understanding why you have two obvious numbers in conflict I feel that you need to submit the macro, or that part of it that compares numbers within your range. My guess is that you have chosen to compare up to 3 values (I'll allow you 4) but you haven't compared them by place value, HTU!
I apologise that I can do no more than give a presumed insight.
@ BrianCob
It's not a comment! It is a request! You need to take some minutes to read forum rules, because:..Irregardless of the MOD comment
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.
If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Ok. I understand that now, but ...
OK! It seems to me that the RULEs need to be more concise, more compact. Then I would not have transgressed.
I understood that the Forum welcomed assistance for others.
With the greatest of respect (even had I known the RULEs exactly) I believed that I understood that I could relate closely to the author and that he might have gained from my experience. Well he now has to await. My apologies.
@BrainCob
That's the reason members don't have to respond (according to the forumrules).
Please Login or Register to view this content.
Otherwise there will be answers and a (new) member don't feel the need to change the title, since he already have an good answer.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
@BrainCob
This is your comment in your negative rep that you gave me. Thanks for that...I think DIPLOMACY has been overlooked. Yes, RULEs are rules, but everyone knows that they are made to be broken.
My comment for that is that:
I feel very honored to accept negative rep from you, because I care and try to apply the rules for this forum!
@Fortis1991
Stay on with the good work
I like your reaction on the rep.
@ Fotis
I really appreciate your work.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
For what it's worth, I would have reacted exactly the same way you did, Fotis, in which case it would have been me getting the negative rep.
@ BrainCob - perhaps where you come from, rules are meant to be broken, but here - they are abided and respected by all members...as a member of this forum, the same is expected from you
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@BrianCob
These rules are here to keep it nice and tidy. Many newcomers stumble on that rule (including me). Don't make a big deal out of it and things will go back to normal.
Ok, back to the actual problem posted by OP. It's out of my league but I'm just curious now, is this one of those problems where you could apply reg exp?
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Merson, welcome to the forum
1st, apologies for the above
1nd, what would your expected answer look like?
Hi FDibbins,
I want a faster way to check the most frequent 4D direct or indirect number (1234 or 4321 or 4132). And for the most frequent 3D number - 567 (5678 or 1756 or 3675).
There are 345 column with 4D number each in the column.
Example : The most frequent 4D is 3171, 7131, 7113 & 7311
Example : The most frequent 3D is 137 - (2137,3171,1735,7131,9173 and so on...)
Regards,
Merson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks