Loading...

Excel Magic Trick 709: Defined Name Dynamic Range Formula w Relative References & Data Extract

14,421 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Sep 3, 2010

See how to create an Excel solution that allows user to type in an area code and retrieve phone numbers of all suppliers in the area code. See these Excel tricks:
1. Create A Defined Name for dynamic Range using Relative References, not Absolute References.
2. Create Counting formula that will count phone numbers in a given area code
3. Create Array Formule for eaxtracting phone numbers and supplier data.
4. See the functions: OFFSET, COUNTA, SUMPRODUCT, SEARCH, IF, ROWS, INDES, SMALL, ROW

Download file: http://people.highline.edu/mgirvin/Ex...

Loading...

Advertisement
to add this to Watch Later

Add to

Loading playlists...