list management

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » List management

List management

resolvedResolved · Low Priority · Version 2003

Wassila has attended:
Excel Intermediate course

List management

I still didn't quit understand how to use the advanced filter funtions, could you please explain?

RE: List management

Hi Wassila

Thank you for your question, and apologies for the delay in replying.

To create an advanced filter, you need to have criteria set up so that Excel knows what to show in the filter results.

The criteria consists of the heading of the column you are getting Excel to look in; and what value you want it to find in that column. You can have multiple headings and values as part of your criteria.

For a simple and illustrated example of how to set up an advanced filter please see http://www.contextures.com/xladvfilter01.html

I hope this helps.
Tracy


 

Excel tip:

Use RANDBETWEEN to generate random numbers

There may be occassions where you need to generate random numbers in your spreadsheet. Use the RANDBETWEEN function to generate random numbers between two values that you specify.

The function looks like this:

=randbetween(LOW,HIGH)

where LOW is the lowest number you want generated; and HIGH is the highest number you want generated.

This formula will work with both positive and negative LOWs and HIGHs. Also it will only generate integer numbers unless forced to do otherwise by the following:

=randbetween(LOW*10^PRECISION,
HIGH*10^PRECISION)/(10^PRECISION).

where PRECISION represents the levels of decimal precision needed (i.e. if you need numbers with one decimal place, PRECISION would be 1; 2 for two decimal places and so on).

One final note, if the RANDBETWEEN formula does not work in your spreadsheet or returns a "#NAME" error, you need to install the Analysis Toolpak Add-In. You will need to press F2 then Enter following the installation.

View all Excel hints and tips


Server loaded in 0.12 secs.