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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel database

ResolvedVersion 2003

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

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

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.