Detect the presence of the double of the last digit, after separating the lasts type of the lottery
* Objective = identify doubles of digits from 00 to 99 = are 10 doubles
Sometimes we will have 6,6,6, but two already enough to form the pair
* Having a last digit is considered zero, mark the value zero in a color
https://www.excelforum.com/attachmen...1&d=1524744810
The following proposed solution is formula based and employs a helper row (AE2:AN2) which may be hidden by setting the font color to white.
1) The formula which separates the last digits is: =VALUE(RIGHT(A4,1))
2) The formula which identifies duplicates is: =IF(COUNTIFS($P4:$AC4,AE$2)>1,1,0)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hello jeteMec yes this is correct, very good job Is it possible to put a color in the value zero?
Ex = 1 0 1 1 0
Yes, use conditional formatting > highlight cells rules > equal to: 0 > with: custom
Font: Yellow
Fill: No fill
Let us know if you have any questions.
Hello. Ok, jeteMc, it worked perfect, thank you!
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks