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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

Filter

ResolvedVersion 2003

Wed 8 Apr 2009, 16:11 Delegate Tikara said...

Tikara has attended:
Excel Introduction course

Filter

how do i filter data from my list ?

Wed 8 Apr 2009, 17:26 Trainer Simon said...

RE: filter

Hi Tikara,

Thank you for your question and welcome to the Forum.

To filter data from your list, go to Data, Filter and then Autofilter.

Each column heading will now have a filter button which you can use to select the relevant criteria.

I hope this answers your question.

Regards

Simon

Tue 14 Apr 2009: Automatically marked as resolved.

Excel tip:

Using Excel's MODE function

Use Excel's MODE function to display the most common value present in a particular range of cells.

The Mode function looks like this:

=MODE(cell range)

As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Filter

Filter

RE: filter

Excel articles

Excel tip:

Using Excel's MODE function