MSOffice Excel

Table of Contents

Excel: Find closest value | Get Digital Help

http://www.get-digital-help.com/2007/12/05/excel-find-closest-value/

There are instances when one wants to figure out which elements of a set of numbers (amounts) total to a target value.

http://www.tushar-mehta.com/excel/templates/match_values/index.html

Find a set of amounts that match a target value

Match two criteria and return multiple rows in excel | Get Digital Help

Question: I have a table of 3 coloms (Security name, date, price) and I have to find the price a a security at a certain date in a table that contain many securities and prices for this securities for different dates.

http://www.get-digital-help.com/2010/02/11/match-two-criteria-and-return-multiple-rows-in-excel/

BET: Microsoft Excel Functions Advanced - INDEX & SMALL - Particular Occurrence

Excel Web Links -- Developers

Liste des FONCTIONS d' EXCEL 2003 (exemples, date, function, anglais, français)

MS Excel Topics

MS Excel Topics: Formulas/Functions (By Category)

Office

Vertex42 - Excel Templates, Calendars, Calculators and Spreadsheets

MrExcel.com | Excel Resources | Excel Seminars | Excel Products

The Spreadsheet Page - By John Walkenbach

Excel VBA. FREE Excel VBA Code & Excel Macro Help

TRY OUT: Smart-VBA | Code-VBA | Analyzer-XL | Downloader-XL | Trader-X Excel VBA & Macro Code Tips, Tricks FREE Excel Downloads All Excel downloads below here are free. Excel Forum FAQ List of the most popular asked questions in the Excel help forum . Excel Formulas through to Excel VBA macro code. Excel VBA Frequently Asked Questions and Answers An ever growing list of popular questions and answers on both Excel, Excel macros and Excel VBA