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.
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.