Hello,
I have a question and I will be very thankful for help
I want to find out if i have a range of numbers, how can I find out how many repeated numbers i have ( last digit only ) maybe something like: countif with right,1
example if i have numbers, 5, 15, 25, 30, 33, 34 I be able to count repeated right digits which is 3 fives.
Thanks
Last edited by Excl3454; 07-19-2023 at 05:04 PM.
So you would need a list of how many 1's, how many 2's etc?
And would this be per line or for a range?
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
i think just a simple count for duplicated items, but only last digit on right, maybe a if count if with right,1 together
Try
Formula:
Please Login or Register to view this content.
Control+Shift+Enter
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Why is row 1 2 and not 4... there are also two that end in zero.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I1=IFERROR(SUMPRODUCT(--(RIGHT(A1:F1,1)+0=MODE.MULT(RIGHT(A1:F1,1)+0))),"")
copy down
Last edited by CARACALLA; 07-19-2023 at 04:45 AM.
Perhaps:
Formula:Please Login or Register to view this content.
...and this to tell you which digit was most repeated:
Formula:Please Login or Register to view this content.
Last edited by leelnich; 07-19-2023 at 07:19 AM.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
Thank you so much. well done appropriate it.Originally Posted by CARACALLA
Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks