You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Find Smallest and Largest.

Find Smallest and Largest.

Price: FREE

I have a column of random numbers and need to find the smallest, second smallest, third smallest, third largest, second largest, largest and highlight these numbers with different font colors.

Visit publisher's web-site: Find Smallest and Largest.

Category and Tags: ExcelTutorials : : Functions

Related Tutorials

Largest and Smallest number

Free: Yes
Tags: Excel › VBA

I have small problem.What I have to write in VB language to got
smallest and largest number from variety number .
For examples : num: 2 4 55 342 2 54 14 largest:342 smallest :2

Sort Largest to smallest automatically

Free: Yes
Tags: Excel ›

I have a spreadsheet where I would like to sort largest to smallest automatically as the numbers are updated. Column A is the name and Column B the number.
Example attached

Smallest to Largest

Free: Yes
Tags: Excel ›

I have column A ranging from (Seq)1 - 30 with numeric value. Column B with (Description)Text names. The data is to be linked so that whenever the seq changes, it updates the cells in the worksheet containing th formula. A1 B1
1 A
3 B
2 C
I have tried the SMALL function but don't know how to link the two columns.

Is it possible to customize the autofilter dropdown list?

Free: Yes
Tags: Excel ›

I have one column, which contains number from 1 to 5. And if I show the autofilter dropdown list, it will look like:
sort smallest to largest
sort largest to smallest
sort by color
Clear filter form
Filter by color
Number filter
Search
(select All)
Is it possible to add the description to all the numbers in the dropdown list? For example,
sort smallest to largest
sort largest to smallest
sort by color
Clear filter form

Save a sorting rule

Free: Yes
Tags: Excel ›

I need to sort a set of cells repeatedly using a sorting rule that has multiple levels (e.g., sort on date from largest to smallest, then sort on sales total from largest to smallest, then sort on years with the company from largest to smallest etc.) It takes a while to set up the sorting rule each time.
I currently use Data ribbon, then Sort icon on that ribbon.
Is there a way to save a sorting rule like that and then reuse it?

Related Applications & Scripts

Smooth Button Zoom Animation w/ dynamic CSS & text

Free: No
Tags: Flash › Excel Horizontal Menus Menus

This button effect has the following features:
- Loads an external css file and external text file to allow for easy editing. ie. its setup so the textbox text can be styled and the content can be updated without having to open Flash
- Programmatically animates a shadow over time
- Uses embedded fonts in CSS file declarations
something thats tricky to get working with formatting like Bold, Italic etc
- Uses a lo-res version and a high-res version of the images (bottles) and automatically swaps them out so that their smallest and largest sizes are displayed at correct times in order to avoid scaling distortion
- There are several parameters like xPos, yPos, start and end scale, spacing, rotation etc than can easily be experimented with

Google Analytics Geo Explorer

Free: Yes
Tags: Ajax › Excel Miscellaneous

Google Analytics provides its users with a lot of useful statistical data, including detailed data about the geographical distribution of site visitors.
GeoExplorer uses this data to get very detailed, flexible and interactive presentations of the distribution of your site visitors around the world. You can zoom in on even the smallest town.
This presentation will be made with the Free Map24 Ajax API.

TypoTracker - Find the cheapest eBay listings instantly!

Free: Yes

With TypoTracker, you can quickly and easily find misspelled ebay auctions. This results in huge discounts, as no one else can find them!
Many eBay auctions contain typing errors in their titles. For example, 'computer' may be misspelled 'coputer'. This means that when someone searches for 'computer', the misspelled 'coputer' is not shown. Thus no bids are placed on the 'coputer' auction.
TypoTracker generates common misspellings of the keyword you enter in the form above. This allows you to find the elusive 'coputer' listing... Since no one else can find it and bid on it, you bag yourself a bargain!

JavaScript Open Source Scripts

Free: Yes
Tags: JavaScript › Excel Web Sites

JavaScript is a scripting language most often used for client-side web development. JavaScript is used in millions of Web pages to add functionality, validate forms, detect browsers, and much more. Although best known for its use in websites (as client-side JavaScript), JavaScript is also used to enable scripting access to objects embedded in other applications. Open Source Scripts offers the worlds largest collection of open source JavaScript applications, programs, examples and downloads.

Moneybookers for Magento

Free: Yes

Moneybookers is an all in one payments solution that enables a merchant to accept debit and credit card payments, bank transfers and the largest range of local payments directly on your website.
- Widest network of international and local payment options in the world.
- One interface including payments, banking and marketing.
- Direct payments without the need for direct registration.
- Moneybookers stands for a highly converting payment gateway that turns payment processing into a simple, fast and customer friendly operation.
- Highly competitive rates.

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing