Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-24-2020, 12:42 PM
joni joni is offline isolate the last digit of each number. Windows 7 64bit isolate the last digit of each number. Office 2016
Novice
isolate the last digit of each number.
 
Join Date: Jun 2020
Posts: 2
joni is on a distinguished road
Default 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:
Attached Files
File Type: xlsx 7 padroes em cada posiçao.xlsx (132.2 KB, 8 views)
Reply With Quote
  #2  
Old 06-25-2020, 02:43 AM
Purfleet Purfleet is offline isolate the last digit of each number. Windows 10 isolate the last digit of each number. Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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
Reply With Quote
  #3  
Old 06-25-2020, 04:12 AM
joni joni is offline isolate the last digit of each number. Windows 7 64bit isolate the last digit of each number. Office 2016
Novice
isolate the last digit of each number.
 
Join Date: Jun 2020
Posts: 2
joni is on a distinguished road
Default

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
Attached Files
File Type: xlsx 7 padroes em cada posiçao.xlsx (132.5 KB, 7 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
isolate the last digit of each number. Trying to change the last digit in a column of 10 digit entries arkansawyer16 Excel 10 04-06-2020 02:03 PM
isolate the last digit of each number. formula to isolate............ afoster Excel 4 06-08-2016 02:59 AM
isolate the last digit of each number. 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
isolate the last digit of each number. 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft