excel database

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Excel database

resolvedResolved · Low Priority · Version 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:

Selecting blank cells within a range of data

Select 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.

View all Excel hints and tips


Server loaded in 0.08 secs.