Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel database
Resolved · Low Priority · Version 2003
Sarah has attended:
Excel Advanced course
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
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
|
|
Excel tip:Selecting blank cells within a range of dataSelect the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
advanced filter example.xls