detect at the value = 1 for pairs, 2 odd pairs and 3 for the same digit in the position
pair = 1
odd = 2
repeat the same digit at position = 3
pair= 0,2,4,6,8
odd=1,3,5,7,9
detect in each position the same pattern, and the repetition of the digit, after separating the last digit
https://www.excelforum.com/attachmen...1&d=1590441464
Please try the following:
1. For finding the last digit (Q6 over and down): =MOD(A6,10)
2. For finding pairs, odd and same (AG7 over and down): =IF(Q7=Q6,3,IF(AND(ISEVEN(Q7),ISEVEN(Q6)),1,IF(AND(ISODD(Q7),ISODD(Q6)),2,"")))
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 jete, thanks for viewing the post can you put it on the plain? please !
I filled down only to row 27 so as not to produce too large of a file.
Let us know if you have any questions.
hello jeteMc, perfect, very good work, congratulations, when you win a prize you will be rewarded.
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