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 » microsoft excel training courses london - How do I extract specific data
microsoft excel training courses london - How do I extract specific data
Resolved · Low Priority · Version Standard
Tom has attended:
Excel Advanced course
How do I extract specific data
how do I extract specific data from a data download? e.g. I have imported a cash ledger for 12 month period and want to extract only those transactions with "interest" in the description field.
RE: How do I extract specific data
Hi Tom
You mention the "description" field. Could you let me know where this is located? is it a column heading or a comment, or something else. Once I am clear on that I should be able to assist you.
Thanks
Richard
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:Hiding and unhiding columns using the keyboardCTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal |