microsoft excel training courses london - how do i extract

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum 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

resolvedResolved · 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


 

Excel tip:

Hiding and unhiding columns using the keyboard

CTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal

View all Excel hints and tips


Server loaded in 0.08 secs.