Hi SirJB7,
Thanks, I have adapted your first formula to work for me, the "code" column is generated by our system so there are no data entry errors on that column, so what I did was I filtered the entire list by "ending in 1" and then added another column with the below code...
Good Morning SirJB7,
Thank you for the advice, this may work, a few issues that I can see though, this would require AA to contain identical values to show a number in AB correct?
If so I will need to restrict the data in AA to what I am checking for in duplicates?
I ask this as some lines...
Good Morning all,
*What we have*
I have a task at work that requires a little help from some knowledgeable people and would he highly grateful for any assistance anyone can provide
We have exported our entire local client database into excel format, this database contains 7859 rows of data...
Hi all,
Names Jack, an amateur when it comes to advanced parts of Excel but use it allot for work so thought it would be a good idea to link up with a few helpful sites to progress my knowledge base.
Thanks