ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

Valid HTML 4.01 Transitional

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Document: Description: Sort by name
Return unique items from a cell range Return all unique items from a worksheet range. 2008-08-14
Select between several options Use the CHOOSE function to select between up to 29 items. 2000-02-05
Return every n-th item Return every n-th item from a worksheet range. 2000-02-05
Look up values in your own tables Excel has several functions that can return information from your own custom tables in many different ways. Here are some of the most common functions, followed by some examples on how to use them. 2000-02-05
Look up unique values Look up unique values or items from a worksheet range 2000-02-05
Database functions General information about the database functions in Excel. 1998-11-25
Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address