#1
|
|||
|
|||
isolate the last digit of each number.
isolate the last digit of each number and then detect the corresponding number in each sector in the biggest, smallest and equal is always from the last draw to the next:anjo: |
#2
|
|||
|
|||
Sorry but i have no idea what you want after the last digot of each number?
The first pasrt is easy - =RIGHT(A10,1) then drag accross and down. but what does the rest mean? and in what context? Purfleet |
#3
|
|||
|
|||
ok purfleet thanks for viewing the post
let's go to the 2nd part = then we have 15 positions one position of each last digit, we have 3 sectors or patterns, each position corresponds to a last digit the macro must detect which pattern of the 3 sectors is represented by 7 numbers, purfleet attention is always from the last draw to the next the reference or base is always the last draw, because I keep updating new ones every week, in the major, minor and equal patterns the same is when you repeat the same digit, objective is to have sequences for filters of the 3 patterns, please |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trying to change the last digit in a column of 10 digit entries | arkansawyer16 | Excel | 10 | 04-06-2020 02:03 PM |
formula to isolate............ | afoster | Excel | 4 | 06-08-2016 02:59 AM |
number field coming over with missed digit | sherrin | Mail Merge | 1 | 04-20-2016 06:06 PM |
Regex/wildcard search for dates with 2-digit and 4-digit years | Marrick13 | Word VBA | 2 | 01-29-2016 07:04 AM |
A challenging digit by digit manipulation, rotate the digit in range of 0 to 9 | laucn | Excel Programming | 14 | 05-17-2015 12:12 PM |