Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Unique Item

Unique Item

ResolvedVersion 2003

Thu 19 Mar 2009, 16:50 Delegate David said...

David has attended:
Excel VBA Intro Intermediate course

Unique Item

What's the fastest way to select unique items from a list of data? For example, how would you find all the items sold by a particular salesperson?

Fri 20 Mar 2009, 11:06 Trainer Stephen said...

RE: Unique Item

Hi David

Thank you for your question

I would suggest using the autofilter method of the range object. This has the following arguments

Worksheets("MySheet").Range("A1").AutoFilter _

    field:=3, _

    Criteria1:="Davolio"

Field is the field to filter on and criteria is the criteria.

Copy the above into your VBA, select autofilter and press Fo get detailed help

Regards

Stephen

Thu 26 Mar 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips

Unique Item

Unique Item

RE: Unique Item

Excel articles

Excel tip:

Closing Multiple Workbooks quickly