Mr Excel&excelisfun Trick 98: Extract&Lookup Number When Table Of Numbers Is In A Single Cell

ExcelIsFun

  • Currently 0.00/5
  • 1
  • 2
  • 3
  • 4
  • 5
Rating: 0.0 out of 0 votes
Comments (0)

Refresh page if video doesn't load!!! Download Video Mr Excel&excelisfun Trick 98: Extract&Lookup Number When Table Of Numbers Is In A Single Cell

You need to have the Flash Player installed and a browser with JavaScript support.


Lights off
Sorry, your favorites list is FULL.

Link to this video

Description

See Mr Excel and excelisfun use two methods to:1. Check whether Numbers In Cell C2 Also In F2?2. Mr Excel does VBA solution3. Excelisfun does Formulas Solution. See how to increment the numbers 1, 4, 7,... with ROWS Function; extract Characters from a cell with MID function.; use MID function and array constant to create a lookup table from data in a single cell; Use MATCH and ISNUMBER functions to check whether or not numbers in cell C2 are also in F2.

Tags



Comments

Be the first to comment

Sign in or sign up to post comments.
Artist: ExcelIsFun
Video title: Mr Excel&excelisfun Trick 98: Extract&Lookup Number When Table Of Numbers Is In A Single Cell
Category: Education
Views: 1071
Submitted by: admin