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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel database

Excel database

ResolvedVersion 2003

Fri 13 Jun 2008, 10:46 Delegate Sarah said...

Sarah has attended:
Excel Advanced course

Excel database

I need to extract all the entries from an excel database which all have the same word in their description. This word could be in any position within the description so I am unsure what feature to use to be able to do this (MID, LEFT, RIGHT need the word to appear in the same position). hAVE LOOKED AT =FIND but unsure how to use this & if it is the answer. Thanks,
Sarah

Tue 17 Jun 2008, 16:48 Trainer Amanda said...

RE: Excel database

Hi Sarah

Thank you for your question and welcome to the forum.

I think you can get this to work using an advanced filter.

I have attached an example for you to look at.

I hope this helps.
Amanda

Attached files...

advanced filter example.xls

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Terms & Conditions Privacy & Cookie Policy