Pattern from a list of numbers & Change look of a simple dashboard (1 Viewer)

kanchan

Registered User.
Local time
Today, 06:18
Joined
Dec 8, 2014
Messages
10
Dear Experts
Good Day!!

Well dear i m novice and will be grateful for your help. As i got stuck with two problems, which described below and attached sample data,

Q1: i have a list of 10,13 and 17 digit numbers like 12345000009,234567778,1098756,123456780,6781234512 i need to find if there is a matched pattern in list ,like rows 2,3,5 have 345 or row 1,2 have 12345.Need to identify which rows contains which patterns from right and left and how many.

Q2: i have a sample dash board in excel where data is driven from a pivot table and shown to users, i only want user to see the dashboard without any hint of excel look. need to change the icon of the workbook and on clicking it they will view a full screen fitted view in desktop or laptop without any bar or anything.

Thanks & Regards
Babu.
 

Attachments

  • problem.xlsx
    39.9 KB · Views: 203

isladogs

MVP / VIP
Local time
Today, 13:18
Joined
Jan 14, 2017
Messages
18,186
Q1: i have a list of 10,13 and 17 digit numbers like 12345000009,234567778,1098756,123456780,6781234512 i need to find if there is a matched pattern in list ,like rows 2,3,5 have 345 or row 1,2 have 12345.Need to identify which rows contains which patterns from right and left and how many.

I would suggest you search for specific string patterns as that's much easier
e.g. add a field to a query such as IIf([NumberFieldName] Like '*345*',"Match","")

If you don't know what patterns to look for, perhaps one of these might be helpful:
Regex: https://www.access-programmers.co.uk/forums/showthread.php?t=297155

Soundex: http://allenbrowne.com/vba-Soundex.html

Simil: https://www.access-programmers.co.uk/forums/showthread.php?t=275633&highlight=soundex


Q2: i have a sample dash board in excel where data is driven from a pivot table and shown to users, i only want user to see the dashboard without any hint of excel look. need to change the icon of the workbook and on clicking it they will view a full screen fitted view in desktop or laptop without any bar or anything.

I know how to do this in Access but have never tried to do it in Excel.
I expect you can do it in a similar way to this Access example: https://www.access-programmers.co.uk/forums/showthread.php?t=293584

Good luck
 

Rx_

Nothing In Moderation
Local time
Today, 07:18
Joined
Oct 22, 2009
Messages
2,803
Only for consideration:
Does the data start in MSAccess? If it does, I often try to accomplish the work in Access first. Then, send the data output (or a Access Query with the results) to Excel using automation. It isn't a solution for every situation.
The code may not be as difficult to get started as many fear.
https://www.access-programmers.co.uk/forums/showthread.php?t=258909
 

Users who are viewing this thread

Top Bottom