98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Searching data, finding different values
Searching data, finding different values
Resolved · High Priority · Version 2010
Mon 18 Mar 2013, 12:33Delegate Kathryn said...
Kathryn has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
Searching data, finding different values
Hi,
I have got the following problem. I have a list of codes, eg:
3c3f0b125b5ca9b7d2990c2f3d1a0407
3c3f0b125b5ca9b7d2990c2f3d1a0407
3d3f0b125b5ca9b7d2990c2f3d1a0407
3c3f0b125b5ca9b7d2990c2f3d1a0408
3c3f0b125b5ca9b7d2990c2f3d1a0407
As you can see, at face value the codes all look the same- however the third code down's second value is a 'd' and the 4th down ends with an '8'. All the others are the same.
I am looking for a formula which firstly tell us which codes are completely unique, and then also tell is why- therefore directing us to the second value in the third code, and the last value in the 4th code.
Any help would be much appreciated.
Thanks.
Mon 18 Mar 2013, 13:54Trainer Gary said...
RE: searching data, finding different values
Hi Kathryn
Thanks for getting in touch. I can think of a number of ways to get part of this done, but most of them involve VBA coding.
I have thought of a non-programming solution. Are all the strings the same length?
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Mon 18 Mar 2013, 15:55Delegate Kathryn said...
RE: searching data, finding different values
Hi Gary,
Yes, all the strings are the same length.
Thanks for your help,
Kathryn.
Mon 18 Mar 2013, 16:42
Edited on Mon 18 Mar 2013, 16:43Trainer Gary said...
RE: searching data, finding different values
Hi Kathryn
Thanks for your reply.
I've offered a couple of suggestions in the accompanying workbook. The first part (which are duplicates?) is relatively easy. Identifying what has changed is a little trickier as there is no "control" code specified (i.e., identify variances from this particular code).
However once you have removed the duplicates, this task should be easier.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
GF Unique Codes.xlsxMon 18 Mar 2013, 16:54Delegate Kathryn said...
RE: searching data, finding different values
Thank you, although that is as far as I had got too. It's the part about directing us to which part of the code is different, for example highlighting to us that it is the second value- that is the main part I am struggling with, however this may not even be an Excel formula. I did start looking into VBA to answer this, but again got stuck.
Thanks for your help, much appreciated.
Tue 19 Mar 2013, 09:20Trainer Gary said...
RE: searching data, finding different values
Hi Kathryn
Is there one code that is always the same? If you like, the 'master'?
Differentiating from one code would be simpler.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shortcut for accessing recently opened filesTo get into recently opened Excel files without using your mouse, hold down Alt + F to open the File menu. |
