Help with "extract", "search" & "find" excel funct

  Mark-335400 18:29 14 May 2003
Locked

I was wondering if anyone could give me any "beginners" advice about using these functions in Excel. I am quite profficient with Excel and the "IF" functions, (which over the last few years have provided me with the results i need). However I now need to get more out of the worksheets and these functions look to be the way to go but I can't seem to grasp the correct way of setting them up. The scenario that these functions need to be "fitted" into is this, I work at a motor dealership in sales admin, each car is given a stock number and the next cell reflects the model, when a new cars chassis number is known it is entered in the next cell, and once the vehicle arrives into stock the date is entered into the next cell, two more cells are taken up with the date ordered and the invoice number charged by the manufacturer for payment of the vehicle. What I would like to be able to do is to extract the vehicles and there associated cells which for example have details entered in there chassis number cells and move them to a seperate worksheet which will be used to tax and register the vehicles etc.... Any ideas

  VoG™ 18:39 14 May 2003

Hmm, I haven't heard of some of those myself. There's FIND and EXACT and if you download this click here you can learn all about them and a lot more besides.

If you wish to you can achieve what you want to do by using the filtering facility built in to Excel.

Select one of the cells in your heading row and then from the menu - Data>Filter>Autofilter.

You can now choose to show all entries where the chassis number entry (or whatever) is not blank. Having filtered the cells you can then select and copy or move as you wish.

HTH

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone