Daniel has attended:
Excel Introduction course
Excel Intermediate course
Finance for Non-Financial Managers course
Excel Advanced course
Excel Advanced - Formulas & Functions course
Excel Intermediate course
Excel Advanced course
Finding a batch of numbers from one file on another without sear
Hi. I have 2 excel files. One with 4500 lines and the other is 225 lines. The 225 lines has a long number which i need to match and colour red on the large 4500 file. I can obvioulsy filter one by one and search but i was hoping there is a way to do it in 1 go?
RE: Finding a batch of numbers from one file on another without
Hi Daniel,
Thank you for the forum Question.
If you have a high level of VBA knowledge you can write VBA code, which can do what you want, otherwise you will need to copy the 225 lines and paste them in the same worksheet as the 4500 lines.
Select the long number column you want to pair in both lists. On the Home tab click conditional formatting -> Highlight Cell Rules -> Duplicate Values
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
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
