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 date
Database functions General information about the database functions in Excel. 1998-11-25
Look up unique values Look up unique values or items 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
Return every n-th item Return every n-th item from a worksheet range. 2000-02-05
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
Erlandsen Data Consulting     http://www.erlandsendata.no/   
Excel & VBA Tips   Copyright ©1999-2024    Ole P. Erlandsen   All rights reserved
E-mail Contact Address