98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training onsite - Comparind data
excel training onsite - Comparind data
Resolved · Low Priority · Version Standard
Fazil has attended:
Excel Advanced course
Comparind data
Hello,
I have 2 different workbooks/worksheets with data about my clients. I want to know if those workbooks/worksheets have data about the same customer. How do I find it..?
I cant merge the worksheets/workbooks as the data apart from client name are different.
Thanks and regards... Fazil
RE: Comparind data
Hi Fazil
Thanks for your question.
If you simply want to find something in particular in a spreadsheet you can use the Find feature. Ctrl + F will open the Find feature or you can go to Edit - Find.
Then type in what you are looking for and Excel will select the next instance of what you are looking for in the spreadsheet.
I hope this helps.
Amanda
RE: Comparind data
Thanks Amanda..,
The spreadsheets I am talking about runs the data of thousands of customers and so it is difficult to compare each customer name using Ctrl + F. It is equally difficult to compare them by minimising to display side-by-side in the screen as, apart from 'customer name' other data in the spreadsheets are very different.
Is there a way to tell 'Excel' to run through both the spreadsheets, compare the data on 'Customer Name@ column and report back saying, 'this is the list of customers present in both the spread-sheets'
Thanks and regards,
Fazil
RE: Comparind data
Hi Fazil
I think this would require VBA code to be written in order to produce the results that you are looking for.
Amanda
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:Create and delete bordersTo put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range. |